DB2 Version 9.7 for Linux, UNIX, and Windows

client_userid - Client user ID monitor element

The client user ID generated by a transaction manager and provided to the server, if the sqleseti API is used. The current value of the CLIENT_USERID 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_userid monitor element. The client_userid 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_userid 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 in application server or Transaction Processing monitor environments to identify the end-user for whom the transaction is being executed.