Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 7.2.0 - User Guide

Introduction to Foglight for DB2 LUW Using 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 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.

2

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:

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.
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 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 view the alarms as well as configure the Alarm Template and alarm notification settings.
The Settings button — Use this button to do one of the following:
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.

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.

1
On the main Database dashboard, click Settings and select User Level Access from the menu.
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.
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.

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 .
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating