Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 6.3.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 Existing Host Credentials as OS Credentials

To use the host credentials to access the OS:
1
Select a database instance or host from the list.
2
Click Set credentials.
The Edit Credentials dialog box opens.
3
Click Use existing Host Connection Details and click Apply.
Foglight for DB2 LUW attempts to connect to the OS. If the credentials are valid, the Save changes button is enabled. Otherwise, correct the credentials. See Creating or Editing OS Credentials.
4
When the credentials are valid, click Save changes.

Creating or Editing OS Credentials

To create or edit credentials used to access the OS:
1
Select a database instance or host from the list.
2
Click Set credentials.
The Edit Credentials dialog box opens.
3
Click Edit Host Connection Details.
The Edit Credentials dialog box expands to show the connection detail boxes.
4
If you want Foglight for DB2 LUW to monitor the instance’s OS, ensure that the Enable OS Monitoring check box is selected.
5
If credentials exist in this lockbox or another lockbox, select the credentials.
a
Click Select from stored credentials.
The Use Credentials dialog box opens.
b
Select a lockbox from the list.
c
Select a set of credentials from the list.
d
Click Apply.
The Edit Credential boxes display values for the selected credential. The password is masked.
6
Otherwise, create credentials by filling in the form.
a
Choose an authentication type from the list. The remainder of this example assumes a UNIX (log in cred.) authentication type.
b
Type a user name.
c
Type a password.
d
Type a port number.
e
If necessary, select the Use Sudo check box.
7
Click Apply.
Foglight for DB2 LUW attempts to connect to the OS. If the credentials are valid, the Save changes button is enabled. Otherwise, correct the credentials.
8
When the credentials are valid, click Save changes.
If an IC (Infrastructure Cartridge) agent currently exists, its credentials are updated. Otherwise, a new IC agent is created with the credentials.

Defining Data Collection Options

The Foglight for DB2 agent always collects and stores data, even when the browser window that displays the data is not active. Use the Collections page to specify:

•
Which collections are sampled and stored.
•
The data collection values when sampling is carried out in offline, online, and real-time frequency modes.
•
The collection frequency.

When a user is focusing on a page, the sampling frequency for all the collections associated with this page automatically switches to Real-Time. The collection frequency setting determines the sampling frequencies of the other collections (collections that are not running in Real-Time mode).

The available collection frequencies can be selected from the The selected agent's current collection frequency is (frequency) field located in the middle of the panel.

To change the selected agent's current collection frequency:
1
Click agent’s current frequency status.
The frequency settings dialog displays.
2
Select the required frequency.
The following settings are provided:
•
Low — all collections are running in Offline mode, regardless of whether a Client is connected
•
Normal — the collections running mode (Online/Offline/Real-time) adjusts dynamically to the Client's connection status (disconnected/connected/focusing on a page).
•
High — all collections are running in Online mode, regardless of whether a Client is connected.
3
Select the required setting.
4
Click Set.

The Query timeout for on-demand collections setting defines the number of seconds that a query for on-demand collections runs before it times out.

On-demand collections are collections who retrieve data not by predefined time intervals but upon entering a page or clicking a button. The default setting of this parameter is 60 seconds. It can be modified by clicking the number that indicates the parameter’s value in the field Query timeout for on-demand collections.

* 
IMPORTANT: In the Normal collection frequency, when the browser window that displays Foglight for DB2 is active, the collection frequency mode in the active page (for example: the Current Sessions panel in the Activity drilldown) switches to the fastest frequency possible, once every 20 seconds.

The Collections table contains the following columns:

 
Table 1. Collections table
Column
Description
Collection Enabled

Defines whether the selected collections are sampled and stored.

Collection Name

The name of the collection. This list is sorted in alphabetical order.

Offline Frequency (Sec)

Allows defining the collection interval, in seconds, in offline mode (for example: 300). Offline frequency is defined as the longest interval possible for sampling the monitored instance.

Online Frequency (Sec)

Allows defining the collection interval, in seconds, in online mode (for example: 60).

Real-time Frequency (Sec)

Allows defining the collection interval, in seconds, in real-time mode (for example: 20). Only one collection can be sampled for a real-time frequency at any given moment.

Query Timeout (Sec)

The amount of time, in seconds, that elapses before the query times out.

To modify the values of a specific collection:
1
Select the collection’s row in the table.
2
Click Edit.
The Edit the Collection dialog box appears.
3
Select whether to enable the collection and storage of the selected collection.
4
Set the collection interval, in seconds, in offline frequency mode (if available).
5
Set the collection interval, in seconds, in online frequency mode (if available).
6
Set the collection interval, in seconds, in real-time frequency mode.
7
Set the query timeout, in seconds.
8
Click Set to apply these settings or Cancel to reject them.

Customizing Alarms for Foglight for DB2 LUW Rules

Customizing Alarms for Foglight for DB2 LUW Rules
* 
NOTE: Foglight 6.3.0 introduces Alarm Templates, which provide a simplified method for customizing alarm rules and applying them to agents. As part of this change, the Sensitivity Level feature has been deprecated.

Many Foglight for DB2 LUW multiple-severity rules trigger alarms. To improve your monitoring experience, you can use alarm templates to customize when alarms are triggered and whether they are reported. You can also set up email notifications.

This section covers the following topics:

•
Introducing the Alarms View
•
Viewing Alarm Sensitivity Levels for Unassigned Agents
•
Modifying Alarm Templates
•
Configuring Email Notifications
•
Cloning Agent Settings
•
Reviewing Rule Definitions
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating