Chat now with support
Chat with Support

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

Instance Nodes Collection

The following table provides a list of the Instance Nodes (partitions or members) metrics that are collected, and a description for each.

INSTANCE_NAME

The name of the monitored instance.

NODE_ID

The ID of the partition or member.

HOST_NAME

The machine that was associated with the member when it was first added to the instance.

CURRENT_HOST_NAME

The host on which the node is running. In a pureScale environment, this could be a different host than the one originally configured.

MEMBER_TYPE

Indicates the member type. Values:

MEMBER

CF

DB_PARTITION_NUM

The partition number. For a pureScale instance, this is always 0.

STATE

The state of the member or cluster. The states for a member are:

STARTED

STOPPED

RESTARTING, WAITING_FOR_FAILBACK

ERROR

UNKNOWN

The states for a cluster caching facility are:

STOPPED

RESTARTING

BECOMING_PRIMARY

PRIMARY

CATCHUP1

PEER

ERROR

UNKNOWN.

ALERT

Provides information about alerts on the instance. Values:

YES — There is at least one alert.

NO — There are no alerts.

NULL — Inapplicable

Instance Usability Collection

The following table provides a list of the Instance Usability metrics that are collected, and a description for each.

INSTANCE

The monitored instance.

INSTANCE_AVAILABILITY

The percentage of instance partitions available for the currently running query.

IO Activity Collection

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

ASYNC_PAGES_READ_PER_REQUEST

The average number of pages in each asynchronous read request.

ASYNC_READ

The total number of asynchronous reads (pages) during the specified time range.

ASYNC_READ_RATE

The number of asynchronous reads (pages) per second during the specified time range.

ASYNC_READ_REQUESTS

The total number of asynchronous read requests during the specified time range.

ASYNC_WRITES

The total number of asynchronous writes (pages) during the specified time range.

ASYNC_WRITES_RATE

The number of asynchronous writes (pages) per second during the specified time range.

BALANCE_AVERAGE_LOGICAL_READ

The balance of logical reads across the partitions. This metric shows how balanced the DB2 is, across its partitions, in terms of the logical reads operations.

BALANCE_AVERAGE_PHYSICAL_READ

The balance of physical reads across the partitions. This metric shows how balanced the DB2 is, across its partitions, in terms of the physical reads operations.

DATA_HIT_RATIO

The hit ratio of data reads that were satisfied from the buffer pool, without having to perform physical read operations.

DB_NAME

The name of the monitored database.

DBPARTITIONNUM

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

DIRECT_READ_REQS

The number of requests to perform a direct read of one or more sectors of data. To calculate the average number of sectors read by a direct read, you can use the following formula:

 

DIRECT_READS / DIRECT_READ_REQS

DIRECT_READ_TIME

The elapsed time (in milliseconds) required to perform the direct reads.

DIRECT_READS

The number of read operations that do not use the buffer pool.

To calculate the average number of sectors read by a direct read, you can use the following formula:

DIRECT_READS / DIRECT_READ_REQS

DIRECT_READS_RATE

The direct reads rate (pages per second).

DIRECT_WRITE_REQS

The number of requests to perform a direct write of one or more sectors of data. To calculate the average number of sectors written by a direct write, you can use the following formula:

 

DIRECT_WRITES / DIRECT_WRITE_REQS

DIRECT_WRITE_TIME

The elapsed time (in milliseconds) required to perform the direct writes.

DIRECT_WRITES

The number of write operations that do not use the buffer pool.

To calculate the average number of sectors that written by a direct write, use the following formula:

DIRECT_WRITES / DIRECT_WRITE_REQS

DIRECT_WRITES_RATE

The direct writes rate (pages per second).

FILES_CLOSED

The total number of database files closed.

The database manager opens files for reading and writing into and out of the buffer pool. The maxfilop configuration parameter controls the maximum number of database files open by an application at any time. If that maximum is about to be reached, a file will be closed before a new one is opened.

INDEX_HIT_RATIO

The hit ratio of index reads that were satisfied from the buffer pool, without having to perform index physical read operations.

LOG_CLEANS_RATIO

The percentage of LSN gap cleans within the total number of cleans.

LOGICAL_READS

The total number of pages that have been requested from the buffer pool (logical),

LOGICAL_READS_RATE

The number of logical reads (pages) per second during the specified time range.

OVERALL_POOL_HIT_RATIO

The overall hit ratio of logical reads to physical reads. That is, the percentage of database page I/O requests that were satisfied from the buffer cache and, therefore, did not have to perform disk reads. This ratio measures how efficiently DB2 is using the memory allocated to its buffer cache.

PHYSICAL_READS

The number of physical reads (pages).

Physical reads are used when a connection requests a page that is not already in the buffer cache.

Physical read operations from the disk are necessary when accessing new table or index pages. Nevertheless, these operations should be avoided when possible, as requested pages should reside in the DB2 buffer cache memory.

PHYSICAL_READS_RATE

The number of physical reads (pages) per second during the specified time range.

PHYSICAL_WRITES

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

PHYSICAL_WRITES_RATE

The number of buffer pool pages physically written to disk per second.

POOL_ASYNC_DATA_READ_REQS

The number of asynchronous read requests made by the prefetcher to the operating system. These are typically large block IOs of multiple pages.

POOL_ASYNC_DATA_READS

The number of data pages read in from the tablespace containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of tablespaces.

POOL_ASYNC_DATA_WRITES

