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

Reporting on Your DB2 Environment

Foglight for DB2 LUW allows you to generate reports about various aspects of the performance of the selected database instance. This section provides instructions for generating reports and a brief description of each report.

Foglight for DB2 LUW comes with a set of pre-defined reports. Operators can run those reports, build custom reports, and view generated reports. Advanced Operators can also schedule and manage reports.

To access the Reports dashboard, from the Foglight navigation pane, select Dashboards > Reports. From the Reports dashboard, click the links provided as described below:

•
Click Build a Custom Report to choose the building blocks for your custom report using the Create Report wizard.
•
Click Run a Report to select and generate or schedule a report using the Run Report wizard.
•
Click Manage Reports to access the Manage Reports dashboard, where you can download, delete and view details about generated reports.
* 
NOTE: You can also access the reports features using the Reports menu at the top right of any dashboard or on the General tab of the Action panel to the right of any dashboard. Select the Create a new report option to launch the Create Report wizard and define the components to be used to build a new report.

For more information on using the Foglight reporting features, see the Foglight User Guide or online help.

About the Foglight for DB2 LUW Reports

About the Foglight for DB2 LUW Reports

Foglight for DB2 LUW comes with a set of pre-defined report templates, which provide an analysis of the performance and health of your DB2 LUW environment over time.

Each report template uses report parameters to define the content of the report. Use a template’s default report parameters to quickly generate or schedule a report, or optionally change the report parameters to customize the report to better meet your requirements.

The following Foglight for DB2 LUW reports are available:

* 
NOTE: If you are using the Templates by Module tab on the Run Report wizard, click the expansion box to the left of Databases > DB2 to view the Foglight for DB2 LUW reports.
 
•
Comparison of Databases Report — reports on and compares the I/O activity between selected databases. For this report, you provide a time range and more than one database.
•
Executive Workload Summary Report — provides a workload overview for the instance and for each database.
•
Health Check Report — reports on the database availability, response time, and connection time. For this report, you provide a time range and a database.
•
Storage Summary Report — provides an overview of storage utilization using relevant categories such as disk space usage, file system usage (as it relates to automatic storage tables spaces), log storage, and top-consuming tablespaces. For this report, you provide a time range and a database.
•
Top SQLs Report — provides detailed information about the SQL statements that consumed CPU over the longest period of time or experienced the highest number of total wait events. For this report, you provide a time range and a database.

 

Reference

This topic contains reference information about the following topics:

•
Dashboards and Views
•
Collections and Metrics

Dashboards and Views

Foglight displays monitoring data in views that group, format, and display data.

Dashboards are top-level views that contain lower-level views. The dashboards supplied with Foglight, and user created dashboards, are accessible from the navigation panel.

Lower-level views in Foglight can be added to dashboards or can be accessed by drilling down from a dashboard. They receive and display data directly from the Foglight Management Server or from other views. Some views filter or select data that appears in other views in the same dashboard. Some are tree views with expandable nodes for selecting servers, applications, or data.

This section describes the following Foglight for DB2 LUW dashboards and home pages:

•
Databases Dashboard
•
Instance home page
•
Database home page
•
Member (History) home page
•
Member (Real Time) home page
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating