DSNT773I   csect-name SERVER DISTRIBUTED AGENT WITH LUWID=luwid=token THREAD-INFO=thread-information FOR LOCATION=location RECEIVED IDLE THREAD TIMEOUT WARNING DUE TO PROFILE ID=profile-id

Explanation

A monitor profile has detected that an idle thread timeout warning condition occurred.

csect-name
The name of the control section that issued the message.
luwid=token
The logical unit of work identifier (LUWID) and a six-digit token value. The token value can be used in any DB2® command that accepts an 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.

location
The IP address of the requester.
profile-id
The profile ID of the monitor profile (defined in DSN_PROFILE_TABLE) that detected the condition.

System action

This message is issued once for a thread while the thread remains in an idle state. After a COMMIT or ROLLBACK is performed, and no resources are active past the end of the unit of work, DB2 removes the warning against the thread.

Operator response

Notify the system programmer.

System programmer response

Use the information in the message to determine which application was running when the warning occurred. Fix any application errors that caused the timeout.