G

global_transaction_id - Global transaction identifier monitor element

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

Table 1. 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 2. 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 3. 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 4. 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 5. 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 6. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_INSTANCE table function - Get instance level information	Always collected

Table 7. 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 8. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_INSTANCE table function - Get instance level information	Always collected

Table 9. 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 10. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_INSTANCE table function - Get instance level information	Always collected

Table 11. 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 12. 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 13. 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 14. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_INSTANCE table function - Get instance level information	Always collected

Table 15. 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.