Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 5.9.3.10 - 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.

1
In the navigation panel, under Homes, click Databases.
2
In the instances table, click Monitor more instances and select Add one DB2.

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.

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:

Instances home page — See the Additional Information and PureScale CF panes.
Instances home page > Memory — See the Primary CF and Backup CF tabs.
Database home page — See the Balance Criterion and Memory panes.
Member (History) home page — See the Request Time Breakdown pane.
Member (Real Time) home page — See the Request Time Breakdown pane.
Member (either) home page > Activity > Locks — See the PureScale Lock Time tab.
Member (either) home page > Memory > Buffer Pools — See the GBP Hit Ratio tab.

 

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.

Related Documents