DB2 Version 9.7 for Linux, UNIX, and Windows

client_protocol - Client communication protocol monitor element

The communication protocol that the client application is using to communicate with the server.

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
Unit of work - -
Connections event_connheader -
Threshold violations event_thresholdviolations -

Usage

This element can be used for problem determination for remote applications. Values for this field are:
SQLM_PROT_UNKNOWN
The client is communicating using an unknown protocol. This value will only be returned if future clients connect with an earlier level of the server.
SQLM_PROT_LOCAL
The client is running on the same node as the server and no communications protocol is in use.
SQLM_PROT_TCPIP
TCP/IP
SQLM_PROT_TCPIP4
TCP/IP4
SQLM_PROT_TCPIP6
TCP/IP6
SQLM_PROT_IPXSPX
IPX/SPX
SQLM_PROT_NPIPE
Named Pipe Protocol
If using the APPLICATIONS administrative view this monitor element returns a text identifier, value for this field is one of:
  • LOCAL
  • NPIPE
  • TCPIP
  • TCPIP4
  • TCPIP6
Parent topic: Database system monitor elements