Start of change

DSNT378I   csect-name PLAN=plan-name WITH CORRELATION-ID=correlation-id CONNECTION-ID=connection-id LUW-ID=luw-id THREAD-INFO=thread-information TIMED OUT BECAUSE OF A RETAINED LOCK HELD BY MEMBER member-name

Explanation

A plan cannot get an IRLM lock because the resource is held by a retained lock on behalf of another member in the data sharing group, and the amount of time to wait for the locked resource was exceeded. The member holding the retained lock has either failed, or is in the process of restarting to recover its retained locks.

plan-name
The name of the executing plan that is associated with this thread.
correlation-id
The correlation identifier of the thread that is associated with the plan identified by plan-id. Correlation IDs that begin with values between 001 and 028 identify system agents.
connection-id
The connection identifier of the plan identified by plan-name.
luw-id
The logical unit of work identifier (LUWID) of plan-name.
*
The thread does not have a LUWID.
luw-id=token
The logical unit of work ID and a five-digit token value. The token value can be used in any DB2® command that accepts a LUWID as input.
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.

member-name
The name of the member of the failed or restarting DB2 subsystem that holds the conflicting retained lock.

This message is issued only if the RETLWAIT installation parameter in DSN6SPRM is set to YES. If RETLWAIT is set to NO, which is the default setting, then any IRLM lock that conflicts with a retained lock will not wait, but instead will be rejected immediately. (See reason codes 00C900BE and 00C20254.)

System action

Processing continues.

The SQLCA that corresponds to the correlation ID, connection ID, and LUWID of the plan identified by plan-name contains the name of the resource that is involved in the timeout and one of the following SQL codes: -904, -911 , -913, or -923.

System programmer response

Restart the member holding the retained lock, if it has not already been restarted.

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.
  • Dynamic dump, taken to SYS1.DUMPxx data set, by DB2 (04E and 04F abends).
  • SYSABEND, SYSUDUMP, or SYSMDUMP output.
End of change