Scroll to navigation

PMDADB2(1) General Commands Manual PMDADB2(1)

NAME

pmdadb2 - IBM Db2 database PMDA

DESCRIPTION

pmdadb2 is a Performance Co-Pilot (PCP) Performance Metrics Domain Agent (PMDA) which extracts live performance data from a running IBM Db2 database server using the Db2 monitoring table functions (MON_GET_*).

Metrics are organised into the following groups:

Instance-level identity metrics from ENV_GET_INSTANCE_INFO, covering the instance name, full service level (version) string, and operating platform. These are PM_SEM_DISCRETE metrics: they are logged once at recording start and only when changed.
Database-wide aggregate counters from MON_GET_DATABASE, covering transactions, row operations, sort activity, locking, package cache efficiency, and direct I/O. The instance domain contains one entry per monitored database name.
Per-buffer-pool counters from MON_GET_BUFFERPOOL, covering logical and physical reads and writes for data, index, and column-organised pages, together with pool read/write times and unread prefetch pages. Instance names are dbname::bpname.
Per-table counters from MON_GET_TABLE, covering row operations, lock activity, overflow accesses, and full-table scans. System tables (schema prefix SYS) are excluded. Instance names are dbname::tabschema.tabname.
Per-workload counters from MON_GET_WORKLOAD, covering row operations, CPU time, and transaction counts. Instance names are dbname::workload_name.
Per-tablespace I/O counters from MON_GET_TABLESPACE, covering buffer pool and direct read/write operations and times. Instance names are dbname::tablespace_name.
Per-connection counters from MON_GET_CONNECTION, covering CPU time, row operations, lock activity, and transaction counts. Instance names are dbname::appname::handle.
Per-latch-type extended wait statistics from MON_GET_LATCH, covering cumulative wait time and event count. Only latch types that have experienced at least one extended wait event appear in the instance domain. Instance names are dbname::latch_name.
Transaction log I/O counters from MON_GET_TRANSACTION_LOG, covering log write and read operations, physical I/O counts, buffer-full events, and current used and available log space. The instance domain contains one entry per monitored database name.
Package cache aggregate counters from MON_GET_PKG_CACHE_STMT, summarising the entire statement cache without a per-statement instance domain: cached statement count, total executions, CPU time, rows read, sort operations, and sort overflows. The instance domain contains one entry per monitored database name.

CONFIGURATION

Firstly, pmdadb2 requires installation of the ibm_db Python package, which provides the IBM Db2 driver for Python.

pmdadb2 reads a mandatory ini-style configuration file:

$PCP_SYSCONF_DIR/db2/db2.conf

This file has two sections.

[connection] specifies how to reach the Db2 server (default values shown in parentheses):

Hostname or IP address of the Db2 instance.
TCP port number of the Db2 instance listener.
Connection timeout in seconds.

[databases] specifies which databases on the instance to monitor:

Space-separated list of Db2 database names to monitor. All databases must be reachable at the configured hostname and port using the same credentials. The database name appears as the instance name for db2.database.*, db2.log.* and db2.pkg_cache.* metrics, and as the dbname:: prefix in all per-object instance domains (buffer pools, tables, tablespaces, workloads, connections, latches).

[authentication] specifies the Db2 user credentials:

Db2 username to authenticate as. The user must have EXECUTE privilege on the MON_GET_* table functions and DATAACCESS or the appropriate MON_* authorities on the target database.
Password for the above username.

INSTALLATION

To install, the following must be done as root:

# cd $PCP_PMDAS_DIR/db2
# ./Install

To uninstall, the following must be done as root:

# cd $PCP_PMDAS_DIR/db2
# ./Remove

pmdadb2 is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent is installed or removed.

pmdadb2 will automatically attempt to reconnect to the Db2 server if the connection is lost.

FILES

$PCP_SYSCONF_DIR/db2/db2.conf
configuration file for the pmdadb2 agent
$PCP_PMDAS_DIR/db2/Install
installation script for the pmdadb2 agent
$PCP_PMDAS_DIR/db2/Remove
undo installation script for the pmdadb2 agent
$PCP_LOG_DIR/pmcd/db2.log
default log file for messages from the pmdadb2 agent

Note that the usual/default value for $PCP_SYSCONF_DIR is /etc/pcp the default for $PCP_PMDAS_DIR is /var/lib/pcp/pmdas and the default for $PCP_LOG_DIR is /var/log/pcp but these settings are platform dependent.

PCP ENVIRONMENT

Environment variables with the prefix PCP_ are used to parameterize the file and directory names used by PCP. On each installation, the file /etc/pcp.conf contains the local values for these variables. The $PCP_CONF variable may be used to specify an alternative configuration file, as described in pcp.conf(5).

SEE ALSO

PCPIntro(1), pmcd(1), pmdamssql(1) and pmdapostgresql(1).

PCP Performance Co-Pilot