IDS Forum

Re: Meaning ISAM CODE

Posted By:
Date:

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

Messages In This Thread

• Meaning ISAM CODE
  Support Informix -- Monday, 24 February 2003, at 5:51 a.m.
  • RE: Meaning ISAM CODE
    Konikoff, Rob (Contractor) -- Monday, 24 February 2003, at 6:46 a.m.
  • Re: Meaning ISAM CODE
    Mark D. Stock -- Monday, 24 February 2003, at 6:47 a.m.
  • Re: Meaning ISAM CODE
    Martin Fuerderer -- Monday, 24 February 2003, at 7:12 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.