DB2 Version 9.7 for Linux, UNIX, and Windows

auth_id - Authorization ID monitor element

The authorization ID of the user who invoked the application that is being monitored. On a DB2 Connect™ gateway node, this is the user's authorization ID on the host.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	appl_id_info	Basic
Lock	appl_lock_list	Basic
DCS Application	dcs_appl_info	Basic

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

Usage

In an explicit trusted connection, the auth_id value does not change immediately when you switch users. Rather, the auth_id is updated the first time you access the database after switching users. This is because the switch user operation is always chained to the subsequent operation.

You can use this element to determine who invoked the application.