Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 5.9.3.10 - User Guide

Introduction to Foglight for DB2 LUW Using Foglight for DB2 LUW Reference
Dashboards and Views Collections and Metrics
CF Locks Collection CF Memory Pools Collection CF Resource Usage Collection Current Agents Details Collection Agents Summary Collection Current Locks Wait Collection Database Bufferpools Summary PS Collection Database Configuration Collection Database Tablespaces Collection Database Tablespaces Summary Collection Database Usability Collection Database Parameters Collection Database Instance Parameters Collection Database Instance Registry Variables Collection Database Tablespaces BP Collection FCM Activity Collection FS DB Storage Collection FS DB Storage Summary Collection FS Instance Storage Collection FS Storage Collection FS Storage Summary Collection General Activity Collection HADR Activity Collection Host Properties Collection OS General Collection Instance Activity Collection Instance General Collection Instance Nodes Collection Instance Usability Collection IO Activity Collection License Details Collection Log Activity Collection Log File Collection Log Message Collection Messages Count Collection Monitor Switches Collection OS DB2 General Process Collection Partition Tablespaces Summary Collection Partition Usability Collection pureScale Alerts Collection Top SQLs Collection Top SQLs Full Text Collection Top SQLs Text Collection Query Agents Details Collection Database Partition Activity Collection DB2 Partition Subcategories Wait Collection History Locks Wait Collection History Locks Summary Collection Instance Memory Collection Instance Memory Pool Collection Instance Memory Summary Collection Instance Memory Total Collection Database Memory Collection Database Memory Pool Collection Database Memory Pool DB Collection Database Memory Summary Collection Database Memory Total Collection Database Buffer Pools Collection Database Tables Collection Database Partition Backup Collection Database Tables Global Collection Database Applications Collection

Database Usability Collection

The following table provides a list of the Database Usability metrics that are collected, and a description for each.

DB_RESPONSE_TIME

The response time of a query representing the general workload (“select 1 from sysibm.sysdummy1”) when the connection is already open.

DB_CONNECTION_TIME

The time for establishing the connection.

DB_CONNECTION_AVAILABILITY

The percent of nodes for which the connection is available.

Database Parameters Collection

The following table describes the metrics that are collected for each database configuration parameter.

DATABASE_NAME

The name of the monitored database.

NAME

The configuration parameter name.

CURRENT_VALUE

The current value of the configuration parameter stored in memory, in partition/member 0.

VALUE_FLAGS

Provides information about the current value of the configuration parameter. Values:

NONE — No additional information

AUTOMATIC — The configuration parameter has been set to automatic

DEFERRED_VALUE

The value of the configuration parameter on disk. For some database configuration parameters, changes only take effect when the database is reactivated. In such cases, all applications must first disconnect from the database. (If the database was enabled, then it must be deactivated and then reactivated.) The changes take effect with the next connection to the database.

DATATYPE

The configuration parameter data type.

MODIFIED

Indicates whether the value changed since the last collection.

If the value changed on disk, but the instance is still using the previous value, the value of this parameter is 0.

Database Instance Parameters Collection

The following table describes the metrics that are collected for each database instance configuration parameter.

INSTANCE_NAME

The database instance name.

NAME

The configuration parameter name.

CURRENT_VALUE

The current value of the configuration parameter stored in memory, in partition/member 0.

VALUE_FLAGS

Provides specific information about the current value of the configuration parameter. Values:

NONE — No additional information

AUTOMATIC — The configuration parameter has been set to automatic

DEFERRED_VALUE

The value of the configuration parameter on disk. For some database configuration parameters, changes only take effect when the database is reactivated. In such cases, all applications must first disconnect from the database. (If the database was enabled, then it must be deactivated and then reactivated.) The changes take effect with the next connection to the database.

DATATYPE

The configuration parameter data type.

MODIFIED

Indicates whether the value changed since last collection.

If the value changed on disk, but the instance is still using the previous value, the value of this parameter is 0.

Database Instance Registry Variables Collection

The following table describes the metrics that are collected for each database instance registry variable.

INSTANCE_NAME

The name of the monitored instance.

REG_VAR_NAME

The name of the DB2 registry variable.

REG_VAR_VALUE

The current value of the DB2 registry variable in memory.

REG_VAR_ON_DISK_VALUE

The current setting of the DB2 registry variable on disk. For DB2 versions prior to version 10, the current setting is not available, so the value of this parameter is “N/A”.

LEVEL

Indicates the level at which the DB2 registry variable acquires its value. The possible return values and the corresponding levels that they represent are:

I — Instance

G — Global

N — Database partition

E — Environment

MODIFIED

Indicates whether the value changed since last collection.

If the value changed on disk, but the instance is still using the previous value, the value of this parameter is 0.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating