00C9008E
Explanation
A lock request for the resource identified by NAME could not be granted, and the request waited for a period longer than the maximum specified by the installation.
System action
The data manager function that detected this condition returns 'resource not available' to its invoker.
Message DSNT378I might also be issued.
Problem determination
The requested operation is not performed. An SQLCODE -904, -911, -913, or -923 is issued, and/or message DSNT501I is issued. If a timeout occurs, see also the "System Programmer Response" for message DSNT376I for problem determination.
SYS1.LOGREC contains information in the variable recording area (VRA) of the system diagnostic work area (SDWA). Significant fields for this code are: VRARRK13, VRARRK14, and VRARRK15. 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.
- 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.
- Listing of SYS1.LOGREC data set, obtained by executing IFCEREP1.
- IRLM trace output.
- SYSPRINT output, including JCL, for the application program or batch job, and system messages that were issued. Make sure that MSGLEVEL=(1,1) on the JOB statement so that all diagnostic information is sent to SYSPRINT.
- Listing of the IRLM procedure.
- Results from SELECT * from SYSIBM.SYSDATABASE.