Spivey, John wrote:
>
> Greetings All:
>
> I'm getting this nifty little error message from ISQL:
>
> isql=> CONNECT TO 'LITEDBE';
> isql=> SELECT * FROM MSQMS.LOT_MSTR;
> Output will be truncated. (DBWARN 1)
> IMAGE/SQL error 164; TurboIMAGE error -242; TurboIMAGE intrinsic 420, &
> Auxiliary error 6554488.  (DBERR 13552)
>
> What gives?  I have changed my user attributes to MODE=1 instead of the
> default MODE=5 as graciously provided by the ATTACH command of IMAGESQL.
>  The user id is MGR (also the creator), the class is 64 and the pw is
> ';'.  This has only been problematic since the Express 3 & Express 4
> patch installations.
>
> TIA to the Image/SQL Dieties
>
> John Spivey
> Sumitomo Electric Lightwave
> Research Triangle Park, NC
> <[log in to unmask]>
 
 
"This problem may relate to an old SR, 5003232025, which I have quoted
below:
 
     IMAGE/SQL error 164; TurboIMAGE error -242; TurboIMAGE intrinsic
     420, Auxiliary error 6554488.  (DBERR 13552)
 
  Intrinsic 420 is DBXBEGIN.  The documentation in the TURBOIMAGE/XL
manual does not document this error number.  In working with the Expert
Center, it appears that -242 is a general GTX error message which
means:
 
   Unable to access file TURBOGTX.PUB.SYS
 
...There are two issues with this.  First the fact that the error is
not documented.  Second that the workaround (suspecting that the
TURBOGTX.PUB.SYS file is corrupt), is to purge TURBOGTX.PUB.SYS.
TURBOGTX is a priv mode file, which means that you have to use
FSCHECK or some other like utility to purge the file.  The file
is then rebuilt by the next DBOPEN.  Some investment should be made
into resolving why the TURBOGTX.PUB.SYS file is becoming corrupt."
 
TURBOGTX.PUB.SYS is a global transaction table used by Turbo/IMAGE
to keep track of multiple dynamic data base transactions.
 
Use FSCHECK.PRVXL.TELESUP  PURGEFILE or any other utility of your choice
to purge this PRIV file. The next DBOPEN/DBXBEGIN mode 3 or 4 will
recreate the file.
 
Let me know if you need further info.
Peggy Lacy
HP Database Expert Center