DB2 Version 9.7 for Linux, UNIX, and Windows

client_pid - Client process ID monitor element

The process ID of the client application that made the connection to the database.

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
Table 2. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application appl_info Basic
Application appl Basic
DCS Application dcs_appl_info Basic
Table 3. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Threshold violations event_thresholdviolations -
Unit of work - -
Connections event_connheader -

Usage

You can use this element to correlate monitor information such as CPU and I/O time to your client application.

In the case of a DRDA® AS connection, this element will be set to 0.