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

Using Foglight for DB2 LUW

Using Foglight for DB2 LUW

Foglight for DB2 LUW monitors the DB2 database activity by connecting to and querying the DB2 database. The agents provided monitor the DB2 database system. The dashboards included with the cartridge provide a visual representation of the status of the major components of the DB2 agents. They allow determining any potential bottlenecks in database performance.

Viewing the Databases Dashboard

The Databases dashboard displays summary information about all databases that exist in the monitored environment.

To access this dashboard, from the navigation panel:
1
Ensure that the navigation panel on the left is open.
To open the navigation panel, click the right-facing arrow on the left.
2
On the navigation panel, click Homes > Databases.

The Databases dashboard provides an at-a-glance view of the monitored environment, with all the currently monitored database types.

The Databases dashboard includes the sections listed:

•
Database cartridge type tiles — each tile represents a database type (SQL Server, Oracle, Sybase, DB2, or All) and displays the number of instances for each database type. The tile also displays a breakdown according to the instance health state severity (Normal, Warning, Critical, Fatal).
•
Status section — includes the following components:
•
Status summary — a color-coded bar, which provides a visual representation of the summarized health condition of all instances listed in the Database Group table.
The status summary bar provides a graphic representation of the monitored environment’s current state, broken down to the number of instances and their current health state: Fatal, Critical, Warning, Normal or Unknown.
•
Database-specific health summary — when the database group All is selected, this section displays all the currently monitored instances for each database type, divided by their health state (for example: four SQL Server instances, three of which have the health state Warning and one is indicated with the health state Fatal). When a user-defined database group is selected, this section displays data only about the agents included within the selected group.
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. For details, see Selecting an Instance to Monitor .
* 
NOTE: 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. For details, see Selecting an Instance to Monitor .
•
The Monitor button — Use this button to add instances to monitored.
•
The Configure Alarms button — Takes you directly to the Administration > Alarms page. On the Alarms page you can configure alarm settings and specify alarm sensitivity levels. Sensitivity levels control which alarms are enabled by default.
•
The Settings button — Use this button to do one of the following:
•
Access the User Management settings, allowing you to restrict which instances specific users are allowed to view. This restriction makes it easier to for users to find information about only the instances they are interested in. For details, see Assigning Instances to Users .
•
After selecting one or more instances of the same database type, use this button to set options for collecting, storing, and displaying data for the selected instances.
•
Currently selected database group table — a list of all monitored databases within the database group currently selected in the Databases section. For details, see Using the Currently Selected Database Group Table .
•
The Open the Quick View button — provides the ability to open a quick view of the instance at the bottom of the screen.
•
The Select dashboards () button — provides direct link to several drilldowns and panels, by that means saving the need to navigate to these locations through the Overview drilldown.
 
* 
IMPORTANT: If the display is filtered to show only DB2 instances the Databases table is renamed to DB2 Instances, and a new tab titled Reporting Services is shown. For details about this tab, see the following section.

Assigning Instances to Users

The User Level Access screen allows you to assign specific instances to users. As a result, when users view their Database dashboard, they only see the instances which have been assigned to them. This makes it easier to find the data which is relevant to them.

The User Management screen only displays users who are not Administrative users.

To assign instances to a specific user:
1
On the main Database dashboard, click Settings and select User Level Access from the menu.
The user management pane appears.
2
The table will display user names of all users, logon information, and instance information.
3
To assign one or more instances to a specific user, locate the user’s name in the table, click Configure in the right-hand column, and then click Manage from the context menu.
4
In the Assign Instances view, select the instances which should be assigned to this user and click the > button to add the selected instances to the Assigned Instances column.
5
Click Set and Close to save your choices and exit.

Selecting an Instance to Monitor

Because the Databases dashboard displays by default all the currently monitored databases, it is advisable to customize the dashboard’s view to display only the relevant instances, and then preview such instances to decide which to monitor.

To select an instance to monitor:
1
Display only instances relevant for your needs, using one of the following methods:
•
Filter by database type — if multiple database types are being monitored, click the database type tile that represents the requested type (in this case, DB2).
•
Filter by severity — use the status indicators to display only instances of a specific database type that share a specific health state severity. For further details, see Filtering the Display by Severity .
•
Create user-defined groups — use the Databases area to create groups that contain only the databases that need to be monitored for a specific need. For further details, see Creating User-defined Database Groups .
•
Assign Instances to specific users — When accessing a Database dashboard, non-administrative users will view only instances which have been assigned to them. For details, see Assigning Instances to Users .
2
View the selected instances’ severity level, using the status indicators.
3
Click the requested instance to view a cue card with a preview of the instance’s most significant performance indicators.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating