지금 지원 담당자와 채팅
지원 담당자와 채팅

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

Collections and Metrics

The Foglight for DB2 LUW agents collect metrics and store them in the Foglight topology model as topology objects.

CF Locks Collection

Tracks how database members use DB2 pureScale cluster caching facility (CF) locks.

DATABASE

The name of the monitored database.

MEMBER

The name of the member.

CF_RESPONSE_TIME

Average interconnect network time per CF call calculated over all CF calls.

CF_WAIT_TIME

Time (in milliseconds) spent communicating with the cluster caching facility. Both network time and processing time. This time does not include time spent on granting locks or performing page reclaims.

CF_WAITS

Number of times the database system waited while communicating with the cluster caching facility. This is approximately the number of CF calls.

LOCK_ESCALS

Number of times that locks were escalated from several row locks to a table lock.

LOCK_ESCALS_GLOBAL

Number of lock escalations on a global lock due to global lock memory usage reaching the limit specified in the cf_lock_sz database configuration parameter.

LOCK_TIMEOUTS

Total number of lock timeouts.

LOCK_TIMEOUTS_GLOBAL

Number of lock timeouts where the application holding the lock was on a remote member

LOCK_WAIT_TIME

Total time spent waiting for locks.

LOCK_WAIT_TIME_GLOBAL

Time spent waiting for global locks in milliseconds.

LOCK_WAITS

Total number of locks waits.

LOCK_WAITS_GLOBAL

Number of locks waits due to the application holding the lock on a remote member.

GLOBAL_ESCALS_PERCENTAGE

= LOCK_ESCALS_GLOBAL / LOCK_ESCALS

GLOBAL_LOCK_TIMEOUT_PERCENTAGE

= LOCK_TIMEOUTS_GLOBAL / LOCK_TIMEOUTS

GLOBAL_LOCK_WAIT_TIME_PERCENTAGE

= LOCK_WAIT_TIME_GLOBAL / LOCK_WAIT_TIME

GLOBAL_LOCKS_PERCENTAGE

= LOCK_WAITS_GLOBAL / LOCK_WAITS.

CF Memory Pools Collection

Tracks how hosts use DB2 pureScale cluster caching facility (CF) memory pools.

HOST_NAME

The name of the monitored host.

HOSTID

The ID of the CF component.

CF_LOCK_MEM_UTILIZATION

CF Lock Pool Utilization

CF_MEM_UTILIZATION

CF Memory Utilization

CF_SCA_MEM_UTILIZATION

CF SCA Pool Utilization

CONFIGURED_CF_GBP_SIZE

Configured Global Buffer Pool Size

CONFIGURED_CF_LOCK_SIZE

Configured Lock Memory Size

CONFIGURED_CF_MEM_SIZE

Configured CF Memory Size

CONFIGURED_CF_SCA_SIZE

Configured SCA Memory Size

CURRENT_CF_GBP_SIZE

Current Global Buffer Pool Size

CURRENT_CF_LOCK_SIZE

Current Lock Memory Size

CURRENT_CF_MEM_SIZE

Current Total CF Memory Size

CURRENT_CF_NONALLOCATED_SIZE

Current amount of memory allocated for the CF but not used for the GBP, LOCK, or SCA pools.

CURRENT_CF_SCA_SIZE

Current SCA Memory Size

GBP_UTILIZATION

Global Buffer Pool Utilization

CF Resource Usage Collection

Tracks how instances use DB2 pureScale cluster caching facility (CF) resources.

INSTANCE

The name of the monitored instance.

ID

The ID of the CF component.

HOST

The name of the machine that hosts the CF component.

CPU_USAGE_TOTAL

Percentage of overall CPU usage of the CF machine.

MEMORY_FREE

Amount of free physical memory (MB).

MEMORY_SWAP_FREE

Amount of free swap space (MB).

MEMORY_SWAP_TOTAL

Total amount of swap space (MB).

MEMORY_TOTAL

Total size of physical memory (MB).

MEMORY_UTILIZATION

The percentage of free memory out of the total memory assigned to the CF machine.

VIRTUAL_MEMORY_FREE

Amount of reserved virtual memory.

VIRTUAL_MEMORY_TOTAL

Total amount of virtual memory on the system (MB).

관련 문서