Displaying buffer pool status

Use the window to display the current status for one or more active or inactive buffer pools. When the window opens, it displays the basic status of the selected buffer pools. You can get more information about the selected buffer pools by specifying options on the window.

Authorities and privileges

To customize the status output for a buffer pool:

  1. Open the Display buffer pool window.

  2. Under Show detailed report, specify a radio button that defines how much buffer pool information you want displayed: Since last display, Since active, or Not detailed.

  3. Under List associated open spaces, select a radio button to specify whether to show the open table spaces and index spaces associated only with the active buffer pools or with all the buffer pools. You can also select to show no table or index spaces.

  4. Under Include space statistics, select a radio button to specify whether to include table space and index space statistics:

    No
    This is the default. The output will not include table and index space statistics.
    Yes
    Displays statistics that are incremental since the last time they were displayed. If you select Yes, and the List associated open spaces radio button is None, the report will include only active information

  5. Click Refresh to display the status using the options that you just specified.

    6. The output of the report is displayed in the form of DB2 messages. The first line of any output from the command DISPLAY BUFFERPOOL is always message DSNB401I. See the samples for an illustration of this output.

  6. Click Close to close the window.

Related information