Chat now with support
Chat with Support

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

Top SQLs Text Collection

The following table provides a list of the Top SQLs Text metrics that are collected, and a description for each.

 
Metric
Description

DB_NAME

The name of the monitored database.

DBPARTITIONNUM

The database partition from which the data was retrieved.

HASH_VALUE

The ID of the SQL by hash value.

IS_FULL_TEXT

The boolean ‘is full text’ ID.

SQL_TEXT

The first 256 characters of the SQL text for the current cursor.

Query Agents Details Collection

The following table provides a list of the Query Agents Details metrics that are collected, and a description for each.

 
Metric
Description

DB_NAME

The name of the monitored database.

DBPARTITIONNUM

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

FOREGROUND_BACKGROUND_TYPE

The foreground or background status of the application.

LAST_RESET

The date and time when the monitor counters were reset.

PACKAGE_CACHE_HIT_RATIO

A ratio that indicates how well the package cache is helping to avoid the reload of packages and sections for static SQL from the system catalogs and the recompilation of dynamic SQL statements.

The indicator is calculated using the formula:

(1-(PKG_CACHE_INSERTS/PGK_CACHE_LOOKUPS))*100

POOL_DATA_WRITES

The number of times a buffer pool data page was physically written to disk.

PERCENT_SORT_OVERFLOWS

The percentage of sort operations, out of the total sort operations, that ran out of sort heap and may have required disk space for temporary storage.

Database Partition Activity Collection

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

 
Metric
Description

DATABASE_NAME

The name of the monitored database

MEMBER

The member or partition ID.

TOTAL_RQSTS

The total amount of requests completed.

AVG_RESPONSE_TIME

The average duration (in seconds) for a single request.

TOTAL_RQST_TIME

The total amount of time (in seconds) spent working on requests.

BALANCE_TOTAL_RQST_TIME

The balance of the total amount of time spent working on requests across the database partitions. The balance is poor if one partition (or member) is doing most of the activity.

TOTAL_WAIT_TIME

The total amount of time (in seconds) spent waiting within the DB2 database server.

TOTAL_CPU_TIME

The total amount of CPU time used (in seconds) while within the DB2 database server. This includes both user and system CPU time.

BALANCE_TOTAL_CPU_TIME

The balance of CPU usage across all monitored partitions.

%WAIT

The amount of time the database spent waiting, as a percentage of the total request time.

TOTAL_CPU_WAIT

The total amount of time (in microseconds) that requests run in this service class spent waiting to access the CPU.

This is only available for DB2 version 10 and higher.

FCM_REVC_VOLUME

The total amount of data (in bytes) received through the FCM communications layer.

FCM_SEND_VOLUME

The total amount of data (in bytes) distributed by the FCM communications layer.

FCM_REVC_VOLUME_RATE

The total amount of data (in bytes) received through the FCM communications layer.

FCM_SEND_VOLUME_RATE

The total amount of data (in bytes) distributed by the FCM communications layer.

TCPIP_SEND_VOLUME_KB

The amount of data (in KB) sent by the data server to the clients.

TCPIP_SEND_VOLUME_RATE

The number of KBs sent per second by the data server to the clients.

TCPIP_REVC_VOLUME_KB

The amount of data (in KB) received by the data server from the clients over TCP/IP.

TCPIP_REVC_VOLUME_RATE

The number of KBs received per second by the server from the clients.

DB2 Partition Subcategories Wait Collection

The following table provides a list of the DB2 Partition Subcategories Time-spent Monitor Element metrics that are collected, and a description for each.

Starting from DB2 v9.7.0.1, DB2 uses time-spent monitor elements to track how time is spent in the system. These elements show where time is spent waiting, or performing various types of processing. Time-spent monitor elements get rolled up into more general monitor elements. Elements with the same PARENT_METRIC_NAME are rolled up into that parent.

 
Metric
Description

DATABASE_NAME

The name of the monitored database

MEMBER

The database partition or member number.

METRIC_NAME

The event name to which the TOTAL_TIME metric value refers.

PARENT_METRIC_NAME

The identifier of the parent for the TOTAL_TIME metric, whose value contains the TOTAL_TIME value as a subset.

TOTAL_TIME

The total time value (in seconds), which corresponds to METRIC_NAME.

COUNT

The number of occurrences of this type of event.

COUNT_RATE

The rate of the number of occurrences of this type of event.

TOTAL_TIME_RATE

The rate (per second) of the total time spent.

CATEGORY

The category of the event. Values:

I/O wait - The amount of time spent waiting for IO. Subcategories provide additional information.

Other wait - The aggregate of several events that do not typically have a high impact on performance. Subcategories provide additional information.

WLM wait - The amount of time spent waiting for the WLM queue.

pureScale wait - The amount of time spent waiting for various functions within the cluster. Subcategories provide additional information.

Idle - The amount of time the client waited that was not spent within DB2 database server.

Network wait - The amount of time spent waiting for network protocols. Subcategories provide additional information.

Lock wait - The amount of time spent waiting for locks.

Log wait - The amount of time spent waiting for the log. Subcategories provide additional information.

Transaction - The amount of time spent on the commit or rollback of the transaction.

Compile - The amount of time spent doing explicit or implicit compiles.

Memory wait - The amount of time spent waiting for an internal latch.

Administration - The amount of time spent processing administration tasks. Subcategories provide additional information.

Execute - The amount of time spent executing the request. Subcategories provide additional information.

FCM wait - The amount of time spent waiting for the FCM communications layer. This is only applicable on the partition level. Subcategories provide additional information.

IPC - The amount of time spent waiting for IPC channels.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating