Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Foglight for DB2 (Cartridge) 5.9.5.20 - User Guide

Table of Contents

Introduction to Foglight for DB2 LUW

Upgrading to the Current Version Overview Running the Upgrade Wizard

Using Foglight for DB2 LUW

Viewing the Databases Dashboard

Assigning Instances to Users Selecting an Instance to Monitor

Filtering the Display by Severity Creating User-defined Database Groups Components Shared by All Foglight for DB2 LUW Screens Using the Currently Selected Database Group Table

Adding and Configuring Agents

Understanding the Foglight for DB2 LUW Architecture Configuring the On Demand Port on the Agent Manager Concentrator Configuring Foglight for DB2 LUW Monitoring Agents

Administering Foglight for DB2 LUW

Opening the Databases Administration Dashboard Reviewing the Administration Settings Adding or Editing OS Credentials

Using Existing Host Credentials as OS Credentials Creating or Editing OS Credentials

Defining Data Collection Options Customizing Alarms for Foglight for DB2 LUW Rules

Introducing the Alarms View Setting and Modifying Alarm Sensitivity Levels Modifying Alarm Settings Configuring Email Notifications Cloning Agent Settings Reviewing Rule Definitions

Adding User-defined Collections On-demand Data Port Database Connection Details

Setting credentials and instance properties

Exploring DB2 Database Performance Metrics

Instance Homepage Database Homepage

Using the Database Homepage Toolbar Activity Panel Memory Panel Storage Panel Diagnostic Log Panel Initialization Parameters Panel

Member Overview Homepage Member (Real Time) Homepage

Reporting on Your DB2 Environment

About the Foglight for DB2 LUW Reports

Dashboards and Views

Databases Dashboard

Database Alarms Database Environment Tiles Databases Instances View Database Cue Card

Instance home page

How to Get Here Summary Memory Drill-down

Database home page

How to Get Here Summary SQL Performance Activity Drill-downs Memory Drill-downs Storage Drill-downs Tablespaces Tablespaces Buffer Pool Activities Log Drill-down Configuration Drill-down

Member Overview home page

How to Get Here Summary

Member (Real Time) home page

How to Get Here Summary

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

Database Buffer Pools Collection

The following table provides a list of the Database Buffer Pools metrics that are collected, and a description for each.

The database partition from which the data was retrieved for this row.

The name of the monitored instance.

The name of the monitored database.

The name of the monitored buffer pool.

The number of the tablespaces using this buffer pool.

TOTAL_LOGICAL_READS

The total number of logical reads (index, XDA, and data) in the buffer pool.

TOTAL_LOGICAL_READS_S

The total number of logical reads per second (index, XDA, and data) in the buffer pool.

TOTAL_PHYSICAL_READS

The total number of physical reads (index, XDA, and data) in the buffer pool.

TOTAL_PHYSICAL_READS_S

Total number of physical reads per second (index, XDA, and data) in the buffer pool.

TOTAL_HIT_RATIO_PERCENT

The total hit ratio (index, XDA, and data reads).

DATA_LOGICAL_READS

The data logical reads, which includes access to data that is:

•

Already in the buffer pool when the database manager needs to process the page.

•

Read into the buffer pool before the database manager can process the page.

DATA_LOGICAL_READS_S

The data logical reads per second.

DATA_PHYSICAL_READS

The number of data pages read in from the tablespace containers (physical) for regular and large tablespaces.

DATA_PHYSICAL_READS_S

The number of data pages read in per second from the tablespace containers (physical) for regular and large tablespaces.

DATA_HIT_RATIO_PERCENT

The data hit ratio.

INDEX_LOGICAL_READS

The index logical reads, which includes access to index pages that are:

•

Already in the buffer pool when the database manager needs to process the page.

•

Read into the buffer pool before the database manager can process the page.

INDEX_LOGICAL_READS_S

The index logical reads per second.

INDEX_PHYSICAL_READS

The number of index pages read in from the tablespace containers (physical) for regular and large tablespaces.

INDEX_PHYSICAL_READS_S

The number of index pages read in per second from the tablespace containers (physical) for regular and large tablespaces.

INDEX_HIT_RATIO_PERCENT

The index hit ratio.

XDA_LOGICAL_READS

The number of data pages for XML storage objects (XDAs) that have been requested from the buffer pool (logical) for regular and large tablespaces.

XDA_LOGICAL_READS_S

The number of data pages per second for XML storage objects (XDAs) that have been requested from the buffer pool (logical) for regular and large tablespaces.

XDA_PHYSICAL_READS

The number of data pages for XML storage objects (XDAs) read in from the tablespace containers (physical) for regular and large tablespaces.

XDA_PHYSICAL_READS_S

The number of data pages per second for XML storage objects (XDAs) read in from the tablespace containers (physical) for regular and large tablespaces.

XDA_HIT_RATIO_PERCENT

The auxiliary storage objects hit ratio.

POOL_READ_TIME_S

The total amount of time spent reading in data and index pages from the tablespace containers (physical) for all types of tablespaces.

POOL_WRITE_TIME_S

The total amount of time spent physically writing data or index pages from the buffer pool to disk.

The number of read operations that do not use the buffer pool. Direct reads are used when:

Reading LONG VARCHAR columns

Reading LOB (large object) columns

Performing a backup

The number of read operations that do not use the buffer pool, per second.

The number of write operations that do not use the buffer pool. Direct writes are used when:

