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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
