DCS Database (KUD_DB2_DCS_Database) attributes

The DCS Database attributes provide Direct Connection Service (DCS) database information for the monitored database gateway.

You can use this information to monitor DCS database specific attributes, such as DCS connection response times and communication errors.

DB Name The real name of the host database for which information is collected or to which the application is connected. This name was given to the database when it was created. The value format is a simple text string with a maximum of 60 bytes.

DB Partition The DB2® database partition node number, which can range from 0 to 999. The Aggregated and Current® Partition values can be used within a query or situation filter. If a db partition filter is not specified, data is returned for the current database partition. If a db partition filter is set to Aggregated, only aggregated partition data is returned. Historical data collection includes both aggregated and individual partition attribute data. In addition to numeric partition numbers in the 0 to 999 range, the following values are also valid:
External value Internal value
Aggregated -1
Current Partition -2
All -3
GW Comm Errors for Interval The number of times during the monitoring interval that a communication error (SQL30081) occurred while a DCS application tried to connect to a host database, or while it was processing an SQL statement. The following value is valid:
External value Internal value
Value_Exceeds_Maximum 9223372036854775807

GW Comm Errors for Interval (Superseded) The number of times during the monitoring interval that a communication error (SQL30081) occurred while a DCS application tried to connect to a host database, or while it was processing an SQL statement.

GW Cons Wait Host The current number of connections to host databases that the DB2 Connect gateway is handling, and that are waiting for a reply from the host. The following value is valid:
External value Internal value
Value_Exceeds_Maximum 9223372036854775807

GW Cons Wait Host (Superseded) The current number of connections to host databases that the DB2 Connect gateway is handling, and that are waiting for a reply from the host.

GW Cur Cons The current number of connections to host databases that the DB2 Connect gateway is handling. The following value is valid:
External value Internal value
Value_Exceeds_Maximum 9223372036854775807

GW Cur Cons (Superseded) The current number of connections to host databases that the DB2 Connect gateway is handling.

Host Throughput for Interval The host throughput in bytes per second for the monitoring interval. This number represents bytes sent plus the number of bytes received divided by the cumulative host response time. The value format is an integer. The following value is valid:
External value Internal value
Value_Exceeds_Maximum 9223372036854775807

Host Throughput for Interval (Superseded) The host throughput in bytes per second for the monitoring interval. This number represents bytes sent plus the number of bytes received divided by the cumulative host response time. The value format is an integer.

Host Time per Stmt for Interval The host response time (in seconds) over the last interval, including any network time over the last interval, divided by the number of statements attempted over the last interval. The value format is an integer. The following value is valid:
External value Internal value
Value_Exceeds_Maximum 9223372036854775807

Host Time per Stmt for Interval (Superseded) The host response time (in seconds) over the last interval, including any network time over the last interval, divided by the number of statements attempted over the last interval. The value format is an integer.

Instance Name The name of the monitored DB2 instance (Unicode). The valid format is a text string with a maximum of 60 bytes.

Network Time per Stmt The total host response time minus the total statement execution time divided by the total number of attempted statements. The value format is an integer. The following value is valid:
External value Internal value
Value_Exceeds_Maximum 9223372036854775807

Network Time per Stmt (Superseded) The total host response time minus the total statement execution time divided by the total number of attempted statements. The value format is an integer.

Node Name For new installations of version 6, release 2, the format is instanceid:hostname:UD for all operating systems. The format for version 6, release 1 of the DB2 Connect agent on Windows systems is instanceid:hostname:UD; on UNIX and Linux® systems, the format is instanceid:hostname.

Recent Conn Rsp Time The elapsed time (in seconds) between the start of connection processing and actual establishment of a connection for the most recent DCS application that connected to this database. The following value is valid:
External value Internal value
Value_Exceeds_Maximum 9223372036854775807

Recent Conn Rsp Time (Superseded) The elapsed time (in seconds) between the start of connection processing and actual establishment of a connection for the most recent DCS application that connected to this database.

Snapshot Timestamp The date and time when the database system monitor information was collected. Use this attribute to help relate data chronologically if you are saving the results in a file or database for ongoing analysis.

Time per Stmt The statement execution time (in seconds) divided by the number of attempted statements. The value format is an integer. The following value is valid:
External value Internal value
Value_Exceeds_Maximum 9223372036854775807

Time per Stmt (Superseded) The statement execution time (in seconds) divided by the number of attempted statements. The value format is an integer.