Chat now with support
Chat with Support

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

Database Connection Details

You use the Database Management view on the Databases Administration dashboard to manage the list of monitored databases and validate their connection settings.

Setting credentials and instance properties

You can validate the login credentials and instance properties.

To edit instance credentials and properties:
1
Select the instance you want to set the credentials for.
2
Click on the instance name.
The DB2 Instance details dialog appears.
3
Edit the details.
4
Click Validate.
To edit database credentials:
1
Select the required database.
2
Click on the Validate connectivity link in the connection status beside the database name.
3
Select whether to use the same credentials used for the instance (default), or to assign custom credentials for the database.
* 
TIP: An instance must have at least one monitored database. If an instance contains no databases you want to monitor, remove the instance.

Diagnostic Log

Use the Diagnostic Log view to configure the retrieval and display settings for the Log panel. In addition, this view is used to define default settings for invoking alarms based on the collected alerts.

Use this view to define the following settings:

•
Minimal severity for invoking summary alarms - can be either turned off (the default setting) or set to one of the defined severity values, that is: Warning, Critical, Error, Event or Severe.
•
Minimal severity for invoking alarms - can be either turned off or set to one of the defined severity values: Warning, Critical, Error, Event or Severe (Default).
•
Number of rows to collect from logs - the maximum number of rows that would be retrieved from the alert logs.
•
Messages to include in the Log panel display - using the Match List pane, which contains a default list of expressions within the diagnostic log that are to be retrieved and displayed in the Log panel.
•
Message to Exclude from the Log panel display - using the Ignore List pane, which contains a default list of expressions within the diagnostic log that are to be excluded from the diagnostic log display.
* 
IMPORTANT: Only messages that are explicitly defined in the Match List and not filtered in the ignored list will be displayed.

Both the Match List and the Ignore List panes can be customized by adding, editing or removing messages. Each filter can be enabled or disabled separately by clicking Edit and selecting or clearing the Enabled check box. Alternatively, to enable or disable all of the filters, click Enable All or Disable All.

To add a message to the Match List:
1
Click Add.
The Add an Aleart to the Match List dialog displays.
2
Use this dialog box to configure the alert filter by means of the following fields:
•
Filter Name - used for assigning a name to the filter.
•
Field Name - used to select by which of the message parameters, message will be filtered. Possible fields include: Severity, Message text, Impact, Component, Function, Type or FullRec (The entire message record)
•
Expression - identifies a regular expression that will be evaluated against the Field selected above and used together in order to select the message. For example: To filter message that their text related to files, you should select "Message" as the Filter Name and "*File*" as the Expression.
3
Click Add to save your settings. Each newly added alert filter is enabled by default.
To disable the filter, click Edit and then clear the Enabled check box.
To edit a Filter:
1
Click the requested filter.
2
Click Edit. The Edit the Selected Alert dialog opens.
3
Use this dialog to configure the alert by using the same fields when you added it: Filter Name, Field Name, and Expression.
4
To disable the filter, clear the Enabled check box.
5
Click Set to save your settings.
6
At the bottom of the view, click Save Changes.

Exploring DB2 Database Performance Metrics

The Foglight for DB2 LUW Foglight for DB2 LUW provides a set of homepages that display performance metrics collected from the monitored systems. These homepages allow you to monitor, analyze, investigate the DB2 performance, and identify potential bottlenecks. The various homepages are described in the following sections and include a reference with the heading and page number:

•
Instance Homepage
•
Database Homepage
•
Member (History) Homepage
•
Member (Real Time) Homepage
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating