Setting up the Performance Advisor database

The PADB Starter simplifies the task of setting up and maintaining a Performance Advisor Database. You must have product administrative authority to access the PADB Starter.

To run the PADB Starter

  1. Execute the DOMCLIST (distributed with the System and SQL Performance for DB2 product DOMCLIST) to access the main menu for the products and solutions for which you are licensed.

  2. Specify a new or existing library for the PADB starter data set:

    1. On the main menu, select the option for Administration, and press Enter.
    2. On the Administration panel (DOMEADM1/I), select Z (PADB Starter JCL) and press Enter. (The option number depends on which solutions are licensed.)

    3. On the PADB Starter panel (DOMEPAD1/I), enter the data set name of a new or an existing PADB starter library. Enter other values as appropriate into the relevant fields and press Enter.

      Note

      To create a new library, you must specify an Allocation type parameter.

    The PADB Starter - Properties panel is displayed.

     

                                            DOMEPAD2/I                 PADB Starter - Properties                  06:13:32
    Command ====> ________________________________________________________________                                                                          
                                                                                 
    PADB Properties                                                               
     Creator . . : yyyADBCR                                                       
     DB2 SSID  . : DIYE                                                           
     DSNLOAD . . : CSGI.DB2V10M.DSNLOAD________________________                   
     DSNEXIT . . : SYS3.DIYE.DSNEXIT___________________________                   
                                                                                 
    Generate JCL to create database  : y                                          
    Generate JCL to maintain database: y                                          
                                                                                 
    JOB Statement Information:                                                    
    //RDGKQZ01 JOB (5920,SQLP),'KZACK',                                           
    // MSGCLASS=X,CLASS=Q,MSGLEVEL=(1,1),                                         
    // NOTIFY=&SYSUID                                                             
    //*
  3. To create or maintain a PADB, perform the following steps:
    1. On the PADB Starter - Properties (DOMEPAD2/I), enter the values Y or N in the fields for generating JCL to create or maintain (or both) a Performance Advisor database, and press Enter.
      Only the panels for the options that you select are displayed.
    2. On the PADB Starter - Creation panel (DOMEPAD3/I) (displayed if you selected Generate JCL to create database) edit the relevant fields and press Enter.
  4. On the PADB Starter - Maintenance panel (DOMEPAD4/I), perform these actions:
    1. Select the desired Advisors.The Advisors that you select determine the status of the tables that the PADB Starter - Tables panel displays.
    2. Edit the DMDBMERG Customization fields to create the appropriate generation data group (GDG) data sets and press Enter.
  5. (optional) On the the PADB Starter - Tables panel (DOMEPAD5/I), adjust the tables and columns to be populated:When you open the PADB Starter - Tables panel (DOMEPAD5/I), the values in the tables and columns (populated continuously) are based on the advisors that you selected.
    1. On the PADB Starter - Tables panel (DOMEPAD5/I), select a table with content that you want to include in the PADB.

    2. On the PADB Starter - Table Columns panel (DOMEPAD6/I), specify the columns to include in the PADB table.

      Note

      • Columns with a status of "Key" are always populated
      • Columns with a blank status are included only as needed for advisors.
      • To unconditionally include a column not required by any advisor, use the include action to select the column.
      • To undo the include action, use the exclude action.
      • To select all columns, on the command line type ALL.
      • To reset all columns previously included, on the command line type NONE.
    3. Press F3 until you exit the PADB Starter.

The PADB Starter JCL output is sent to an edit session where you can review or submit it.

Where to go from here

Review the $$README file (in the PADB starter library that you just generated) for details about the following items:

  • Tables that the various advisors require
  • Library members that were established in order to:
    • Create a new database
    • Migrate from an existing database established on a prior release of SQL Performance
    • Populate the desired columns of each table

If you are going to create new PADB tables, execute the customized PASETUP member to create the tables that you want the PADB to manage.

If you migrated data from an earlier release of SQL Performance execute the appropriate PAMIGRxx sample to adapt the PADB to the current SQL Performance release. For xx use one of the following values:

  • Apptune 11.2—B2
  • Apptune 11.1—B1

Related topic

Setting-up-Performance-Advisor

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*