Chat now with support
Chat with Support

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

Summary

This home page contains the following panes:

•
Member Information
•
Sessions
•
Workload Information
•
HADR
•
Process Activity
•
Memory Activity
•
I/O Activity
•
Active Log
•
Disk Storage
Member Information

The Member Information pane displays member status and connection information, member CPU and memory information, and member alarms. It is at the upper left of the Member (Real Time) home page.

 
Description of the Pane
Data displayed
•
Partition. The identifying number for the partition.
 
•
DB path. The path of the partition.
 
•
Up since. The date and time the partition connected.
 
•
Status. The status of the partition.
 
•
Alarms. The alarms (due to partition irregularities) that are currently outstanding against the partition.
 
•
CPU (%). The total CPU consumption by processes running on the host (including any DB2 processes), and the total CPU consumption by the DB2 processes running on the host.
 
•
Memory (%). Total memory consumption by all processes running on the host (including DB2 processes), and the total memory consumption by the DB2 processes running on the host.
 
•
No. of CPUs. The number of CPUs allocated to the partition.
 
•
Total RAM. The total RAM allocated to the partition.
 
•
Free RAM. The total free RAM available for the partition.
Where to go next

Clicking the icon next to the Status displays a pop-up that provides additional, related information.

Mousing over a data point on either of the CPU or Memory charts displays a pop-up that provides additional information about the data point.

Clicking the CPU or Memory charts displays a pop-up that provides additional, related information.

Mousing over or clicking an alarm count displays a pop-up that provides additional, alarm-related information.

Sessions

The Sessions pane displays the session distribution information for the selected partition. It is at the lower left of the Partition (Real Time) home page.

 
Description of the Pane
Data displayed
•
Inactive or Active. The distribution of currently running inactive and active sessions.
 
•
Background or Foreground. The distribution of currently running background and foreground sessions.
 
•
Connections. The current number of active connections.
 
•
Received Volume. The number of KBs per second received by the server from clients.
 
•
Sent Volume. The number of KBs per second sent by the server to clients.
Where to go next

Clicking a chart displays a pop-up that provides additional, related information.

Workload Information

The Workload Information pane for DB2 databases v9.7.0.1 and later displays a Request Time Breakdown chart for the selected partition. The Workload Information pane for DB2 databases earlier than v9.7.0.1 displays an Average Active Sessions chart for the selected partition. The pane is located in the upper middle of the Partition (History) home page.

 
Description of the Pane
Data displayed for DB2 databases v9.7.0.1 and later
•
Request Time Breakdown. The request time breakdown, for a particular partition criterion, plotted over the course of the selected time range. Click the arrow at the right of “Breakdown” to choose a different criterion from the list.
Data displayed for DB2 databases earlier than v9.7.0.1
•
Average Active Sessions. A comparison of the average number of active sessions over the course of the selected time range with the average number of active sessions expected (according to the baseline).
Where to go next

Mousing over a data point on the chart displays a pop-up that provides more detailed information about the data point.

Clicking the icon next to “Workload” takes you to the Current Agents pane. For more information, see Current Agents.

HADR

If the database is configured for HADR, the HADR pane displays the associated HADR metrics for the partition. It is located in the middle of the Partition (Real Time) home page.

 
Description of the Pane
Data displayed
•
Role. The HADR role of the database.
 
•
HADR Remote Host. The name of the HADR remote host.
 
•
HADR Remote Instance. The name of the HADR remote instance.
 
•
Log Gap. The size (in KB) of the gap between the primary log sequence number and the standby log sequence number.
 
•
HADR State. The HADR state of the database:
•
Disconnected
•
Performing local catch-up
•
Waiting to connect to its partner to perform remote catch-up
•
Performing remote catch-up
•
In a peer state
Where to go next

Clicking the icon next to a metric displays a pop-up with additional, related information.

For more information on these parameters, see HADR Activity Collection .

Process Activity

The Process Activity pane displays agent and SQL information for the selected partition. It is at the lower middle of the Partition (Real Time) home page.

 
Description of the Pane
Data displayed
•
Agents. The number of agents for the applications currently running in the partition.
 
