Viewing the result of an optimization cycle

Follow the procedure to view the result of an optimization cycle.

About this task

When the object placement wizard finishes, the Buffer Pool Analyzer main window shows the result in the Results subfolder of the Object Placement folder. The subfolder can contain results from several optimization cycles. The result from the most recent optimization is highlighted.

Results are named OPL <bpd_file> <date> <time>, whereby OPL stands for Object Placement, <bpd_file> for the name of the bpd file that was used for the optimization, <date> and <time> for the date and time when the optimization started.

1. If you want to delete results from the folder, select it by clicking it. Then press the Delete key. To delete all results, right-click Results. Then click Delete all. You are asked to confirm the deletion.
   Note: Results remain on the hard disk drive and take up space until they are deleted. They are usually located in folder C:\Documents and Settings \<userid> \db2pev<version> \object placement reports. However, because of their special format, do not manipulate the folder contents manually.
2. To view the result of an object placement, double-click it, or select it and press Enter.
   The result is shown in your web browser and contains the following information:

   • A section showing details about the content of the bpd file that was used for this object placement optimization, such as the name of the Db2® subsystem from which data was collected, and the start and end times and the duration of the data collection. The bpd file is the one you selected when you performed the steps in Selecting and opening a buffer pool data file. The details are identical with the information that was shown in the Pattern File Selection window (see Figure 1).
   • A section showing which pattern file and which object placement rules were used for this object placement optimization. This information corresponds to your specifications in Step 1: Selecting a pattern file and Step 2: Editing a pattern file.
   • A section listing the other options that you specified for this object placement optimization.
   • A list of ALTER BUFFERPOOL commands for resizing and changing buffer pool characteristics.
     Example:

     ALTER BUFFERPOOL(BP0) VPSIZE(868) HPSIZE(0) VPSEQT(20) DWQT(0) VDWQT(0,0)
     ALTER BUFFERPOOL(BP7) VPSIZE(120) HPSIZE(0) VPSEQT(40) DWQT(10) VDWQT(3,0)
     ALTER BUFFERPOOL(BP32K) VPSIZE(15) HPSIZE(0) VPSEQT(100) DWQT(70) VDWQT(50,0)
     ALTER BUFFERPOOL(BP4) VPSIZE(1750) HPSIZE(0) VPSEQT(99) DWQT(0) VDWQT(0,0)
     ALTER BUFFERPOOL(BP1) VPSIZE(5) HPSIZE(0) VPSEQT(100) DWQT(70) VDWQT(50,0)
     ALTER BUFFERPOOL(BP2) VPSIZE(790) HPSIZE(0) VPSEQT(20) DWQT(0) VDWQT(0,0)
     ALTER BUFFERPOOL(BP3) VPSIZE(426) HPSIZE(0) VPSEQT(100) DWQT(70) VDWQT(50,0)
      

   • A list of STOP DATABASE commands. In data sharing environments, these commands must be performed before applying the following statements.
   • A list of ALTER INDEX and ALTER TABLESPACE statements for placing each reassigned object in its new buffer pool.
     Example:

     ALTER INDEX CC390.UTLEX01 BUFFERPOOL BP7;
     ALTER INDEX CC390.UTLSTX01 BUFFERPOOL BP7;
     ALTER INDEX CC390.UTPEBX01 BUFFERPOOL BP7;
     ALTER INDEX CC390.UTPETX01 BUFFERPOOL BP7;
     ALTER INDEX CC390.UTPEX01 BUFFERPOOL BP7;
     ALTER INDEX CC390.UTPRCX01 BUFFERPOOL BP7;
     ALTER TABLESPACE CC390.UTPROC BUFFERPOOL BP7;
     ALTER INDEX CC390.UTRESTART2X BUFFERPOOL BP7;
     ALTER INDEX CC390.UTRESTARTX BUFFERPOOL BP7;
     ALTER TABLESPACE CC390.UTRSTRT BUFFERPOOL BP7;
     ALTER TABLESPACE CC390.UTTEMPL BUFFERPOOL BP7;
      

   • A list of START DATABASE commands, corresponding to the preceding STOP DATABASE commands. Required in data sharing environments.
   • An object placement overview, which summarizes the information from the object placement task. Note that changed object placements are marked by a different color when the information is shown in the browser window. The following example shows the Object Placement window.

     

3. A section listing the original and recommended buffer pool characteristics (not shown here).
4. Use the hypertext links in the browser window to navigate through the report.