DB2 Version 9.7 for Linux, UNIX, and Windows

client_wrkstnname - Client workstation name monitor element

Identifies the client's system or workstation (for example CICS® EITERMID), if the sqleseti API was issued in this connection. The current value of the CLIENT_WRKSTNNAME 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_wkstn monitor element. The client_wrkstnname 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_wkstn 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 table function - Get connection metrics	Always collected
MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document)	Always collected
MON_GET_UNIT_OF_WORK table function - Get unit of work metrics	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

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

Threshold violations	event_thresholdviolations	-

Usage

Use this element to identify the user's machine by node ID, terminal ID, or similar identifiers.