Foglight for DB2 (Cartridge) 5.9.7.20 - Getting Started Guide

Configuring Monitoring Agents

A wizard guides you through the process of configuring agents. You are prompted to specify connection details for the DB2 host, instances, and databases. As you go, you can validate log in credentials, database and instance connectivity, and host connectivity. You can correct issues by granting database permissions, setting monitoring switches, and configuring parameters.

3	Follow the online prompts to configure an agent to monitor the DB2 host, instance, and databases. For help with options, click .

Monitoring DB2 HADR Environments

A DB2 high availability disaster recovery (HADR) environment has two or more databases:

A standby database can be opened in read-only mode and used for reporting. Running the standby database in reporting mode eases the load on the primary (production) database.

NOTE: The HADR read on Standby option is available in DB2 version 9.7.1 or later and is subject to licensing. As of version 10, you can have more than one standby database for each primary database.

We recommend creating agents to monitor each of the instances with databases that participate in the HADR environment. This approach ensures that there is no loss of monitoring in a failover scenario.

For the primary database and for the standby databases that are in read-only mode, you create agents as usual to monitor their DB2 instances. For standby databases that are not in read-only mode, you can define the settings for its DB2 instance, but the wizard is unable to verify database connectivity. To resolve this issue, run the Grant Permissions script for the monitoring user on the standby database.

Monitoring IBM DB2 pureScale Environments

IBM DB2 pureScale® offers high availability and scalability through clustering technology. To monitor instances in a pureScale environment, ensure that the Permissions for DB2 pureScale Environments are set and then configure monitoring agents as usual. Foglight automatically reports on the pureScale cluster cache facility (CF) component, buffer pools and caches, locks, and request time breakdown.

The following pages and views contain monitoring data for pureScale:

Permissions

Foglight monitoring agents use DB2 LUW user accounts to access monitored DB2 instances. The user accounts need to have the privilege and permission listed in Required DB2 LUW User Account Privileges . When these conditions are met, the Monitor DB2 Instance wizard checks that the rest of the required permissions exist and, if not, enables you to run the Grant Permissions script to grant missing permissions.

The Grant Permissions script verifies and sets the following general and pureScale-specific permissions.