DB2

Allows monitoring of DB2 database systems.

Local/Remote Modes

The agent supports both local and remote modes. When running in local mode it requires at least that a DB2 client is installed and the database(s) registered in its catalog.

Supported Versions

This version of the agent supports DB2 8.1 up to and including fixpack 7, and DB2 8.2.

Configuration

The following parameters can be configured. If some of the 'collect' flags are not set some counters may not return any data, but the overhead on the system will be reduced.

  • Instance: DB2 instance to attach to.
  • Database: if set, will only return data for this database. Leave blank to return global system data.
  • Username: DB2 username to use when attaching to instance
  • Password: DB2 password to use when attaching to instance
  • Collect UOW information: include unit-of-work details in returned data. .
  • Collect SQL statements information: include details for SQL statements.
  • Collect table information: include table details in returned data.
  • Collect buffer pool information: return information about bufferpools.
  • Collect locks information: return information about object locks.
  • Collect sorts information: include sort statistics.
  • Collect time information: include time information in returned data.
  • Aggregate data from all nodes: only valid for distributed systems - data returned is aggregated across all nodes. If not set, only data for current node will be returned.

Contents

Data returned by this agent mirrors the information returned by DB2 GET SNAPSHOT commands. The 'collect' flags will directly operate on DB2's monitor switches. When these flags are turned off, some of the resulted entities and counters will not be displayed, or will have null values.

The information returned by this agent includes:

  • Server and database information.
  • Bufferpool statistics.
  • Dynamic SQL statement information.
  • Table operations, such as sorts, reads and writes.
  • Tablespaces and containers.
  • Application information, agents and connections.