•

Writing LONG VARCHAR columns

•

Writing LOB (large object) columns

•

Performing a restore

•

Performing a load

•

Allocating new extents for SMS tablespaces, if MPFA is enabled (which is the default)

DIRECT_WRITES_S

The number of write operations that do not use the buffer pool, per second.

DIRECT_READ_TIME_S

The elapsed time (in seconds) required to perform the direct reads.

DIRECT_WRITE_TIME_S

The elapsed time (in seconds) required to perform the direct writes.

The total number of database files closed.

You can use this element to assist in determining the best value for the maxfilop configuration parameter.

UNREAD_PREFETCH_PAGES

The number of pages that the prefetcher read in that were never used.

If this number is high, prefetchers are causing unnecessary I/O by reading pages into the buffer pool that will not be used.

GBP_LOGICAL_READS

The number of times an attempt was made to read a group buffer pool (GBP) dependent page from the group buffer pool, because the page was either invalid or not present in the local buffer pool (LBP). This is for pureScale instances only, which are not yet supported.

GBP_PHYSICAL_READS

The number of times a GBP dependent page was read into the LBP from disk, because it was not found in the GBP. This is for pureScale instances only, which are not yet supported.

The percentage of time a requested page was found in the GBP out of all of the times it was requested. If a page is found in the GBP, that saves the database time, because the database does not have to look for it in the LBP. This is for pureScale instances only, which are not yet supported.

Database Tables Collection

The following table provides a list of the Database Tables metrics that are collected, and a description for each.

The database partition from which the data was retrieved.

The name of the monitored instance.

The name of the monitored database.

The schema of the table.

Along with TABNAME this element can assist in determining the source of the contention for resources.

The name of the table.

The type of table for which information is returned.

•

•

DROPPED_TABLE - User table that has been dropped.

•

TEMP_TABLE - Information regarding temporary tables is returned, even though the tables are not kept in the database after being used. You may still find information about this type of table useful.

•

CATALOG_TABLE - System catalog table.

•

An integer that uniquely represents a tablespace used by the current database.

DATA_OBJECT_PAGES

The number of disk pages consumed by a table. This represents the base table size only. Space consumed by index objects, LOB data, and long data are reported by INDEX_OBJECT_PAGES, LOB_OBJECT_PAGES, and LONG_OBJECT_PAGES, respectively.

INDEX_OBJECT_PAGES

The number of disk pages consumed by all indices defined in a table.

LOB_OBJECT_PAGES

The number of disk pages consumed by LOB data.

LONG_OBJECT_PAGES

The number of disk pages consumed by long data in a table.

XDA_OBJECT_PAGES

The number of disk pages consumed by XML storage object (XDA) data.

The number of rows read from the table.

The number of rows changed (inserted, deleted, or updated) in the table.

OVERFLOW_ACCESSES

The number of reads and writes from/to overflowed rows of this table.

The number of page reorganizations executed for a table.

Database Partition Backup Collection

The following table provides a list of the Database Partition Backup Collection metrics that are collected, and a description for each.

The database partition number from which the data was retrieved for this row.

LAST_SUCCESSFUL_BACKUP_START

The start time of the last successful backup.

LAST_SUCCESSFUL_BACKUP_END

The end time of the last successful backup.

LAST_SUCCESSFUL_BACKUP_TYPE

The type of the last successful backup.

•

F - Full offline

•

N - Full online

DAYS_SINCE_LAST_SUCCESSFUL

The number of days that have passed since the last successful backup.

LAST_BACKUP_START

The start time of the last backup.

LAST_BACKUP_END

The end time of the last backup.

LAST_BACKUP_TYPE

The type of the last backup.

•

D - Delta offline

•

E - Delta online

•

•

I - Incremental offline

•

•

O - Incremental online

LAST_BACKUP_STATUS

The sqlcode value returned for the most recent running backup.

•

•

Any other number - An error occurred

For more detail, query dbadmin db_history.

Database Tables Global Collection

The following table provides a list of the Database Tables Global metrics that are collected, and a description for each.

The name of the monitored instance.

The name of the monitored database.

The schema of the table.

Along with TABNAME, this element can assist in determining the source of the contention for resources.

The name of the table.

The type of table for which information is returned.

•

•

DROPPED_TABLE - User table that has been dropped.

•

TEMP_TABLE - Information regarding temporary tables is returned, even though the tables are not kept in the database after being used. You may still find information about this type of table useful.

•

CATALOG_TABLE - System catalog table.

•

An integer that uniquely represents a tablespace used by the current database.

DATA_OBJECT_PAGES

The number of disk pages consumed by a table. This represents the base table size only. Space consumed by index objects, LOB data, and long data are reported by INDEX_OBJECT_PAGES, LOB_OBJECT_PAGES, and LONG_OBJECT_PAGES, respectively.

INDEX_OBJECT_PAGES

The number of disk pages consumed by all indices defined in a table.

LOB_OBJECT_PAGES

The number of disk pages consumed by LOB data.

LONG_OBJECT_PAGES

The number of disk pages consumed by long data in a table.

XDA_OBJECT_PAGES

The number of disk pages consumed by XML storage object (XDA) data.

The number of rows read from the table.

The number of rows changed (inserted, deleted, or updated) in the table.

OVERFLOW_ACCESSES

The number of read and write operations from/to overflowed rows of this table.

The number of page reorganizations executed for a table.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center