DB2 Version 9.7 for Linux, UNIX, and Windows

client_prdid - Client product and version ID monitor element

The product and version that is running on the client.

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

Usage

You can use this element to identify the product and code version of the IBM® data server client. It is in the form PPPVVRRM, where:
  • PPP identifies the product, which is "SQL" for the DB2® products
  • VV identifies a 2-digit version number (with high-order 0 in the case of a 1-digit version)
  • RR identifies a 2-digit release number (with high-order 0 in the case of a 1-digit release)
  • M identifies a 1-character modification level (0-9 or A-Z).
Parent topic: Database system monitor elements
Related reference:
server_prdid - Server Product/Version ID monitor element