Monitoring buffer pools

You can display the current status for one or more active or inactive buffer pools. You can also request a summary or detail report.

About this task

Buffer pools are areas of virtual storage that temporarily store pages of table spaces or indexes.
Introductory concepts

Procedure

Begin general-use programming interface information.
To monitor buffer pools:

Issue the DISPLAY BUFFERPOOL command.

Example

For example:

-DISPLAY BUFFERPOOL(BP0)

This command might produce a summary report such as the following:

!DIS BUFFERPOOL(BP0)
DSNB401I ! BUFFERPOOL NAME BP0, BUFFERPOOL ID 0, USE COUNT 27
DSNB402I ! BUFFER POOL SIZE = 2000 BUFFERS
             ALLOCATED          =     2000   TO BE DELETED   =        0
             IN-USE/UPDATED     =        0
DSNB406I !   PGFIX ATTRIBUTE -
             CURRENT                   = NO
             PENDING                   = YES
             PAGE STEALING METHOD      = LRU
DSNB404I ! THRESHOLDS -
            VP SEQUENTIAL       = 80   
            DEFERRED WRITE      = 85   VERTICAL DEFERRED WRT  = 10,15
            PARALLEL SEQUENTIAL = 50   ASSISTING PARALLEL SEQT=  0
DSN9022I ! DSNB1CMD '-DISPLAY BUFFERPOOL' NORMAL COMPLETION

End general-use programming interface information.