The issue is the locks held by ImageSQL.  You can read all the Allbase
manuals and you will find this command:

SET SESSION ISOLATION LEVEL RU;

This eliminates most of the locks and allows the query to complete.

Rgds
Mel Rees
CMT, Inc

On Wed, 23 Jun 2004 15:31:17 -0500 (Central Daylight Time), Cathlene
Mc Rae <[log in to unmask]> wrote:

>isql=> SELECT * FROM VFDS02.DBFL39;
>IMAGE/SQL error 160; TurboIMAGE error 62; TurboIMAGE intrinsic 409,
>Auxiliary error 0.  (DBERR 13552)
>
>
>The error may be due to the locksizelevel configurated on your image
>database. also see KBAN00000399
>use dbutil
>show dbname locksizelevel
>if the locksizelevel is at the default value which is 6, increase it to
>12
>
>set dbname locksizelevel=12
>
>also enable the database for dumping.
>
>enable dbname for dumping.
>
>You must have exclusive use of the root file (no users) to make the above
>changed.
>
>Cathlene Mc Rae
>HP Response Center.
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *