Chat now with support
Chat with Support

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

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.

3
Select the parent database instance group, Database Group, under Databases in the navigation pane.Click the button.
7
Click OK.

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

3
Click Remove.
5

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:

Using the Currently Selected Database Group Table

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

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.

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.

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.

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