Running DEDB Tuning Aid

The DEDB Tuning Aid is used in relationship to the DEDB Pointer Checker, and therefore you must follow some steps to specify the control statement and JCL requirements.

Procedure

To run the DEDB Tuning Aid, you must complete the following tasks:

  1. Select the DEDB areas to be tuned.
  2. Run the DEDB Pointer Checker or the Online Pointer Checker for those areas to create input data that is required by the DEDB Tuning Aid.
  3. Code the JCL for the DEDB Tuning Aid (FABBME1, FABBME3, and FABBME5) and DFSORT job steps to be run.
  4. Select the database specifications to be changed and evaluated.
  5. If you are changing parameters other than the randomizing routine, create a new DMB (that is, do a DBDGEN and ACBGEN).
  6. Code the control statements needed for the FABBME1 and FABADA5 programs. The DEDB Tuning Aid creates all required DFSORT control statements.
  7. Run the job.
  8. Evaluate the output reports.
  9. Repeat steps 4 through 8, as necessary, until you have enough information to decide how to tune your database.