00D3105D
Explanation
The number of unique application names has exceeded 6000 unique values.
System action
Db2 does not collect remote application statistics for any new application name until DDF is restarted.
Administrator response
Notify the application programmer. The application can be identified from the thread-information in the DSNL030I message.
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.
Programmer response
Consider using CLIENT_CORR_TOKEN for tracking individual connections. CLIENT_CORR_TOKEN is a unique value that allows you to correlate your business processes across the enterprise. CLIENT_APPLNAME should not be used to identify individual connections.
Problem determination
For more information, refer to thread-information in the DSNL030I message.
