DB2 Version 9.7 for Linux, UNIX, and Windows

client_applname - Client application name monitor element

Identifies the server transaction program performing the transaction, if the sqleseti API was issued in this connection. The current value of the CLIENT_APPLNAME special register for this connection, unit of work, or activity.

Note: This element is reported for the coordinating member only. On remote members, the value reported is a string with a length of 0.

This monitor element is synonymous to the tpmon_client_app monitor element. The client_applname monitor element is used for monitoring table functions and event monitors that write to unformatted tables, which were introduced in DB2® Version 9.7. The tpmon_client_app monitor element is used for snapshot monitors and event monitors that write to tables, files, and pipes.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document)	Always collected
MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document)	Always collected
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document)	Always collected
MON_GET_CONNECTION table function - Get connection metrics	Always collected
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics	Always collected

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	-	-
Unit of work	-	-
Threshold violations	event_thresholdviolations	-

Usage

Use this element for problem determination and accounting purposes.