Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 5.9.3.20 - User Guide

Introduction to Foglight for DB2 LUW Using Foglight for DB2 LUW 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 Top SQLs Full Text Collection Top SQLs Text 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

Adding and Configuring Agents

Enabling the Foglight Management Server to monitor DB2 instances requires the creation of the Foglight agents that monitor these instances. Ensure that these agents communicate properly with the Foglight Management Server.

Foglight for DB2 LUW provides a graphic, intuitive method for creating and configuring multiple agents, which can be used instead of Foglight’s default method for creating agents and editing their properties using the Agent Administration dashboard. Foglight for DB2 LUW provides a wizard as a common entry point for adding and configuring instances for monitoring.

This topic ontains instruction for using the instance installation wizard, and the steps that should be taken for monitoring the newly added database instances.

* 
IMPORTANT: When running Foglight for DB2 LUW in a Federation architecture, agents cannot be created or administered from the central Foglight Management Server (the Federation Master). These two tasks should be carried out from the stand-alone Management Servers (the Federated Children).

Understanding the Foglight for DB2 LUW Architecture

Understanding the Foglight for DB2 LUW Architecture

The communication architecture of Foglight for DB2 LUW:

Figure 1. Communication architecture
 

Configuring the On Demand Port on the Agent Manager Concentrator

If a firewall is installed between the Management Server and the Agent Manager, the bidirectional RMI connection is not possible because RMI requests require direct connection.

This issue can be resolved by creating an RMI proxy server on the concentrator — an Agent Manager instance that works similarly to an HTTP proxy. This RMI proxy server can be configured to accept RMI requests from the Management Server and direct them to the Agent Manager instances (called downstream instances). For additional details about the concentrator, see Configuring an Agent Manager Instance as a Concentrator in the Agent Manager Installation Guide.

Figure 2. Bidirectional RMI connection.

A concentrator agent, created specifically for Foglight, allows you to control the RMI server so that the server is initialized (starts collecting data) when the agent starts, and stops when data retrieval by the agent ends. The agent, created manually by the user, requires you to configure the following parameters:

•
A list of the downstream hosts that are connected through the concentrator
•
The RMI port number

Each time the Foglight Management Server sends an RMI request, the list of downstream hosts, which the concentrator agent submits, is being searched.

•
Inclusion of the target RMI server host name within this list indicates that a FglAM concentrator exists, in which case a connection is made to the proxy RMI server.
•
If the list does not contain the target host name, the connection is made directly to the target RMI server.
To create the concentrator agent:
1
Go to Dashboards > Administration > Agents > Agent Status.
2
Click Create Agent.
3
Select the agent type DB_DB2_Concentrator.
4
Enter a name of your choice.
5
Click Create.
6
After the creation process is completed successfully, click OK.
To edit the concentrator agent connection details:
1
Select the newly created concentrator agent.
2
Click Edit Properties.
3
Click Modify properties for this agent only.
4
Enter the number of the proxy RMI server port, or accept the default number.
5
Enter the concentrator Agent Manager host name (optional).
6
Click Edit to edit the list of downstream Agent Managers.
7
Click Add Row.
8
Enter the name of the requested Foglight Agent Manager host.
* 
IMPORTANT: When editing the properties of the Agent Manager concentrator (Dashboards > Administration > Agents > Agent Status), the name of the Agent Manager should be entered in the Downstream FglAMs section exactly as it appears in the topology, under Home > Agents > All agents > <Agent name> > RMI data > Fglam host property. The <Agent name> parameter is defined as any of the Foglight for DB2 LUW agents that reside on the selected Agent Manager.
9
Repeat Step 7 to Step 8 as many times as required.
10
Click Save Changes.
11
Click Save at the lower right corner of the screen.
12
Click Back To Agent Status.
13
Select the newly created concentrator agent and click Activate.
14
Click OK to complete the process.
* 
IMPORTANT: In an environment that includes an Agent Manager concentrator, when upgrading the environment where the concentrator does not contain any regular agents, the concentrator is not upgraded. Therefore, after the upgrade process takes place the Agent Manager concentrator must be deployed manually.

Configuring Foglight for DB2 LUW Monitoring Agents

Configuring Foglight for DB2 LUW Monitoring Agents

A wizard guides you through the process of configuring Foglight for DB2 LUW 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.

To monitor DB2 instances:
1
In the navigation panel, under Homes, click Databases.
On a fresh installation, no instances are listed for DB2 in the Databases dashboard.
2
In the instances table, click the Monitor link and select DB2.
The Monitor DB2 Instance wizard opens.
3
Follow the online prompts to configure an agent to monitor the DB2 host, instance, and databases. For help with options, click .
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating