Selecting and opening a buffer pool data file

About this task

To select and open a buffer pool data file, complete the following steps:

Procedure

  1. Select a folder from the Look in list where the bpd file is located.

    The File of type field shows the file name extension of buffer pool data files (*.bpd). If your bpd file lacks the recommended file name extension bpd, select All files (*.*) from the File of type list to see the appropriate files.

  2. Click the bpd file to be opened.

    The File name field shows the name of the selected bpd file.

  3. Click Open.

    The selected bpd file is opened and its content is checked. If the bpd file contains a concatenation of multiple sections, with performance data from different data sharing groups, different members of a data sharing group, or separated data collection time frames, only data from one section can be used for the object placement optimization. You need to select one of the sections found in the bpd file.

    Multiple sections in a bpd file are the result of multiple input data sets with trace data being used as input to create bpd files. For more information, see the INPUTDD statement in Creating activity reports and bpd files and Concatenating trace data for activity reports and bpd files.

    • If the Buffer Pool Data File Section Selection dialog is displayed, select one section from the list and click OK to continue. You can click Cancel to return to the Open dialog. Note that you can expand the list by clicking the down arrow on the right side.
    The DB2® Buffer Pool Analyzer - Object Placement window is displayed. You see the first page of the object placement wizard, which guides you through the following steps:
    1. Step 1: Selecting a pattern file
    2. Step 2: Editing a pattern file
    3. Step 3: Assigning objects to buffer pools
    4. Step 4: Setting the initial buffer pool sizes and characteristics

    When you have finished these steps, the object placement wizard closes, and you can continue with Viewing the result of an optimization cycle.

    You can navigate through the pages by clicking Next or Back. On all four pages, you can click Cancel to return to the main window, or Help to get help on the current page.