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

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.

CF Resource Usage Collection

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

관련 문서
Foglight for DB2 (Cartridge) - 5.9.4.20
Deployment Guide
Getting Started Guide
Hardware Sizing Guide
Release Notes
User Guide
Showing 1 to 5 of 5 rows

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택