The number of times a buffer pool data page was physically written to disk by either an asynchronous page cleaner or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched.

POOL_ASYNC_INDEX_READ_REQS

The number of asynchronous read requests for index pages.

POOL_ASYNC_INDEX_READS

The number of index pages read in from the tablespace containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of tablespaces.

POOL_ASYNC_INDEX_WRITES

The number of times a buffer pool index page was physically written to disk by either an asynchronous page cleaner or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched.

POOL_ASYNC_READ_TIME

The total amount of time spent reading in data and index pages from the tablespace containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of tablespaces. The value is given in milliseconds.

POOL_ASYNC_WRITE_TIME

The total elapsed time spent writing data or index pages from the buffer pool to disk by database manager page cleaners.

POOL_ASYNC_XDA_READ_REQS

The number of asynchronous read requests for XML storage object (XDA) data.

POOL_ASYNC_XDA_READS

The number of XML storage object (XDA) data pages read in from the tablespace containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of tablespaces.

POOL_ASYNC_XDA_WRITES

The number of times a buffer pool data page for an XML storage object (XDA) was physically written to disk by either an asynchronous page cleaner or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched.

POOL_DATA_L_READS

The number of data pages that have been requested from the buffer pool (logical) for regular and large tablespaces.

POOL_DATA_P_READS

The number of data pages read in from the tablespace containers (physical) for regular and large tablespaces.

POOL_DATA_WRITES

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

POOL_DRTY_PG_STEAL_CLNS

The number of times a page cleaner was invoked because a synchronous write was needed during the victim buffer replacement for the database.

POOL_DRTY_PG_THRSH_CLNS

The number of times a page cleaner was invoked because a buffer pool had reached the dirty page threshold criterion for the database.

POOL_INDEX_L_READS

The number of index pages that have been requested from the buffer pool (logical) for regular and large tablespaces.

POOL_INDEX_P_READS

The number of index pages read in from the tablespace containers (physical) for regular and large tablespaces.

POOL_INDEX_WRITES

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

POOL_LSN_GAP_CLNS

The number of times a page cleaner was invoked because the logging space used had reached a predefined criterion for the database.

This element can be used to help evaluate whether you have enough space for logging or whether you need more log files or larger log files.

POOL_NO_VICTIM_BUFFER

The number of times an agent did not have a preselected victim buffer available.

This element can be used to help evaluate whether you have enough page cleaners for a given buffer pool when using proactive page cleaning.

POOL_READ_TIME

The total amount of time spent reading in data and index pages from the tablespace containers (physical) for all types of tablespaces. The value is given in milliseconds.

POOL_TEMP_DATA_L_READS

The number of data pages that have been requested from the buffer pool (logical) for temporary tablespaces.

POOL_TEMP_DATA_P_READS

The number of data pages read in from the tablespace containers (physical) for temporary tablespaces.

POOL_TEMP_INDEX_L_READS

The number of index pages that have been requested from the buffer pool (logical) for temporary tablespaces.

POOL_TEMP_INDEX_P_READS

The number of index pages read in from the tablespace containers (physical) for temporary tablespaces.

POOL_TEMP_XDA_L_READS

The number of pages for XML storage object (XDA) data that have been requested from the buffer pool (logical) for temporary tablespaces.

POOL_TEMP_XDA_P_READS

The number of pages for XML storage object (XDA) data read in from the tablespace containers (physical) for temporary tablespaces.

POOL_WRITE_TIME

The total amount of time spent physically writing data or index pages from the buffer pool to disk. The value is given in milliseconds.

POOL_XDA_L_READS

The number of data pages for XML storage objects (XDAs) that have been requested from the buffer pool (logical) for regular and large tablespaces.

POOL_XDA_P_READS

The number of data pages for XML storage objects (XDAs) read in from the tablespace containers (physical) for regular and large tablespaces.

POOL_XDA_WRITES

The number of times a buffer pool data page for an XML storage object (XDA) was physically written to disk.

PREFETCH_WAIT_TIME

The time an application spent waiting for an I/O server (prefetcher) to finish loading pages into the buffer pool.

SYNC_READS

The total number of synchronous reads (pages) during the specified time range.

SYNC_READS_RATE

The number of synchronous reads (pages) per second during the specified time range.

SYNC_WRITES

The total number of synchronous writes (pages) during the specified time range.

SYNC_WRITES_RATE

The number of synchronous writes (pages) per second during the specified time range.

THRESHOLD_CLEANS_RATIO

The percentage of all page cleans that took place after a buffer pool had reached the criterion defined within the database for dirty page threshold.

UNREAD_PREFETCH_PAGES

The number of pages that the prefetcher read in that were never used.

If this number is high, prefetchers are causing unnecessary I/O by reading pages into the buffer pool that are not being used.

VICTIM_CLEANS_RATIO

The percentage of all page cleans that took place because a synchronous write was needed during the victim buffer replacement for the database.

A victim page is a clean or dirty page in the buffer pool that is removed because DB2 needs to make room for incoming pages. If a victim page is a dirty page, then the information must be written out to disk.

XML_HIT_RATIO

The hit ratio of XML reads that were satisfied from the buffer pool, without having to perform physical read operations.

License Details Collection

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

IS_LICENSED

Indicates whether the installed product is licensed (1) or not (0).

INSTANCE_NAME

The name of the monitored instance.

PROD_RELEASE

The product release number.

INSTALLED_PROD

Represents the DB2 products that are installed on the system.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating