Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Foglight for DB2 (Cartridge) 5.9.3.10 - 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 Storage Panel Notification Log Panel Initialization Parameters Panel

Member (History) 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 Instance home page — Memory Drill-down

Database home page

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

Member (History) 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 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

Database Tablespaces BP Collection

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

The name of the monitored database.

The tablespace name.

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

TABLESPACE_TYPE

This interface returns a text identifier, based on the definitions in sqlutil.h, which is one of the following values:

The tablespace ID.

POOL_ASYNC_DATA_READS

The number of data pages read in from the tablespace containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of tablespaces.

POOL_ASYNC_DATA_WRITES

The number of times a buffer pool data page was physically written to disk by either an asynchronous page cleaner or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched.

POOL_ASYNC_INDEX_READS

The number of index pages read in from the tablespace containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of tablespaces.

POOL_ASYNC_INDEX_WRITES

The number of times a buffer pool index page was physically written to disk by either an asynchronous page cleaner or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched.

POOL_ASYNC_DATA_READ_REQS

The number of read requests made by the prefetcher to the operating system. These requests are typically large block IOs of multiple pages.

POOL_ASYNC_READ_TIME

The total amount of time spent reading in data and index pages from the tablespace containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of tablespaces. This value is given in milliseconds.

POOL_ASYNC_WRITE_TIME

The total elapsed time spent writing data or index pages from the buffer pool to disk by database manager page cleaners.

POOL_DATA_L_READS

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

POOL_DATA_P_READS

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

POOL_DATA_WRITES

The number of times a buffer pool data page was physically written to disk.

POOL_INDEX_L_READS

The number of index pages that have been requested from the buffer pool (logical) for regular and large tablespaces.

POOL_INDEX_P_READS

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

POOL_INDEX_WRITES

The number of times a buffer pool index page was physically written to disk.

Like a data page, a buffer pool index page is written to disk for the following reasons:

•

To free a page in the buffer pool so that another page can be read

•

To flush the buffer pool

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

POOL_WRITE_TIME

Provides the total amount of time spent physically writing data or index pages from the buffer pool to disk. The elapsed time is given in milliseconds.

DIRECT_READ_REQS

The number of requests to perform a direct read of one or more sectors of data.

DIRECT_READ_TIME

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

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

DIRECT_WRITE_REQS

The number of requests to perform a direct write of one or more sectors of data.

DIRECT_WRITE_TIME

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

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

INDEX_HIT_RATIO

The percentage of index reads that were carried out from the buffer pool for the selected tablespace without having to perform physical reads.

100 * (1 - (POOL_INDEX_P_READS / (POOL_INDEX_L_READS) ) )

BUFFER_POOL_HIT_RATIO

The total hit ratio calculation for the selected tablespace.

(POOL_DATA_P_READS +

POOL_INDEX_P_READS) /

(POOL_DATA_L_READS +

POOL_INDEX_L_READS) ) )

FCM Activity Collection

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


Metric	Description
DB_NAME	The name of the monitored database.
DBPARTITIONNUM	The database partition from which the data was retrieved for this row.
CONNECTION_STATUS	This interface returns a text identifier, based on the definition in sqlmon.h, which is one of the following values: INACTIVE ACTIVE CONGESTED
CONNECTION_AVAILABILITY	The agent's connection FCM availability. Possible values are either 0 (INACTIVE or CONGESTED) or 100 (ACTIVE).
FCM_DBPARTITIONNUM	The database partition number to which data was sent or from which data was received (as per the TOTAL_BUFFERS_SENT and TOTAL_BUFFERS_RCVD columns).
TOTAL_BUFFERS_SENT	The total number of FCM buffers sent from the current node to the remote node. High values of this metric can indicate the need to redistribute the database or to move tables to reduce the inter-node traffic.
TOTAL_BUFFERS_RCVD	The total number of FCM buffers received by the node issuing the GET SNAPSHOT command, from the node identified by the NODE_NUMBER (see the db2nodes.cfg file). You can use this element to measure the level of traffic between the current node and the remote node. If the total number of FCM buffers received from this node is high, you may want to redistribute the database or move tables to reduce the inter-node traffic.
TOTAL_BUFFERS_SENT_RATE	The rate of the total number of FCM buffer pages sent from the current node to the remote node. This parameter can be used for measuring the level of traffic between the current and remote nodes. High inter-node traffic can be addressed by redistributing the database or moving tables to reduce the inter-node traffic.
TOTAL_BUFFERS_RCVD_RATE	The rate of the total number of FCM buffer pages received by the current node from the remote node. This parameter can be used for measuring the level of traffic between the current and remote nodes. High inter-node traffic can be addressed by redistributing the database or moving tables to reduce the inter-node traffic.

FS DB Storage Collection

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


Metric	Description
DB_NAME	The name of the monitored database.
FS_ID	This element shows the unique identification number provided by the operating system for a file system pointed to by a storage path.
FS_TOTAL_SIZE	This element shows the capacity (MB) of a file system pointed to by a storage path.
FS_USED_SIZE	This element shows the amount of space (MB) already used on a file system pointed to by a storage path.
STO_PATH_FREE_SIZE	This element shows the amount of free space (MB) available on a file system pointed to by a storage path. If multiple storage paths point to the same file system, the free size is not divided among them.

FS DB Storage Summary Collection

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


Metric	Description
OVERALL_FS_TOTAL_SIZE	This element shows the capacity (MB) per database of a file system pointed to by a storage path.
OVERALL_FS_USED_SIZE	This element shows the amount of space (MB) per database already used on a file system pointed to by a storage path.
OVERALL_STO_PATH_FREE_SIZE	This element shows the amount of free space (MB) per database available on a file system pointed to by a storage path. If multiple storage paths point to the same file system, the free size is not divided among them.
OVERALL_DB_FS_UTILIZATION	This element shows the amount of used space (MB) per database available on a file system pointed to by a storage path.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

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