Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 5.9.5.10 - 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

Memory Drill-downs

The Memory drill-down provides access to:

Provides memory summary metrics on the members and memory pools for the selected database.

Select Whole Database or a member within the selected database from the list at the top of the pane.

On the Database home page toolbar, click Memory and select Memory Summary.

DB Memory. Displays the total memory allocated to the selected database.
Pool Allocated Size. Displays a breakdown of the total memory allocated to the members of the selected database using a bar chart.
Pool Breakdown. Displays a breakdown of the total memory allocated to the members of the selected database using a pie chart.
Pool Name. The name of the memory pool.
Utilization %. The percentage of configured allocated memory that is in use.
Allocation. The average allocated size (in KB) of a memory pool.
Config Size. The internally configured size (in KB) of a memory pool in the DB2 database system.
Alarm. The alarm count and state of the member or memory pool. Click an alarm count to view information about the alarm on the Outstanding Alarms dialog box. For complete information about alarms in Foglight, see the Foglight User Help.

Provides performance metrics on the buffer pools for the selected database.

On the Database home page toolbar, click Memory and select Buffer Pools.

This view provides the following embedded views:

 

The Details tab displays a top-level summary of the buffer pools. The tabs in the lower portion of the view display graphs of the various metrics over time.

Buffer Name. The name of the monitored buffer pool.
Total Hit Ratio. A measure of how often a page access (getpage) is satisfied without requiring an I/O operation.
Tablespaces. The number of tablespaces using this buffer pool.
Data Hit Ratio. A measure of how often a data page access (getpage) is satisfied without requiring an I/O operation.
Index Hit Ratio. A measure of how often an index page access (getpage) is satisfied without requiring an I/O operation.
XDA Hit Ratio. A measure of how often an XML storage object (XDA) page access (getpage) is satisfied without requiring an I/O operation.
pureScale onlyGBP Hit Ratio. A measure of how many times a requested page was found in the GBP out of all times it was requested.
Col Hit Ratio. A measure of how often a column-organized page access is satisfied without requiring an I/O operation. Available for version 10.5 and above.
Read Time. Indicates the total amount of time (in seconds) spent reading in data and index pages from the tablespace containers (physical) for all types of tablespaces.
Write Time. Provides the total amount of time spent (in seconds) physically writing data or index pages from the buffer pool to disk.
Direct Reads Rate. The number of read operations that do not use the buffer pool, per second.
Direct Writes Rate. The number of write operations that do not use the buffer pool, per second.
Direct Read Time. The elapsed time (in seconds) required to perform the direct reads.
Direct Write Time. The elapsed time (in seconds) required to perform the direct writes.
Files Closed. The total number of database files closed. This element can be used to help with determining the best value for the maxfilop configuration parameter.
Unread Prefetch Pages. Indicates 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 are not being used.
Alarms. The alarm count and state of the member or memory pool. Click an alarm count to view information about the alarm on the Outstanding Alarms dialog box. For complete information about alarms in Foglight, see the Foglight User Help.
Size. The current buffer pool size in pages.
Col Logical Reads. Indicates the number of column-organized pages requested from the buffer pool (logical) for regular and large table spaces.
Col Logical Reads Rate. Indicates the number of column-organized pages which have been requested from the buffer pool (logical) for regular and large table spaces per second.
Col Physical Reads. Indicates the number of column-organized pages read in from the table space containers (physical) for regular and large table spaces.
Col Physical Reads Rate - Indicates the number of column-organized pages read in from the table space containers (physical) for regular and large table spaces, per second .
Automatic. Indicates whether the buffer pool has self-tuning enabled. 1 indicates self-tuning is enabled for the buffer pool, and 0 otherwise.

Displays graphs of read and write metrics for the buffer pools against a baseline.

For Read Time and Write Time descriptions, see Buffer Pools — Details tab.
Total Logical Reads Rate. The total number of logical reads (index, XDA, and data) per second in the buffer pool.
Total Physical Reads Rate. The total number of physical reads (index, XDA, and data) per second in the buffer pool.
Data Logical Reads Rate. The number of data logical reads per second, which includes accesses to data pages that are already in the buffer pool when the database manager needs to process the page. Also includes data pages that are read into the buffer pool before the database manager can process the page.
Data Physical Reads Rate. The number of data pages read in per second from the tablespace containers (physical) for regular and large tablespaces.
Index Logical Reads Rate. The number of index logical reads per second, which includes accesses to index pages that are already in the buffer pool when the database manager needs to process the page. Also includes index pages that are read into the buffer pool before the database manager can process the page.
Index Physical Reads Rate. The number of index pages read in per second from the tablespace containers (physical) for regular and large tablespaces.

Displays graphs of direct reads and direct writes metrics to the buffer pools. For metric descriptions, see Buffer Pools — Details tab.

Storage Drill-downs

The Storage drill-down provides access to:

Tablespaces

The Tablespaces Pane provides metrics and graphs of the top 10 tablespace activities and summarizes tablespace usage. This pane provides the following views:

On the Database home page toolbar, click Storage and select Tablespaces.

You can also access the Tablespaces pane for a database from the Databases Dashboard. Click the icon at the far right of the database name cell and selecting Tablespaces from the menu that appears.

Displays the 10 tablespaces which have the highest size or the highest percentage of space utilization, according to the user’s selection. The default selection for sorting graphically is space utilization. Selecting the alternate value updates the chart and the table.

Show top by. Use the Show top by options to select metrics which display graphs for size and percentage of tablespace usage. Click the required metric representation to display the respective graph.

The following graphs are provided:

Size: Tablespace size over the last 30 days or during the timeframe selected (which ever is longer).
% Space Usage. Percent of the tablespace in use. Utilization is calculated after taking into account the type of the tablespace (SMS/DMS), its parameters (like auto extend), the free space on the file system and the IBM architecture size limitations.

Axis Definitions:

Percent (chart vertical axis). The percentage of the database tablespace pages currently being utilized.
Megabytes (chart vertical axis). The database tablespace utilized size in megabytes.
Tablespaces (chart horizontal axis). The names of the top 10 most utilized tablespaces.

The Tablespaces Summary view shows the status for all the database tablespaces, including space usage in percent and state of the tablespace.

 

The Tablespace Summary view is located in the lower part of the Tablespaces pane.

Allocated Size used%". The percentage of tablespace pages used out of all usable allocated pages.

 

Total Size Used %. Tablespace utilization % including free space on the file sytstem and DB2 architecture limits

 

Alarms. The number of warning, critical, and fatal alarms for this DB2 database tablespace. The dwell shows the most recent alarms raised against this tablespace, sorted by severity. Click this field to view the Alarms list. This list allows browsing through the alarms, which are sorted according to severity. See the Foglight Online Help, Monitoring System-Wide Alarms for details on the alarm information.

 

Auto Resize. Relates to the DMS tablespaces and storage tables stored automatically. A setting of one indicates enablement of the auto resizing.

 

Auto Storage. Describes whether the tablespace was created as an automatic storage tablespace. A value of 1 (Auto) means yes; 0 means no.

 

Containers. Container count.

 

Content Type. Text identifier defining the size or type of the tablespace: ANY, LARGE, SYSTEMP, or USRTEMP.
ID. Numerical identification of the tablespace.
Name. The name of the tablespace. Clicking the tablespace name drills down further to the Tablespace-specific page.

 

Page Size. Total page size in KBs.

 

Rebalancer Mode. Indicates if the current re-balancing process is removing space from a tablespace or adding space to a tablespace.

 

State. Text identifier of the tablespace state.

 

Total Size. The total amount of allocated space (in megabytes) in this tablespace.

 

Type. Text identifier of DMS or SMS.

 

MAX ARCHITECTURE SIZE TB - Maximum size allowed by DB2 for a tablespace as reported in the DB2 docs. Size is given in TB. -1 indicates limit is not relevant

 

MAX ARCHITECTURE SIZE pages - Maximum size allowed by DB2 for a tablespace as reported in the DB2 docs . Size is given in Mega pages (1 means 1 million pages). -1 indicates limit is not relevant.

 

FS Free Size MB - Total amount of free space left on all file system used by the tablespace. Size is given in MB

Clicking the tablespace name drills down to the Tablespace-specific page.

For more information, see Tablespace-specific Page.

This page provides details on tablespace properties and space utilization, allowing you to analyze any issues affecting the selected member.

From the Tablespaces pane, click the required tablespace in the Top 10 Tablespaces view or the tablespace name in the Tablespace Summary view.

This pane is made up of the following views.

This view provides the following panes:

Alarms. The number of warning, critical, and fatal alarms for this database tablespace. The dwell shows the most recent alarms raised against this tablespace, sorted by severity.

Clicking an alarm displays an alarm management pop-up.

 

Auto Resize. Relates to the DMS tablespaces and storage tables stored automatically. A setting of 1 indicates enablement of the auto resizing.

 

Auto Storage. Reports if the page is automatically stored.

 

Content Type. Text identifier defining the size or type of the tablespace: ANY, LARGE, SYSTEMP, or USRTEMP.

 

Database. Database name.

 

Extent Size. Size of the tablespace extent.

 

Page Size. Total page size in KBs.

 

Prefetch Size. The highest number of pages a pre-fetcher receives from a disk for a given time. If this function is enabled, a value of -1 displays.

 

Rebalancer Mode. Shows the direction of rebalancing and whether this process is adding or removing tablespaces.

 

State. Text identifier of the database state.

 

Tablespace. Tablespace name.

 

Type. Text identifier of DMS or SMS.

Provides a chart of the total utilized space plotted over time.

 

Total. Total size allocated for the tablespace in MB.

 

Used. The amount of MB that are in use for a table space. For an SMS table space it is equal to tablespace total size. Size is given in MB.

Displays a status of the free fragmentation space.

 

MB. Measurement of the graph in megabytes.

 

Total. Total free space.

 

Usable. Usable free space.

 

