IFCID 256 - Alter Group Buffer Pool

This topic shows detailed information about Record Trace - IFCID 256 - Alter Group Buffer Pool.

This record shows the old and the new status of the altered group buffer pool.

Record trace - IFCID 256 - Alter Group Buffer Pool

The field labels shown in the following sample layout of Record Trace - IFCID 256 - Alter Group Buffer Pool are described in the following section.


BUFFER POOL   GROUP BUFFER POOL ID: GBP0                      
                                                  OLD      NEW
              DIRECTORY TO DATA RATIO        :      5        1
              CLASS CASTOUT THRESHOLD (%)    :     10       10
              CLASS CASTOUT THRESHOLD (PAGES):      0        0  
              GBP CASTOUT THRESHOLD (%)      :     50       50
              GBP CHECKPOINT INTERVAL (MIN)  :      5        5
              GBP CACHE SETTING              :    YES      YES
              AUTOREC                        :    YES      YES

GROUP BUFFER POOL ID

The DB2 group buffer pool ID.

Field Name: QW0256GB

DIRECTORY TO DATA RATIO

The directory entry to data entry ratio. This is the value specified in the RATIO keyword of the ALTER GROUPBUFFERPOOL command.

New status deduced from the DB2 field QW0256NR.

Old status deduced from the DB2 field QW0256OR.

Field Name: RT0256DR

CLASS CASTOUT THRESHOLD (%)

The threshold at which the class castout is to be initiated. It is expressed as a percentage of the group buffer pool size. This is the value specified in the CLASST keyword of the ALTER GROUPBUFFERPOOL command.

New status deduced from the DB2 field QW0256NC.

Old status deduced from the DB2 field QW0256OC.

Field Name: RT0256CT

CLASS CASTOUT THRESHOLD (PAGES) (OLD)

The old class castout threshold based on the number of pages.

Field Name: QW0256ON

CLASS CASTOUT THRESHOLD (PAGES) (NEW)

The new class castout threshold based on the number of pages.

Field Name: QW0256NN

GBP CASTOUT THRESHOLD (%)

The threshold at which the castout is to be initiated for the group buffer pool. This is the value specified in the GBPOOLT keyword of the ALTER GROUPBUFFERPOOL command.

New status deduced from the DB2 field QW0256NG.

Old status deduced from the DB2 field QW0256OG.

Field Name: RT0256GT

GBP CHECKPOINT INTERVAL (MIN)

The time interval (in minutes) between successive group buffer pool checkpoints. This is the value specified in the GBPCHKPT keyword of the ALTER GROUPBUFFERPOOL command.

New status deduced from the DB2 field QW0256NK.

Old status deduced from the DB2 field QW0256OK.

Field Name: RT0256CI

GBP CACHE SETTING

GBPCACHE value before and after the ALTER GROUPBUFFERPOOL command was issued. This field specifies whether DB2 should write changed pages for the group buffer pool dependant pageset or partitions directly to DASD and use the group buffer pool only for sending XI signals.

New status deduced from the DB2 field QW0256NB.

Old status deduced from the DB2 field QW0256OB.

Field Name: RT0256CS

AUTOREC

A flag indicating how the AUTOREC option of the ALTER GROUPBUFFERPOOL command has been set. It specifies whether DB2 should automatically recover if GBP fails. The old value specifies the AUTOREC value before the ALTER GBP command was issued. The new value specifies the AUTOREC value after the ALTER GBP command was issued.

New status deduced from the DB2 field QW0256NA.

Old status deduced from the DB2 field QW0256OA.

Field Name: RT0256AR