Meaning ISAM CODE
Hi, Last week we have an error : SQLCA DEBUG:SQLCODE:<-245>|SQLERRD [1]: NOT USED:<1>|[2]: SERIAL/ISAM:<-154>| I know how to find the meaning of the SQL code. However, how can I find the meaning of the ISAM code ? Thanks forever, Yves Dieltiens ------_=_NextPart_001_01C2DBF2.7035AE50 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>Hi,</SPAN></FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>Last week we have an error :</SPAN></FONT><FONT face=Arial size=2> </FONT></DIV> <DIV><FONT face=Arial size=2>SQLCA DEBUG:SQLCODE:<-245>|SQLERRD [1]: NOT USED:<1>|[2]: SERIAL/ISAM:<-154>|</FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>I know how to find the meaning of the SQL code.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>However, how can I find the meaning of the ISAM code ?</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>Thanks forever,</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>Yves Dieltiens</SPAN></FONT></DIV></BODY></HTML> ------_=_NextPart_001_01C2DBF2.7035AE50--
In HPUX, findding the error messages are done from a command line. Example: finderr 154 Returns: -154 ISAM error: Lock Timeout Expired. (with a succinct explanation) Rob Konikoff Eagle Group-2CMMC Ft Bragg COMM:910-396-1686/1096/6105/4883 DSN:236-XXXX Have you tried FINLOG today? http://www.finlogonline.com -----Original Message----- From: Support Inf.... [mailto:supinformix@dofi.fgov.be] Sent: Monday, February 24, 2003 5:52 AM To: ids@iiug.org Subject: Meaning ISAM CODE [475] Hi, Last week we have an error : SQLCA DEBUG:SQLCODE:<-245>|SQLERRD [1]: NOT USED:<1>|[2]: SERIAL/ISAM:<-154>| I know how to find the meaning of the SQL code. However, how can I find the meaning of the ISAM code ? Thanks forever, Yves Dieltiens ------_=_NextPart_001_01C2DBF2.7035AE50 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>Hi,</SPAN></FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>Last week we have an error :</SPAN></FONT><FONT face=Arial size=2> </FONT></DIV> <DIV><FONT face=Arial size=2>SQLCA DEBUG:SQLCODE:<-245>|SQLERRD [1]: NOT USED:<1>|[2]: SERIAL/ISAM:<-154>|</FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>I know how to find the meaning of the SQL code.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>However, how can I find the meaning of the ISAM code ?</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>Thanks forever,</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=265274410-24022003>Yves Dieltiens</SPAN></FONT></DIV></BODY></HTML> ------_=_NextPart_001_01C2DBF2.7035AE50--
Support Inf.... wrote: > Hi, > > Last week we have an error : > SQLCA DEBUG:SQLCODE:<-245>|SQLERRD [1]: NOT USED:<1>|[2]: > SERIAL/ISAM:<-154>| > I know how to find the meaning of the SQL code. > However, how can I find the meaning of the ISAM code ? The same way. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+
Hi,
finding out the meaning of ISAM errors works pretty much the same way as
for SQL errors :
% finderr 154
-154 ISAM error: Lock Timeout Expired.
This network operation has been suspended, awaiting a response from
another database server, for the maximum duration allowed. The local
database server assumes that a distributed deadlock exists and that
this user request is awaiting a resource that was locked by a user in a
different system, which is awaiting a resource that this user owns.
Roll back the current transaction, and retry it after a delay. If this
error occurs frequently, ask the database server administrator to adjust
the length of the deadlock time-out interval.
This code is also returned when an explicit wait time limit expires;
that is, if you have SET LOCK MODE TO WAIT 3, and your request is
queued for more than 3 seconds for a lock, the operation ends with this
ISAM error code.
[ This is, because basically ISAM and SQL errors use different number
ranges. ]
Ragrds,
Martin
--
Martin Fuerderer
IBM Informix Development Munich
Data Management Solutions
"Support Inf...." <supinformix@dofi.fgov.be>
Sent by: forum.subscriber@iiug.org
24.02.2003 11:51
To: ids@iiug.org
cc:
Subject: Meaning ISAM CODE [475]
Hi,
Last week we have an error :
SQLCA DEBUG:SQLCODE:<-245>|SQLERRD [1]: NOT USED:<1>|[2]:
SERIAL/ISAM:<-154>|
I know how to find the meaning of the SQL code.
However, how can I find the meaning of the ISAM code ?
Thanks forever,
Yves Dieltiens