DSNI031I   csect-name - LOCK ESCALATION HAS OCCURRED FOR RESOURCE NAME = resource-name, LOCK STATE = lock-state, PLAN NAME : PACKAGE NAME = plan-name:package-name, COLLECTION-ID = collection-id, STATEMENT NUMBER = statement-number, CORRELATION-ID = correlation-id, CONNECTION-ID = connection-id, LUW-ID = luw-id, THREAD-INFO = thread-information

Lock escalation has occurred for the specified object.

csect-name

The name of the control section that issued the message.

resource-name

The name of the escalated resource. The format of resource-name depends on the type of table space:

Simple or partitioned table spaces

database-name.tablespace-name

Segmented table space

Either creator-name.table-name or DBID.OBID of the table

lock-state

The lock state of the escalated resource, after escalation.

plan-name

The name of the executing plan that is associated with this thread.

package-name

The name of the executing package that is associated with this thread, if one exists.

collection-id

The collection identifier of the package resource, if one exists.

statement-number

The statement number of the executing SQL statement that is associated with this plan.

correlation-id

The correlation identifier of the thread that is associated with the escalated resource.

connection-id

The connection identifier of the thread that is associated with the escalated resource.

luw-id

The logical unit of work identifier of the thread that is associated with the escalated resource.

thread-information

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.