DB2 Version 9.7 for Linux, UNIX, and Windows

tpmon_client_userid - TP monitor 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.

This monitor element is synonymous to the 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. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	appl_info	Basic
DCS Application	dcs_appl	Basic

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Activities	event_activity	-
Deadlock	event_dlconn	-
Transaction	event_xact	-

Usage

Use this element in application server or Transaction Processing monitor environments to identify the end-user for whom the transaction is being executed.