•
Top Agents. The maximum number of agents for all applications running in the partition.
 
•
Transactions/s. The number of transactions involving the partition that were being carried out per second, during the last collection.
 
•
Select Stmt. The number of static SQL statements that were being run per second by the partition, during the last collection.
 
•
DDL Stmt. The number of data definition language (DDL) SQL statements that were being run per second by the partition, during the last collection.
Where to go next

Clicking the icon next to a metric displays a pop-up with additional, related information.

Memory Activity

The Memory Activity pane displays memory-related metrics for the selected partition. It is located in the middle of the Partition (Real Time) home page.

 
Description of the Pane
Data displayed
•
Memory Total (MB). The total memory available for the partition.
 
•
Memory Used. The percentage of the total memory available that was used by the database partition during the last collection.
 
•
Buffer Pool Total (MB). The total buffer pool available for the partition.
 
•
Buffer Pool Hit Ratio. The percentage of database page I/O requests that are being satisfied using the buffer cache (and therefore the database does not have to perform disk reads).
 
•
Catalog Cache Total (MB). The total catalog cache available for the partition.
 
•
Catalog Cache Hit Ratio. The number of times that a table descriptor or authorization information was not found in the catalog cache and had to be inserted there. Calculated as a percentage of the total number of times that a table descriptor or authorization information was requested, over the course of the selected time range.
 
•
Package Cache Total (MB). The total package cache available for the partition.
 
•
Package Cache Hit Ratio. The number of times that a requested section was not available for use and had to be loaded into the package cache. Calculated as a percentage of the total number of times that a section was requested, over the course of the selected time range.
Where to go next

Clicking a chart displays a pop-up that provides additional, related information.

I/O Activity

The I/O activity for the selected partition is displayed in charts on either side of the Memory Activity pane.

 
Description
Data displayed
•
Logical Reads. The number of logical read requests that were being processed per second by the partition, during the last collection.
 
•
Log I/O Reads. The number of logical I/O read requests that were being processed per second by the partition, during the last collection.
 
•
Log I/O Writes. The number of logical I/O write operations that were being run per second by the partition, during the last collection.
 
•
Async I/O Reads. The number of asynchronous I/O read requests that were being processed per second by the partition, during the last collection.
 
•
Async I/O Writes. The number of asynchronous I/O write operations that were being run per second by the partition, during the last collection.
 
•
Sync I/O Reads. The number of synchronous I/O read requests that were being processed per second by the partition, during the last collection.
 
•
Sync I/O Writes. The number of synchronous I/O write operations that were being run per second by the partition, during the last collection.
Where to go next

Clicking a chart displays a pop-up that provides additional, related information.

Active Log

The Active Log pane displays metrics for the selected partition’s active log. It is at the upper right of the Partition (Real Time) home page.

 
Description of the Pane
Data displayed
•
Total Utilization. The total log space that is available to the partition and the log space that is still free to be used by the partition.
 
•
Log buffer full. The total number of times that agents, that copy log records into the log buffer, have had to wait for log data to be written to disk. This value is incremented once for each time an agent experiences such contention. If two agents are waiting at the same time, this value is incremented by two.
 
•
Secondaries. The total size of the secondary files (in KBs.)
 
•
Log to recovery. The size of the recovery log (in KBs).
 
•
Appl id oldest Xact. The ID of the application holding the oldest transaction.
Where to go next

Clicking the icon below the chart displays a pop-up with additional, related information.

Disk Storage

The Disk Storage pane displays the disk storage status for the selected partition. It is at the bottom right of the Partition (Real Time) home page.

 
Description of the Pane
Data displayed
•
Fixed Storage. The total disk space that is available for use by fixed-size tablespaces and the disk space that is still free to be used by fixed-size tablespaces.
 
•
Auto Storage. The total file system space that is available for the partition to use to carry out auto storage tablespace operations, and the file system space that is still free for the partition to use to carry out auto storage tablespace operations.
 
•
Max TBSP Utilization. The maximum tablespace utilization of the system.
Where to go next

Clicking either of the charts displays a pop-up with additional, related information.

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.

 
Metric
Description

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.

 
Metric
Description

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating