DSNL027I agent-type DISTRIBUTED AGENT WITH LUW-ID luw-id=token THREAD-INFO thread-information RECEIVED ABEND=abend-code REASON=reason-code

Explanation

A distributed agent has abended at this location.

agent-type

Information about the distributed agent that has abended:

REQUESTING

The thread is an allied thread that has distributed activity.

SERVER

The thread is a database access thread.

luw-id=token

The logical unit of work identifier (LUWID) 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.

thread-information is a colon-delimited list that contains the following segments. An asterisk (*) in any segment indicates that the information is not available.

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

abend-code

The abend code. A value of zeros indicates that the abend code could not be determined.

reason-code

A numeric value that indicates the reason for the failure. A value of zeros indicates that the reason code could not be determined.

This message might be followed by instances of message DSNL028I, each of which describes a remote location where the distributed agent also exists and where diagnostic information might also need to be collected.