Displaying buffer pool status

Use the window to display the current status for one or more active or inactive buffer pools. Specify options on this window to format the display of the selected buffer pools.

Authorities and privileges

To customize the status output for a one or more buffer pools:

  1. Open the Display buffer pool or Display All buffer pools 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 Display to display the status using the options that you just specified.

    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 examples for an illustration of this output.

  6. Click Close to close the window.

Related information