Tchater maintenant avec le support
Tchattez avec un ingénieur du 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

Introduction to Foglight for DB2 LUW

Welcome to the Monitoring DB2 Database Systems User and Reference Guide. This guide provides agent configuration instructions and information on investigating DB2 performance. It describes the dashboards included with the cartridge and contains instructions for configuring the agents the cartridge uses to collect monitoring data from the entire relational database management system. Also, this guide provides information about the rules and data tables that are available for your monitored system.

This guide is intended for any user who wants to know more about the agents properties and the dashboards included with the cartridge. It is also meant for those users that want to learn about the rules that are included with the cartridge, and the data the DB2 and DB2 Monitor agents collects.

Upgrading to the Current Version

Starting to work with a Foglight for DB2 instance requires upgrading to the current version of both the instance and the Agent Manager that runs the instance.

This topic contains instructions for using the upgrade wizard.

 
* 
NOTE: This topic is relevant only for existing Foglight users. If Foglight for DB2 LUW is being used for the first time and the Agent Manager is the updated version, as indicated in the release notes, skip this topic.
 
* 
IMPORTANT: Foglight for DB2 LUW does not support the upgrade method of placing the new version in the FGLHOME/upgrade/cartridge folder.
 
* 
IMPORTANT: When upgrading to the current version of Foglight for DB2 LUW in a Federation architecture, first upgrade the Federated database servers and then the Federation Server. If the Federation Server is upgraded first, the server displays incorrect information regarding the number of instances being monitored, as reported in the Status Summary. All the same, the information displays correctly on the Federated databases.

Overview

Any upgrade of Foglight for DB2 to the latest version, without upgrading the database cartridge components, is detected after the Databases dashboard is loaded. The upgrade is detected either automatically (by default: every 60 seconds) or manually, by clicking F5. Upon detecting the need for upgrade, the upgrade wizard starts automatically.

Selecting the check box at the bottom left of the upgrade wizard prevents the wizard from appearing upon entering the Databases dashboard. Nevertheless, if several database cartridge components still require upgrade, the need to upgrade them is still indicated on the dashboard by:

•
The Upgrade required caption, which is displayed in red to the right of the requested instance
•
The Upgrade button, which appears only if upgrade is required.
* 
NOTE: Instances whose components must be upgraded appear in the Databases table. However, it is not possible to access those instances by clicking them. They must be upgraded first.

Running the Upgrade Wizard

To upgrade the requested instances:
1
Click Upgrade.
The screen that appears now is the same screen that appears by default upon entering the Databases dashboard when one or more database cartridge components require upgrading. The upgrade is carried out separately for each database cartridge type.
2
Click Foglight for DB2.
A Welcome page displays What's New in this release, including bug fixes. At the bottom of the New Features table, is a link to the Rule Modification Overview page, where you can review the list of rules that have been modified and are in the following states:
•
Removed - The rule is obsolete and was deleted from the Management Server.
•
New - The rule is new in this release. To review its definition, click View new rule.
•
Updated - The rule was updated in this release. To review the updated rule, click View updated rule. If a rule targeted for update was modified by a user, the user's modified rule is copied and disabled before the updated rule is installed. To review the modified rule, click View user updated rule.
* 
TIP: To avoid having to repeat rule modifications after an upgrade, do not edit rules with the DB2 prefix in the Rule Management dashboard. Use the Alarms Template dashboard instead. When you make your edits on the Alarms view, the edits are saved separately and applied over the predefined rules. For instructions, see Customizing Alarms for Foglight for DB2 LUW Rules .
3
Select the Agent Managers to upgrade..
* 
NOTE: The Other Agents column in the table indicates whether the specified Foglight Agent Manager runs agents of other cartridge types. If a value is displayed in this column, go to Dashboards > Administration > Agents > Agent Status to view which other agents run under the specified Foglight Agent Manager. If the other agents appear in the list below, upgrading Foglight Agent Manager to the latest version is safe. For agents of any other cartridge type, consult the documentation of the respective cartridge types.
•
DB_DB2_*
•
DB_SQL_Server_*
•
DB_Oracle_*
•
Sybase_MDA
•
UnixAgent
•
WindowsAgent
4
Click Upgrade the selected Agent Managers.
A progress bar appears.
5
After the upgrade is complete, click Next.
The next screen is used for granting privileges to users that were detected as possibly requiring additional
privileges to ensure full functionality.
6
Select the agents displayed in the table and click Validate connectivity.
7
If the status row of one or more agents displays the status Insufficient privileges, complete the following steps:
a
Select all agents that require privileges updates, and click Grant privileges.
b
In the Grant Database Privileges dialog box, enter a SYSADMIN user name and password.
c
To view the script used for granting the privileges, click View script.
* 
IMPORTANT: The script for granting privileges is invoked using a popup. To view the script, ensure that pop ups are not blocked on the page
d
Click Grant database privileges.

 

Outils libre-service
Base de connaissances
Notifications et alertes
Support produits
Téléchargements de logiciels
Documentation technique
Forums utilisateurs
Didacticiels vidéo
Flux RSS
Nous contacter
Obtenir une assistance en matière de licence
Support Technique
Afficher tout
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation