Pool Detail
This panel displays data for Db2 10 and higher.
________________ ZJ225E VTM O2 V550.#P SE12 11/05/13 16:24:49 2
> Help PF1 Back PF3 Up PF7 Down PF8
> R.M.E
>
> A-Address Space Summary B-Thread Information C-Shared and Common Storage
> D-Stmt Cache and xProc *-Pool Detail F-IRLM Storage
===============================================================================
> Pool Detail
J22E
+ Total Agent Local Storage 458752
+ Total System Agent Storage 356352
+ Total Buffer Manager Storage Blocks 528384
+
+ Total Agent Local Storage(64-Bit) 12124160
+ Total System Agent Storage(64-Bit) 7581696
+ Total RID Pool Storage(64-Bit) 0
+ Total Compression Dictionary Storage(64-Bit) 16384
+ Total Array Variable Storage 0
===============================================================================Navigation
You can scroll through the information using F7 and F8 (if the information requires more than one panel).
For
additional options
- select one of the options from the panel. The same snapshot of Db2 performance data is used as long as Enter is not pressed.
- use the PF keys.
Fields
- Total Agent Local Storage
- Shows the total agent local storage (31-bit DBM1 private variable pools) (QW0225AL).
- Total System Agent Storage
- Shows the total system agent storage (31-bit DBM1 private variable pools) (QW0225AS).
- Total Buffer Manager Storage Blocks
- Shows the total buffer manager storage blocks (31-bit DBM1 private variable pools) (QW0225BB).
- Total Agent Local Storage (64-Bit)
- Shows the total size of the agent-related 64-bit local storage (64-bit shared variable pools) (QW0225ALG).
- Total System Agent Storage (64-Bit)
- Shows the total size of the 64-bit storage used by system agents (64-bit shared variable pools) (QW0225ASG).
- Total RID Pool Storage (64-Bit)
- Shows the total size of the RID pool storage (64-bit shared fixed pool) (QW0225RP).
- Total Compression Dictionary Storage (64-Bit)
- Shows the total compression dictionary storage (64-bit DBM1 private getmained) (QW0225CD).
- Total Array Variable Storage
- Shows the total array variable storage.