DSNT376I   PLAN=plan-name1 WITH CORRELATION-ID=correlation-id1 CONNECTION-ID=connection-id1 LUW-ID=luw-id1 THREAD-INFO=thread-information1 IS TIMED OUT. ONE HOLDER OF THE RESOURCE IS PLAN=plan-name2 WITH CORRELATION-ID=correlation-id2 CONNECTION-ID=connection-id2 LUW-ID=luw-id2 THREAD-INFO= thread-information2 ON MEMBER member-name

A plan has been denied an IRLM lock because of a timeout. The maximum amount of time to wait for a locked resource was exceeded.

plan-name1 and plan-name2

The names of the executing plans.

plan-name1

The plan that was denied an IRLM lock.

plan-name2

One of the plans holding a lock on the resource. The listed plan is not necessarily responsible for the timeout condition.

Several different system plans can appear in plan-name1 and plan-name2. These system plans are not documented in SYSIBM.SYSPLAN. If you receive a system plan in this message, you are in contention with another user. If you are not doing an automatic rebind, message DSNT500I or DSNT501I might accompany this message and identify that resource. If you need additional information, see the SQLCA and any additional bind messages. (If you are performing an automatic rebind, the SQLCA is not available.) The system plans are:

• ACT
• BCT
• DISTSERV
• DSNBIND
• STARTCT
• DSNUTIL

correlation-id1 and correlation-id2

The correlation identifiers of the threads that are associated with, respectively, plan-name1 and plan-name2. Correlation IDs that begin with values between 001 and 028 identify system agents.

connection-id1 and connection-id2

The connection identifiers of, respectively, plan-name1 and plan-name2. If the execution of the plan was switched by DB2® to a system agent, the connection identifier is the DB2 subsystem name.

luw-id1 and luw-id2

The logical unit of work identifiers (LUWIDs) of, respectively, plan-name1 and plan-name2.

*

The thread does not have a LUWID.

luw-id=token

The logical unit of work ID and a six-digit token value. The token value can be used in any DB2 command that accepts a LUWID as input.

thread-information1 and thread-information2

Information about the thread. The information is presented in a colon-delimited list that contains the following segments:

• The primary authorization ID that is associated with the thread.
• The name of the user's workstation.
• The ID of the user.
• The name of the application.
• The statement type for the previously executed statement: dynamic or static.
• The statement identifier for the previously executed statement, if available. The statement identifier can be used to identify the particular SQL statement. For static statements, the statement identifier correlates to the STMT_ID column in the SYSIBM.SYSPACKSTMT table. For dynamic statements, the statement identifier correlates to the STMT_ID column in the DSN_STATEMENT_CACHE_TABLE table. That statement might not have contributed to the current failure.
• The name of the role that is associated with the thread.
• The correlation token that can be used to correlate work at the remote system with work performed at the DB2 subsystem. The correlation token, if available, is enclosed in '<' and '>' characters, and contains three components, separated by periods:
  • A 3 to 39 character IP address.
  • A 1 to 8 character port address.
  • A 12 character unique identifier.

An asterisk (*) in any segment indicates that the information is not available.

member-name

The name of the member of the DB2 subsystem on which the thread associated with plan-id2 is executing.