Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 5.9.4.20 - 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 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

Monitor Switches Collection

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

INSTANCE_NAME

The name of the monitored instance.

DBPARTITIONNUM

The database partition from which the data was retrieved for this row.

UOW_SW_STATE

The state (0 or 1) of the unit of work monitor recording switch.

STATEMENT_SW_STATE

The state (0 or 1) of the STATEMENT recording switch.

LOCK_SW_STATE

The state (0 or 1) of the LOCK recording switch.

SORT_SW_STATE

The state (0 or 1) of the SORT recording switch.

TABLE_SW_STATE

The state (0 or 1) of the TABLE recording switch.

BUFFERPOOL_SW_STATE

The state (0 or 1) of the BUFFERPOOL recording switch.

TIMESTAMP_SW_STATE

The state (0 or 1) of the TIMESTAMP recording switch.

OS DB2 General Process Collection

The following table provides a list of the OS DB2 General Process metrics that are collected, and a description for each.

DATABASE

The name of the monitored database.

PARTITION#

The partition number.

ALL_AGENTS_MEMORY_USAGE_INSTANCE

The entire agents process memory consumption, both RAM resident and swapped.

ALL_AGENTS_MEMORY_USAGE_DATABASE

The entire agents process memory consumption, both RAM resident and swapped.

ALL_AGENTS_CPU_UTILIZATION

The overall CPU utilization (%) of the DB2 agents.

NON_DB2_CPU_UTILIZATION

The overall CPU consumption not associated with the monitored DB2 database partition (background and foreground processes).

BALANCE_DB2_CPU_USAGE

The balance of CPU usage between all monitored partitions.

BALANCE_DB2_MEMORY_USAGE

The balance of memory usage (%) between all monitored partitions.

ALL_AGENTS_MEMORY_USAGE_TOTAL

The overall monitored DB2 MEMORY usage (MB).

ALL_AGENTS_MEMORY_USAGE_
UTILIZATION

The overall monitored DB2 MEMORY utilization (%), which is the amount of memory used by DB2, as a percentage of the DB2 host’s configured memory.

Partition Tablespaces Summary Collection

The following table provides a list of the Partition Tablespaces Summary metrics that are collected, and a description for each.

DBPARTITIONNUM

The partition number.

OVERALL_FIXED_TABLESPACE_TOTAL_SIZE_MB

The total size (in MB) of the fixed DMS tablespaces.

OVERALL_FIXED_TABLESPACE_USED_SIZE_MB

The overall fixed DMS tablespace size (in MB) used.

OVERALL_FIXED_TABLESPACE_
UTILIZATION

The overall utilization (%) of the disk space that is allocated for use by DB2 fixed-size tablespaces.

OVERALL_AUTO_TABLESPACE_USED_SIZE_MB

The overall total size (in MB) of the tablespaces used.

OVERALL_AUTO_TABLESPACE_UTILIZATION

The overall utilization (%) of the file system space that is available for DB2, for carrying out auto storage tablespace operations.

OVERALL_TOTAL_SIZE_MB

The total allocated size (in MB) of all the tablespaces in the partition.

OVERALL_USED_SIZE_MB

The overall used size (in MB) of all the tablespaces.

BALANCE_OVERALL_USED_SIZE_MB

The balance of storage used across the partitions. This metric shows the level of balance the DB2 has, in terms of storage capacity, across its partitions.

OVERALL_TOTAL_USED_SPACE_DELTA

The space used by the delta of all the tablespaces.

OVERALL_TOTAL_USED_SPACE_DELTA_
RATE

The used space delta per second.

AUTO_STORAGE_STATE

The auto storage state. Values:

0 — Fixed

1 — Auto

0,1 — Both

Partition Usability Collection

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

INSTANCE

The name of the monitored instance.

PARTITION_NUMBER

The partition number.

PARTITION_HOST_NAME

The partition host name.

PARTITION_AVAILABILITY

The availability of the partition, which reflects the instance usability.

ERROR_MSG_OBS

Indicates the error message received while attempting to connect to the database.

OS_CONNECT_AVAILABILITY

Indicates the OS connect availability with the associated OS credential.

Values:

0 — Connection to the remote host failed.

100 — Connection to the remote host succeeded.

OS_CONNECTION_TIME

The average duration (in milliseconds) for performing a single connection to the database.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating