サポートと今すぐチャット
サポートとのチャット

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

Instance Memory Pool Collection

The following table provides a list of the Instance Memory Pool metrics that are collected, and a description for each.

 
Metric
Description

INSTANCE_NAME

The name of the monitored instance.

POOL_ID

The pool ID.

Values:

•
FCMBP
•
MONITOR
•
OTHER

POOL_CUR_SIZE

The average allocated size (in KB) of a memory pool.

POOL_CONFIG_SIZE

The internally configured size (in KB) of a memory pool in the DB2 database system.

INSTANCE_UTILIZATION

The utilization of the allocated memory from the configured memory.

Instance Memory Summary Collection

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

 
Metric
Description

DBPARTITIONNUM

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

INSTANCE_NAME

The name of the monitored instance.

POOL_CONFIG_SIZE

The internally configured size (in KB) of a memory pool in the DB2 database system.

POOL_CUR_SIZE

The total current size (in KB) of the instance memory pools per partition.

INSTANCE_UTILIZATION

The utilization of the allocated memory from the configured memory.

Instance Memory Total Collection

The following table provides a list of the Instance Memory Total metrics that are collected, and a description for each.

 
Metric
Description

INSTANCE_NAME

The name of the monitored instance.

POOL_CUR_SIZE

The total current size (in KB) of the instance memory pools.

INSTANCE_UTILIZATION

The utilization of the allocated memory from the configured memory.

Database Memory Collection

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

The memory usage of the database
 
Metric
Description

DBPARTITIONNUM

The database partition from which the data was retrieved.

INSTANCE_NAME

The name of the monitored instance.

DB_NAME

The name of the monitored database.

POOL_ID

The pool ID.

Values:

•
APP_GROUP
•
APPL_CONTROL
•
APPLICATION
•
BP
•
CAT_CACHE
•
DATABASE
•
DFM
•
IMPORT_POOL
•
LOCK_MGR
•
OTHER
•
PACKAGE_CACHE
•
QUERY
•
SHARED_SORT
•
SORT
•
STATEMENT
•
STATISTICS
•
UTILITY

POOL_SECONDARY_ID

An additional ID to help determine the memory pool for which monitoring data is returned.

POOL_CUR_SIZE

The average allocated size (in KB) of a memory pool.

POOL_CONFIG_SIZE

The internally configured size (in KB) of a memory pool in the DB2 database system.

POOL_UTILIZATION

The utilization of the allocated memory from the configured memory.

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択