Foglight for DB2 (Cartridge) 7.2.0


Metric	Description
DATABASE	The name of the monitored database.
DISK_UTILIZATION	The percentage of time the busiest device spent serving system-wide I/O requests. This metric serves as a measure for the system I/O load.
FREE_RAM	The amount of RAM that is free and not used by any of the running processes on the DB2 host.
PARTITION#	The partition number.
RESIDENT_SET_SIZE	The host OS resident memory set size.
SYSTEM_CPU_UTILIZATION	The total CPU consumption by all system processes (including DB2 processes) on the host.
SYSTEM_KERNAL_CPU_UTILIZATION	The percentage of CPU time consumed by the operating system's kernel mode activities (processes).
SYSTEM_USER_CPU_UTILIZATION	The percentage of CPU time consumed by the operating system's user mode activities (processes).
USED_RAM	The total amount of memory (both resident and swapped RAM) consumed by all the operating system’s processes, including DB2 (measured in MB).
USED_RAM_PCT	The percentage of RAM that is used by all the operating system’s processes.
VIRTUAL_SET_SIZE	The host OS virtual memory set size.

Instance Activity Collection

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


Metric	Description
AGENTS_CREATED_EMPTY_POOL	The number of agents created due to an empty agent pool, including the number of agents started at DB2 start-up (num_initagents).
AGENTS_REGISTERED	The number of agents registered in the currently monitored database manager instance (coordinator agents and subagents).
AGENTS_STOLEN	Represents the number of idle agents associated with an application that get reassigned to work on a different application.
CON_LOCAL_DBASES	The number of local databases that have applications connected.
DB2_STATUS	This interface returns a text identifier, which is based on the definitions in the sqlmon.h file and can have one of the following values: ACTIVE QUIESCE_PEND QUIESCED
DB2START_TIME	The date and time that the database manager was started using the db2start command.
DBPARTITIONNUM	The database partition from which the data was retrieved for this row.
INSTANCE_NAME	The name of the monitored instance.
LAST_RESET	The date and time that the monitor counters were reset.
LOCAL_CONNECTIONS	The number of local applications that are currently connected to a database within the database manager instance being monitored.
LOCAL_CONN_EXEC	The number of local applications that are currently connected to a database within the database manager instance being monitored and are currently processing a unit of work.
NUM_NODES_IN_DB2_INSTANCE	The number of partitions on the instance.
PERCENT_OF_AGENTS_IN_USE	Of the maximum agents, the percentage of those agents in use.
PIPED_SORTS_ACCEPTED	The number of piped sorts that have been accepted. Each active sort on the system allocates memory, which may result in sorting taking up too much of the available system memory. When the number of accepted piped sorts is low compared to the number requested, you can improve sort performance by adjusting one or both of the following configuration parameters: sortheap, sheapthres
PIPED_SORTS_REQUESTED	The number of piped sorts that have been requested.
POST_THRESHOLD_SORTS	The number of sorts that have requested heaps after the sort heap threshold has been exceeded. If this element's value is high, you can increase the sort heap threshold (sheapthres) or adjust applications to use fewer or smaller sorts through SQL query changes.
PRODUCT_NAME	The details of the version of the DB2 instance that is running.
REMOTE_CONN_EXEC	The number of remote applications that are currently connected to a database within the database manager instance being monitored and are currently processing a unit of work.
REMOTE_CONNECTIONS	The current number of connections initiated from remote clients to the instance of the database manager that is being monitored.
SERVICE_LEVEL	The current corrective service level of the DB2 instance.
SORT_HEAP_ALLOCATED	The total number of allocated pages of sort heap space for all sorts.

Instance General Collection

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


Metric	Description
INSTANCE_NAME	The name of the monitored instance.
IS_PARTITIONABLE	Indicates whether the instance is partitioned. Values: 1 — Partitioned 0 — Not partitioned Note: An instance with one partition is considered not partitioned.
IS_PURESCALE	Indicates whether the instance is pureScale. Values: 1 — pureScale 0 — Not pureScale
CONFIGURATION	Indicates the configuration of the instance. Values: Partitioned Non-Partitioned Cluster (for pureScale)
NUM_NODES	The number of members in the instance (partitions in a DPF, and members in a pureScale environment).

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for DB2 (Cartridge) 7.2.0 - User Guide

Host Properties Collection

OS General Collection

Instance Activity Collection

Instance General Collection