00C900D0
Explanation
An attempt was made to access a value in a column with one of the LOB data types (BLOB, CLOB, DBCLOB), but the value of the column is no longer valid.
System action
The operation is not allowed. Db2 returns 'resource not available' to its invoker.
System programmer response
Use the CHECK LOB utility to identify the invalid LOBs. Use update to replace or delete the invalid LOBs.
If you suspect an error in Db2, you might need to report the problem. For information about identifying and reporting the problem, see Collecting diagnostic data.
Problem determination
The requested operation is not performed. An SQLCODE -904 is issued. Message DSNT500I or message DSNT501I may also be issued.
Collect the following diagnostic items:
- Console output from the system on which the job was run, and a listing of the SYSLOG data set for the period of time that spans the failure.
- SVC dump (or system dump), taken to SYS1.DUMPxx data set, as result of an operator-initiated dump command or SLIP trap exit.
- A listing of the SYS1.LOGREC data set, obtained by executing IFCEREP1.