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:
- Select the DEDB areas to be tuned.
- 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.
- Code the JCL for the DEDB Tuning Aid (FABBME1,
FABBME3, and FABBME5) and DFSORT job steps
to be run.
- Select the database specifications to be changed and evaluated.
- If you are changing parameters other than the randomizing
routine, create a new DMB (that is, do a DBDGEN and ACBGEN).
- Code the control statements needed for the FABBME1 and
FABADA5 programs. The DEDB Tuning Aid creates all
required DFSORT control statements.
- Run the job.
- Evaluate the output reports.
- Repeat steps 4 through 8, as necessary, until you have
enough information to decide how to tune your database.