gbp_update_time - Group puffer pool update time monitor element

During extent movement, this monitor element shows the cumulative time taken to update cached page locations for moved extents in the group buffer pool.

The value is given in milliseconds.

Table 1. Table function monitoring information
Table function Monitor element collection level
MON_GET_EXTENT_MOVEMENT_STATUS - get extent movement progress Always collected

global_transaction_id - Global transaction identifier monitor element

The XA transaction ID in use at the time the event occurred.

Table 2. Event Monitoring Information
Event Type Logical Data Grouping Monitor Switch
Change history ddlstmtexec
txncompletion
Always collected
Unit of Work uow Always collected

Usage

For the change history event monitor, this is the global transaction ID in use at the time the event occurred. This is the data field in the SQLP_GXID structure that is part of the transaction logs.

gw_comm_error_time - Communication Error Time monitor element

The date and time when the most recent communication error (SQL30081) occurred while a DCS application was attempting to connect to a host database, or while it was processing an SQL statement.

Table 3. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Timestamp

Usage

Use this element for problem determination, in conjunction with Communication Error and the communication error logged in administration notification log.

gw_comm_errors - Communication Errors monitor element

The number of times that a communication error (SQL30081) occurred while a DCS application was attempting to connect to a host database, or while it was processing an SQL statement.

Table 4. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Basic
For snapshot monitoring, this counter can be reset.
Usage
By monitoring the number of communication errors over time, you can assess whether your Db2 Connect gateway has connectivity problems with a particular host database. You can establish what you consider to be a normal error threshold, so that any time the number of errors exceeds this threshold an investigation of the communication errors should be made.

Use this element for problem determination, in conjunction with the communication error logged in administration notification log.

gw_con_time - Db2 Connect Gateway First Connect Initiated monitor element

The date and time when the first connection to the host database was initiated from the Db2 Connect gateway.

Table 5. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Timestamp
DCS Application dcs_appl Timestamp
Usage
Use this element for problem determination on DCS applications.

gw_connections_top - Maximum Number of Concurrent Connections to Host Database monitor element

The maximum number of concurrent connections to a host database that have been handled by the Db2 Connect gateway since the first database connection.

Element identifier
gw_connections_top
Element type
watermark
Table 6. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Database dcs_dbase Basic
Usage
This element will help you understand the level of activity at the Db2 Connect gateway and the associated use of system resources.

gw_cons_wait_client - Number of Connections Waiting for the Client to Send Request monitor element

The current number of connections to host databases being handled by the Db2 Connect gateway that are waiting for the client to send a request.

Table 7. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_INSTANCE table function - Get instance level information Always collected
Table 8. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager db2 Basic
DCS Database dcs_dbase Basic
Usage
This value can change frequently. It should be sampled at regular intervals over an extended period in order to obtain a realistic view of gateway usage.

gw_cons_wait_host - Number of Connections Waiting for the Host to Reply monitor element

The current number of connections to host databases being handled by the Db2 Connect gateway that are waiting for a reply from the host.

Table 9. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_INSTANCE table function - Get instance level information Always collected
Table 10. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager db2 Basic
DCS Database dcs_dbase Basic
Usage
This value can change frequently. It should be sampled at regular intervals over an extended period in order to obtain a realistic view of gateway usage.

gw_cur_cons - Current Number of Connections for Db2 Connect monitor element

The current number of connections to host databases being handled by the Db2 Connect gateway.

Table 11. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_INSTANCE table function - Get instance level information Always collected
Table 12. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager db2 Basic
DCS Database dcs_dbase Basic
Usage
This element will help you understand the level of activity at the Db2 Connect gateway and the associated use of system resources.

gw_db_alias - Database Alias at the Gateway monitor element

The alias used at the Db2 Connect gateway to connect to the host database.

Element identifier
gw_db_alias
Element type
information
Table 13. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Application dcs_appl_info Basic
Usage
Use this element for problem determination on DCS applications.

gw_exec_time - Elapsed Time Spent on Db2 Connect Gateway Processing monitor element

The time in seconds and microseconds at the Db2 Connect gateway to process an application request (since the connection was established), or to process a single statement.

Table 14. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
DCS Application dcs_appl Statement, Timestamp
DCS Statement dcs_stmt Statement, Timestamp
For snapshot monitoring, this counter can be reset.
Usage
Use this element to determine what portion of the overall processing time is due to Db2 Connect gateway processing.

gw_total_cons - Total Number of Attempted Connections for Db2 Connect monitor element

The total number of connections attempted from the Db2 Connect gateway since the last db2start command or the last reset.

Table 15. Table Function Monitoring Information
Table Function Monitor Element Collection Level
MON_GET_INSTANCE table function - Get instance level information Always collected
Table 16. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager db2 Basic
DCS Database dcs_dbase Basic
For snapshot monitoring, this counter can be reset.
Usage
This element will help you understand the level of activity at the Db2 Connect gateway and the associated use of system resources.