Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 7.2.0 - User Guide

Introduction to Foglight for DB2 LUW Using 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

Host Properties Collection

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

The name of the monitored database.

The partition number.

The physical name of the host.

The machine model.

Example: Sun Fire V240

The operating system.

Example for OS and OS version collections: 64-bit sparcv9 sun4u

The version of the operating system.

The amount of machine RAM configured for DB2 servers.

The total number of CPU units available for DB2 servers.

The number of IO devices configured on the host.

The number of network interfaces installed on the host.

OS General Collection

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

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.

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.

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).

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating