Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - Getting Started Guide

Rows in the Bufferpools tab

How rows are displayed in the Bufferpools tab depends on whether a database partition or a database is selected for monitoring in the Live connections list.

When a partition is selected, the Bufferpools tab lists all buffer pools defined on that partition. Buffer pool rows are presented on one level.

When a database is selected, the Bufferpools tab lists all buffer pools defined on that database. Buffer pool rows are presented on two levels in a tree view:

  • Aggregate rowThe top level row is an aggregate row. This row shows consolidated information for a buffer pool across all database partitions on which it is defined. It provides an overview of the current state of the buffer pool across these partitions. If a column contains numeric values, the aggregate row shows the sum for all partitions. If a column contains values that cannot be aggregated or do not have meaning on an aggregate basis, the aggregate row is blank.

  • Partition rows—Lower level rows show statistics for the bufferpool as it exists on each partition. If a buffer pool is defined on multiple partitions, a row for each partition descends from the aggregate row. If a buffer pool is defined on one partition or if it resides in a single-partition database, only one row descends from the aggregate row.       

Tip: Initially, aggregate rows are collapsed. Click the + button beside an aggregate row to expand its list of buffer pool rows.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating