IFCID 002 - Simulated Buffer Pool Activity

This topic shows detailed information about Record Trace - IFCID 002 - Simulated Buffer Pool Activity.

This block is provided for each simulated buffer pool.

Record trace - IFCID 002 - Simulated Buffer Pool Activity

The field labels shown in the following sample layout of Record Trace - IFCID 002 - Simulated Buffer Pool Activity are described in the following section.


                           SIMULATED BUFFER POOL ACTIVITY
BUFFER POOL ID                       :          8             FLAGS                                : X'80'
CURRENT PAGES IN USE                 :              2077149   AVOIDABLE READ I/O:
MAX PAGES IN USE                     :              2077152     SYNC  READ I/O (R)                 :             25866384
CURRENT SEQ PAGES IN USE             :               109436     SYNC  READ I/O (S)                 :               322891
MAX SEQ PAGES IN USE                 :               113140     ASYNC READ I/O                     :              3661730
PAGES MOVED INTO SIMULATED BP        :             34732432     SYNC  GBP READS (R)                :                    0
TOTAL AVOIDABLE SYNC I/O DELAY       :       2:37:06.172028     SYNC  GBP READS (S)                :                    0
                                                                ASYNC GBP READS                    :                    0

BUFFER POOL ID

The buffer pool ID.

Field Name: QBSPBPID

CURRENT PAGES IN USE

The number of simulated buffers currently in use in the simulated buffer pool.

Field Name: QBSPIUS

MAX PAGES IN USE

The highest number of simulated buffers that were in use in the simulated buffer pool.

Field Name: QBSPHUS

CURRENT SEQ PAGES IN USE

The number of simulated buffers currently in use for sequential pages in the simulated buffer pool.

Field Name: QBSPSUS

MAX SEQ PAGES IN USE

The highest number of simulated buffers that were in use for sequential pages in the simulated buffer pool.

Field Name: QBSPHSU

PAGES MOVED INTO SIMULATED BP

The number of pages logically moved into the simulated buffer pool from the virtual buffer pool.

Field Name: QBSPMVI

TOTAL AVOIDABLE SYNC I/O DELAY

The total time waiting for synchronous read I/O from disk for pages found in the simulated buffer pool.

Field Name: QBSPDTM

FLAGS

The flag byte shows if more QBSP data is following or if this is the last of the QBSP repeating groups.

Field Name: QBSPFLG

AVOIDABLE READ I/O - SYNC READ I/O (R)

The number of pages found in the simulated buffer pool for a random request that could have avoided a synchronous read I/O from disk.

Field Name: QBSPDRR

AVOIDABLE READ I/O - SYNC READ I/O (S)

The number of pages found in the simulated buffer pool for a sequential request that could have avoided a synchronous read I/O from disk.

Field Name: QBSPDRS

AVOIDABLE READ I/O - ASYNC READ I/O

The number of pages found in the simulated buffer pool for a prefetch request that could have avoided an asynchronous read I/O from disk.

Field Name: QBSPDRA

AVOIDABLE READ I/O - SYNC GBP READS (R)

The number of pages found in the simulated buffer pool for a random request that could have avoided a synchronous read from GBP.

Field Name: QBSPGRR

AVOIDABLE READ I/O - SYNC GBP READS (S)

The number of pages found in the simulated buffer pool for a sequential request that could have avoided a synchronous read from GBP.

Field Name: QBSPGRS

AVOIDABLE READ I/O - ASYNC GBP READS

The number of pages found in the simulated buffer pool for a prefetch request that could have avoided an asynchronous read from GBP.

Field Name: QBSPGRA