Chat now with support
Chat with Support

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

Filtering the Display by Severity

The Status Indicators section can be used for filtering the Databases Group table to display only instances that meet a criterion set in this section.

To filter the display by severity:
1
Click a a certain type of severity within a specific database type (for example: DB2 instances whose severity level is Critical).
The selected filter is shown in the table’s title.
2
To select another filter, click the required status indicator (for example: DB2 > Normal severity).

Creating User-defined Database Groups

Creating User-defined Database Groups

Use the Databases area of the navigation pane to create, edit, and remove groups of database instances. Click Edit Group to add or remove database instances from the sub-group.

To create a database group:
3
Select the parent database instance group, Database Group, under Databases in the navigation pane.Click the button.
The Add Group dialog box opens.
4
Type a name for the group in the Name field.
5
Type a description for the group (optional).
6
Select an instance in the Available column, and click [>] to move the instance to the Selected column.
Alternatively, click [>>] to move all of the databases to the Selected column.
7
Click OK.
The group name appears in the Database Groups list.
The database instances are listed in the Databases pane.

After adding one or more user-defined groups, it is possible to add sub-groups to these groups.

To add sub-groups to a selected group:
1
Position the cursor on the requested group’s name.
2
Repeat Step 3 to Step 7 described in To create a database group:.
* 
NOTE: The Add Group dialog box displays the name of the parent group in the Parent field. Before proceeding, ensure that the sub-group is added to the requested group.
To remove a database group:
1
Select the group to be removed.
2
Click the button.
The Remove Groups dialog box appears, asking approval to remove the selected group with all its sub groups.
 
3
Click Remove.
The group is removed from the Database Groups list.
To edit a database sub-group:
1
Select the requested group.
2
Click the button.
The Edit Group dialog box opens.
3
To add an instance to the group, select the requested instance in the Available column and click [>] to move the selected instance to the Selected column.
4
To remove an instance from the sub-group, select the requested instance in the Selected column, and click [<].
The selected instance moves to the Available column.
5
Click OK.

Components Shared by All Foglight for DB2 LUW Screens

Components Shared by All Foglight for DB2 LUW Screens

The tables’ Customizer button and the In-context action button are common to all Foglight for DB2 LUW screens, as described below.

•
The Customizer button — use this button, which is found on the upper right corner of each table, to create a custom filter for the table. The filter is created by clicking Customizer and specifying the criteria that the various values should meet in order to be displayed in the table (having a specific name, exceeding a certain size, and so on). For detailed instructions and examples, see Foglight User Guide > Working with Dashboards > Working with Tables.
•
In-context actions button — found on the upper right corner of all screens, and provides the following options:
•
Agent settings — when using panels whose configuration is set using the Databases Administration dashboard, clicking this button opens the relevant screen in the Databases Administration dashboard (for example, clicking this button from within the Databases > Locks panel opens the Locks screen).
•
Refresh — clicking this button retrieves the data acquired using the most recent sampling.
•
Useful links — used for carrying out further investigation using the following external sources:
•
Navigate to Oracle Performance — a central knowledge base about all of Quest Software’s database monitoring products.
•
Ask Foglight Community — Forum for Foglight products.
•
Contact support — central knowledge base about all of Quest Software’s products.
•
About — Information regard the versions being used.

Using the Currently Selected Database Group Table

The currently selected database group table displays the columns listed below.

 
 
Name
Description
Instance

Sev

The highest severity alarm of the DB2 database (whether a database instance, RAC or RAC node), which determines the database’s health state.

Name

The name of the DB2 instance, RAC or RAC node. In addition, this row includes the Go to Home Page button.

Version

The version number of the DB2 database instance.

Up Since

The date and time that the DB2 database instance (or, in a RAC, the instance that was the earliest to restart) was last restarted.

Workload

The workload (average active sessions) for the DB2 database instance or RAC. When holding the cursor over the workload graph, the dwell displays a chart that shows the workload history over the specified time range.

DB Alarms

The number of warning, critical, and fatal alarms for the DB2 database instance/RAC.

When holding the cursor over one of the alarm counts, the dwell displays the most recent alarms invoked for this database, sorted by severity.

Clicking this field displays the Alarms list, which is listed by severity order. See the Foglight Online Help, Monitoring System-Wide Alarms for details on the alarm information.

System Utilization

Host

The name of the computer that is hosting the database instance or RAC.

CPU Load (%)

The overall operating system CPU usage by all processes (including CPU usage by the database).

Memory (%)

The percentage, within the total memory, of memory consumed by all operating system processes (including the database). This value includes both RAM resident memory and swapped memory.

Disk (% Busy)

The percentage of time the busiest device spent serving system-wide input/output requests. This metric serves as a measure for the system I/O load.

Monitoring Status

Agent

The operational status of the monitoring agent.

When the agent instance is running, the State icon () is green, and holding the cursor over the icon displays the message Collecting Data.

When the agent instance is running but not collecting data, holding the cursor over the icon displays one of the following status messages listed below.

•
Starting
•
Stopped
•
Stopping
•
Unknown

When SQL PI is configured the SQL PI icon is displayed.

OS

The status of the OS data retrieval.

NOTE: While the Foglight for DB2 LUW agent retrieves OS data, several OS metrics cannot be retrieved without the Infrastructure cartridge agent. IF OS monitoring was disabled during the creation of the Foglight for DB2 LUW agent through the Oracle Monitoring Installer wizard, the wizard cannot automatically create the Infrastructure cartridge agent; However, this agent can be created manually using the Dashboards > Hosts > Hosts dashboard. For details, see Adding a Monitored Host in the Managing the Infrastructure Cartridge User and Reference Guide.
NOTE: If the Infrastructure agent was created, but OS database is collected only by the Foglight for DB2 LUW agent, click the OS status to OS data collection through the Infrastructure agent.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating