DSNU120I csect-name DEADLOCK INFORMATION: INTERVAL COUNT = interval-count, NUMBER OF WAITERS = waiter-count.

Explanation

Utility processing encountered a resource that is currently unavailable because the resource is involved in a deadlock condition.

csect-name
The name of the control section that issued the message.
interval-count
Unique ID for this deadlock interval.
waiter-count
The number of waiters involved in the timeout.

The introductory message text is followed by set of column headings and one or more rows with information about the resource holders: 

LOCK NAME   TYPE        FUNC/STATE/DURATION  HOLDER/WAITER  PLAN-ID  CORR-ID          MEMBER NM
lock-name   lock-type   lock-information     hw-type        plan-id  correlation-id   member-name
LOCK NAME lock-name
The lock resource name.
TYPE lock-type
The type of lock, such as PG or DBD.
FUNC/STATE/DURATION lock-information
Information about the lock function, state, or duration. Expected values depend on the type of information.
Lock function
The requested lock function: LOCK, UNLOCK, or CHANGE.
Lock state
The lock resource state, such as SHARED or EXCLUSIVE.
Lock duration
The lock resource duration, such as MANUAL or PLAN.
HOLDER/WAITER hw-type
Indicator if the resource is a holder or a waiter.
PLAN-ID plan-id
The plan name of the holder or waiter.
CORR-ID correlation-id
The correlation ID of the holder or waiter.
MEMBER NM member-name
The Db2 member name.

System action

The utility abnormally terminates with a X'04E' abend and a utility reason code. The dump is suppressed. Message DSNT500I is issued.

System programmer response

Use the information provided in messages DSNU121I (specifically information about holders and waiters) and DSNT500I to identify the lock resources and the utility jobs and applications that are involved in the deadlock.

User response

Use the TERM UTIL command to restart or terminate the utility.

Problem determination

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.