Alter Group Buffer Pool Command Issued

This topic shows detailed information about System Parameters - Alter Group Buffer Pool Command Issued.

System Parameters - Alter Group Buffer Pool Command Issued

The field labels shown in the following sample layout of System Parameters - Alter Group Buffer Pool Command Issued are described in the following section.


ALTER GROUP BUFFER POOL COMMAND ISSUED                                                        OLD          NEW
--------------------------------------------------------------------------------------------------------------
TIMESTAMP             02/15/13 13:52:59.07          CURRENT DIRECTORY TO DATA RATIO             5            1
MEMBER                                SE11          CLASS CASTOUT THRESHOLD (%)                10           10
GBP ID                                GBP0          CLASS CASTOUT THRESHOLD (PAGES)             0            0
                                                    GBP CASTOUT THRESHOLD (%)                  50           50
                                                    GBP CHECKPOINT INTERVAL (MIN)               5            5
                                                    GBP CACHE SETTING                         YES          YES
                                                    AUTO REC                                  YES          YES

GBP ID

The Db2 group buffer pool ID.

Field Name: QW0256GB

CURRENT 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

AUTO REC

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