Used. Space used.

The Tablespace Details view provides the following tabs:

Provides metrics on member utilization, size, and alarms affecting the member.

Alarms. Any alarms that fired and are affecting the tablespace. Clicking an alarm displays the alarms management pop-up.
Member. The database member from which the data was retrieved.
Size. Total size of the tablespace in MBs.
Utilization. Overall utilization in percent. Auto storage tablespace utilization is calculated by the used space compared to the allocated tablespace size, not the total mount point size.

Description

The All Metrics tab provides tablespace properties, space utilization, and fragmentation metrics.

Files Closed. Files that have been closed in the tablespace.
Tablespace Free Pages. Total number of free pages in the tablespace.
Tablespace Free Size MB. Amount of free space.
Tablespace Last Resize Failed. The time the tablespace failed during its latest resize attempt.
Tablespace Last Resize Time. When the tablespace was last resized.
Tablespace Num Container. Number of containers available in the tablespace.
Tablespace Total Pages. Total number of pages in the tablespace.
Tablespace Total Size MB. Total tablespace size.
Tablespace Usable Pages. Total number of usable pages in the tablespace.
Tablespace Usable Size MB. Total amount of space available.
Tablespace Used Pages. Total number of pages used by the tablespace.
Tablespace Used Size MB. Total amount of space used.
Allocated Size used%. The percentage of tablespace pages used out of all usable allocated pages.
Value. Value of the metric reported.
Total Size Used %. Tablespace utilization % including free space on the file sytstem and DB2 architecture limits
MAX ARCHITECTURE SIZE TB - Maximum size allowed by DB2 for a tablespace as reported in the DB2 docs. Size is given in TB.
MAX ARCHITECTURE SIZE pages - Maximum size allowed by DB2 for a tablespace as reported in the DB2 docs . Size is given in Mega pages (1 means 1 million pages).
FS Free Size MB - Total amount of free space left on all file system used by the tablespace. Size is given in MB

Tablespaces Buffer Pool Activities

Provides the metrics required to monitor tablespace buffer pool activities and can be sorted according to the buffer pool hit ratio.

On the Database home page toolbar, click Storage and select Tablespaces Bufferpool Activities.

This pane provides the Tablespaces Bufferpool Activities view.

Displays the top tablespaces buffer pool activities metrics and allows you to choose the tablespace to plot and view charts on the details and performance of the selected tablespace. The tablespaces are sorted according to the buffer pool hit ratio.

Async Read Time. The time (in milliseconds) spent on reading data pages by database manager prefetchers.
Async Write Time. The time (in milliseconds) spent on writing data or index pages by database manager prefetchers.
Bufferpool Hit Ratio. The percentage of read requests that are satisfied by the buffer pool without having to physically read from the disk.
Data Logical Reads. The number of logical read requests for data pages that go through the buffer pool.
Data Physical Reads. The number of physical (disk) read requests for data pages that do not go through the buffer pool.
Data Writes. The number of data writes.
Direct Read Time. The time (in milliseconds) spent on performing direct reads.
Direct Write Time. The time (in milliseconds) spent on performing direct writes.
Index Hit Ratio. The percentage of read requests for index pages that are satisfied without having to read from the disk.
Index Logical Reads. The number of logical read requests for index pages that are satisfied without having to read from disk.
Index Physical Reads. The number of physical (disk) read requests for index pages that need to read data from disk.
Index Writes. The number of index writes.
Name. The tablespace name.
Read Time. The amount of elapsed time (in milliseconds) spent on processing read requests.
Type. The tablespace type (DMS Database-Managed Space) or SMS (System-Managed Space).
Write Time. The amount of elapsed time (in milliseconds) spent on processing write requests.
Total logical reads. Total pages read from the bufferpool. count all page types : data, index, XDA and column-organized .
Total physical reads. Total pages read from the table space containers (physical) to the pool. Count all page types : data, index, XDA and column-organized.
Col logical Reads. Total number of column-organized pages requested from the buffer pool (logical).
Col Physical Reads. Total number of column-organized pages read in from the table space containers (physical).
Col Hit Ratio. Percentage of column-organized pages reads that were carried out from the buffer pool for the selected tablespace, without having to perform physical reads.
GBP Logical Reads. The number of pages read from the Group Buffer Pool (GBP) because the page was either invalid or not present in the Local Buffer Pool (LBP). Only relevant for a puresclae instance.
GBP physical reads. The number of Group Buffer Pool (GBP) dependent pages that were read into the local buffer pool from disk because it was not found in the GBP.
GBP Hit Ratio. The percent of time a requested page was found in the group bufferpool out of all times it was requested. If a page is found in the GBP it saves the database the time to look for it in the Local Buffer Pool. Only relevant for a puresclae instance.
Avg Read Time to Pool. The average time it takes to read a single page from the table space containers (physical) to the buffer pool. value is given in milliseconds.

One or more tablespace entries can be viewed by selecting them in the table. The graphs in the lower pane sho the information for the selected tablespaces.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating