RE: SQL State 55019

SQL0007 Reason code 9 - Index is currently held or is not valid
Following
CPF5090 The unique keyed access path of member WORKP00004 file ... cannot be maintained.

What does that mean?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Friday, December 16, 2011 2:09 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL State 55019

On 16-Dec-2011 09:18 , Dan Kimmel wrote:

55019 The table is in an invalid state for the operation

Anyone know what this really means? I have a SQL insert trigger on a
table that deletes and inserts records into another table. The
triggered table inserts worked, the inserts into the other table threw
this error. Started throwing the error about 6:00 last night and
continued until about 9:44 this morning when it started working again.

The associated SQLcode to that SQLState has a corresponding SQL#### message. The joblog for the code that was running when the error was received may provide more specific details, including the message and replacement text, plus any preceding message(s) that may have contributed to the condition effecting the SQLcode as the logged error message. Also knowing the time-frame, the journal for the "other table"
can be reviewed by DSPJRN for what happened to that TABLE, both when the error started and later stopped occurring, and in what job the work against the table transpired of which the other joblog(s) may be reviewed as well.

Otherwise various SQLcodes which might arise from that SQL state are listed; just repeat "find" requests in the text of [in the respective release docs]:

_Listing of SQL messages_
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzala/rzalaml.htm
"
These tables list SQL messages. Use these tables to find message text, cause text, recovery text, and corresponding SQLCODEs and SQLSTATEs.

You can use the following tables with both positive and negative SQLCODEs. Take the absolute value of the SQLCODE, then append it to the letters SQL (for SQLCODEs less than 10 000) or the letters SQ (for SQLCODEs greater than or equal to 10 000) to determine the message identifier. Each SQLCODE corresponds to one or more SQLSTATEs.
"

Regards, Chuck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.