00C90088   

Explanation

The resource identified by NAME in message DSNT501I is involved in a deadlock condition.

System action

The requested operation is not performed.

System programmer response

If the deadlock condition becomes chronic, examine the mix of applications running to determine why the deadlock is occurring.

User response

Rerun the application.

Problem determination

The requested operation is not performed. An SQLCODE -911, -913, or -923 is issued, and/or message DSNT501I is issued.

If statistics trace class 3 is active, IFCID 172 contains diagnostic information. 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.

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.
  • 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.