지금 지원 담당자와 채팅
지원 담당자와 채팅

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

Cloning Agent Settings

You may want an agent to have the same settings as another agent. For example, if you add new agents, you may want them to use the same settings as an existing agent. In this case, you can clone the settings from one agent to other agents.

This process does not link the agents; in the future if you update the source agent, you also need to update the target agents.

This procedure walks you through selecting the source agent from the Databases dashboard. However, you can also open the Administration dashboard with multiple agents selected. In this case, you select the source agent in Clone Alarm-related Settings to Other Agents dialog box.

2
Click Settings and then Administration.
4
Click Set configuration on selected agents.
7
Click Apply.

Reviewing Rule Definitions

If you want to review the conditions of a rule, open the rule in the Rule Management dashboard.

IMPORTANT: Avoid editing Foglight for DB2 LUW rules in the Rule Management dashboard. These rules may be modified during regular software updates and your edits are lost. Always use the Alarms view.

You can create user-defined rules from the Rule Management dashboard. If you want to modify a rule, we recommend copying the rule and creating a user-defined rule. Manage user-defined rules from the Rule Management dashboard; these rules are not displayed in the Alarms view of the Databases Administration dashboard. For help creating rules, open the online help from the Rule Management dashboard.

1
On the navigation panel, under Homes, click Administration.
3
Type DB2 in the Search field to see the list of predefined rules for DB2 databases.
The Foglight for DB2 LUW rules are displayed. From here, you can review threshold values, alarm counts, and descriptions.
7
Click Cancel to avoid changing the rule unintentionally.

Adding User-defined Collections

This page allows you to add user-defined collections to all the currently selected agents and to provide for queries not included in Foglight for DB2.

After collections are added, this page displays all the user-defined collections for all the agents. For example, if a collection was added to 12 agents during its addition, the page displays 12 rows, showing the collection for each agent.

This page is also used for configuring the sampling frequency for each collection. The available sampling frequencies are as follows:

Real — a user is focusing on a page, the sampling frequency for all the collections associated with this page switches to Real-Time.
Online — when at least one user is connected, the sampling frequency for all the collections that are not currently running at Real-Time frequency switches to Online.
Offline — when no user is connected to the application
1
Click Add.
The Add a User-defined Collection dialog box appears.
2
Click Set details.
7
Click Verify.

The collections’ ID

The name of the column

The field type.(String, Integer, etc.)

The column’s display name

The topology type for storage purposes. This type can be one of the following:

The metric’s unit of measurement. The possible measurement unit values are: Percent, Count, Millisecond, Second, Minute, Hour, Day, Byte, Kilobyte, Megabyte and Gigabyte.

Allows defining the value that is displayed in this metric, out of several values that were returned in the relevant time range.

The available aggregation values are:

As is — value of the last sample taken during the selected time range.
Sum — summarized value of all samples taken during the selected time range.
Average — average value of all samples taken during the selected time range.

Indicates whether the field is the query’s key for retrieval.

Select True in this column to enable the collection of baseline statistics for this metric.

The Edit Frequencies for the Collection dialog box appears.
10
Click Set.
11

On-demand Data Port

The On-demand Data Settings page allows you to define a port for each Foglight Agent Manager. Foglight for DB2 LUW uses this port to retrieve data and for integration with StealthCollect. By default, the collection of on-demand data is carried out using the same port used for connecting to the Performance Analysis middleware. Use this page to collect on-demand data through a different port, or if another port was allocated to the Performance Analysis middleware.

2
Click Set port.
4
Click Set.
5
Click Validate connectivity.
관련 문서