IFCID 225 - Storage Pool Details

This topic shows detailed information about Record Trace - IFCID 225 - Storage Pool Details.

                                                  STORAGE POOL DETAILS                                                   
                                                                                                                         
31-BIT DBM1 PRIVATE VARIABLE POOLS:                                                                                      
AGENT LOCAL STORAGE                  :              2162688   SYSTEM AGENT STORAGE                 :              2109440
BUFFER MANAGER STORAGE BLOCKS        :               651264                                                              
                                                                                                                         
64-BIT POOLS:                                                                                                            
SHARED AGENT LOCAL (VARIABLE POOL)   :             27615232   SHARED SYSTEM AGENT (VARIABLE POOL)  :             26210304
RID POOL STORAGE (FIXED POOL)        :                    0   COMPRESSION DICT (DBM1 PRIVATE)      :                    0
ARRAY VARIABLE STORAGE               :                    0                                                              

AGENT LOCAL STORAGE

The amount of storage allocated for agent-related local storage. This storage is used for operations such as sort.

Background and Tuning Information

Sorting requires a large amount of virtual storage because there can be multiple copies of the data being sorted at a given time.

Db2 Sort uses two kinds of storage pool for various internal control structures and data records, an agent-related local storage pool and a global sort pool. To take advantage of the 64-bit addressability for larger storage pool, some high level sort control structures are kept in agent-related storage below the 2 GB bar, which contain 64-bit pointers to areas in the global sort pool above the 2 GB bar. The sort pool above 2 GB contains sort tree nodes and data buffers.

Field Name: QW0225AL

SYSTEM AGENT STORAGE

Storage used by system agents.

Field Name: QW0225AS

BUFFER MANAGER STORAGE BLOCKS

Storage used for page set control blocks.

Field Name: QW0225BB

SHARED AGENT LOCAL (VARIABLE POOL)

The amount of storage allocated for agent-related 64-bit local storage (Db2 field: QW0225ALG).

Field Name: QW0225ALG

SHARED SYSTEM AGENT (VARIABLE POOL)

The amount of 64-bit storage used by system agents (Db2 field: QW0225ASG).

Field Name: QW0225ASG

RID POOL STORAGE (FIXED POOL)

Storage for RID list processing such as list prefetch, index ANDing, and ORing.

Field Name: QW0225RP

COMPRESSION DICT (DBM1 PRIVATE)

Storage space allocated for the compression dictionary.

Field Name: QW0225CD

ARRAY VARIABLE STORAGE

The amount of storage in use for array variables.

Field Name: QW0225AR