Foglight for DB2 (Cartridge) 5.9.2.1 - User Guide

•

Availability (%). The availability of the agent’s connection FCM.

•

Response Time (ms). The average response time of a query when the connection is already open, over the course of the selected time range.

•

Avg. Request Time (ms). The average duration for a single database request, over the course of the selected time range. This metric is only available for DB2 v9.7.0.1 and later.

•

Balance Criterion. The level of balance exhibited, for a particular database criterion (for example, workload in terms of the number of connections), over the course of the selected time range. Click the arrow at the right of “Balance Criterion” to choose a different criterion from the list.

•

Workload. The balance of average active agents across the database members. If most of the activity is on one member, for example, the activity is not balanced. If most of the activity is spread equally across the members, it is balanced.

•

Request Time. The balance of requests across the monitored members, or the extent to which the total request time is spread across the members. This metric is only available for DB2 v9.7.0.1 and later.

•

Physical Reads. The balance of the physical reads across the monitored members, or the extent to which the physical reads operations are balanced across the members.

•

Logical Reads. The balance of the logical reads across the monitored members, or the extent to which the logical reads operations are balanced across the members.

•

CPU Load. The balance of CPU used across the monitored members.

•

Transaction Rate. The balance of the transactions across the monitored members. For example, if most of the transactions are done on one member, the transactions are not balanced. If they are spread equally across the members, they are balanced.

•

Storage Capacity. The balance of storage capacity used across the monitored members.

Clicking the icon next to the Availability, Response Time, or Avg. Request Time metric displays a pop-up that provides additional, related information.

Mousing over a data point on either of the Balance Criterion charts displays a pop-up that provides more detailed information about that data point.

Clicking any of the Request Time, Physical Reads, Logical Reads, CPU Load, Transaction Rate, or Storage Capacity charts displays a pop-up that provides additional, related information.

Sessions

The Sessions pane displays client application session metrics for the entire database. It is at the lower left of the Database home page.

•

Avg. Active Sessions (no.). The average number of active sessions connected to the database over the course of the selected time range.

•

Avg. Connected Sessions (no.). The average number of sessions connected to the database over the course of the selected time range.

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

FCM

The FCM pane displays FCM metrics for the entire database. It is located in the upper middle of the Database home page.

•

Total Buffers Sent. The total number of FCM buffer pages sent from the current node to the remote node, over the course of the selected time range.

•

Total Buffers Received. The total number of FCM buffer pages received by the current node from the remote node, over the course of the selected time range.

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

Cache Hit Ratio

The Cache Hit Ratio pane displays cache hit ratio metrics for the entire database. It is located toward the center of the Database home page.

•

Buffer Pool (%). The percentage of database page I/O requests satisfied using the buffer cache (and therefore the database did not have to perform disk reads), over the course of the selected time range.

•

Package (%). 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.

•

Catalog (%). The number of times that a table descriptor or authorization information was not found in the catalog cache and had to be inserted ther. 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.

•

pureScale only — Overall BP (%). A percentage that reflects the number of times a requested page was found in the buffer pool out of all times it was requested. If a page is found in the buffer pool, it saves the database the time to look for it in the physical storage.

•

pureScale only — Global BP (%). A percentage that reflects the number of times a requested page was found in the GBP out of all times it was requested. If a page is found in the GBP, it saves the database the time to look for it in the LBP.

•

pureScale only — GBP Full (%). A percentage that reflects the number of times a Group Buffer Pool Full condition occurred per 10,000 commits.

Clicking the icon next to any of the three metrics displays a pop-up that provides additional, related information.

•

•

Clicking the link at the bottom of any of the three pop-ups takes you to the corresponding dashboard for additional information.

Resource Utilization

The Resource Utilization pane provides information on CPU and RAM consumption for the entire database. It is located in the lower middle of the Database home page.

•

CPU (%). Total CPU usage by all processes (including all DB2 processes) running on the host, as a percentage of the total CPU available.

•

No. of CPUs. The total number of CPUs available.

•

Memory (%). Total memory usage by all processes (including all DB2 processes) running on the host, as a percentage of the total memory available.

•

Total RAM. The total RAM (in MB) available.

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

Clicking a data point on either of the CPU or Memory charts displays a pop-up that provides additional, related information.

Storage

The Storage pane provides information about fixed and auto storage for the entire database. It is at the upper right of the Database home page.

•

Fixed Size (MB). 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 (MB). The total file system space that is available for the database to use to carry out auto storage tablespace operations, and the file system space that is still free for the database to use to carry out auto storage tablespace operations.

Clicking the icon below either chart displays a pop-up that provides additional, related information.

•

•

Clicking the Investigate using the “Tablespaces” drilldown link at the bottom of either pop-up takes you to the Tablespaces dashboard for additional information.

Average I/O Activity

The Average I/O Activity pane provides I/O metrics for the entire database. It is at the lower right of the Database home page.

•

Log Reads. The number of times the log was read from during the selected time range.

•

Log Writes. The number of times the log was written to during the selected time range.

•

Physical Reads. The number of reads directly from disk during the selected time range.

•

Physical Writes. The number of writes directly to disk during the selected time range.

•

Logical Reads. The number of reads from the buffer pool during the selected time range.

•

Direct Reads. The number of reads that did not use the buffer pool, during the selected time range.

•

Direct Writes. The number of writes that did not use the buffer pool, during the selected time range.

•

Async Reads. The number of asynchronous reads during the selected time range.

•

Async Writes. The number of asynchronous writes during the selected time range.