Setting up the Performance Advisor database

​​ ​​​​​ To run the PADB Starter

1. Run 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. (BMC.DB2.SPE2507)Perform one of these steps:
      • If Administration authority is Yes on the User Profile Session Control panel, select Administration from the main menu and press Enter.
      • If Administration authority is No, and the No Admin, PADB Starter on main menu? option is Yes, on the User Profile Session Control panel, select PADB Starter JCL from the main menu and press Enter. In this case, skip step b and proceed to step c.
   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 in the relevant fields and press Enter.

3. To create or maintain a PADB, perform the following steps:
   1. On the PADB Starter - Properties panel (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 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 populated. 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.

      Warning

      Important

      • 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, enter ALL.
      • To reset all columns previously included, on the command line, enter 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 for the following purposes:
  • Create a new database
  • Migrate from an existing database established in an earlier release of SQL Performance
  • Populate table columns

Tocreate new PADB tables, run 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, run the appropriate PAMIGRxx sample to adapt the PADB to the current SQL Performance release. Replace xx with one of the following values:

• 12.1—C1
• 11.2—B2