Configuring a
DB2 for z/OS
subsystem for query tuning on the server
You can run a JCL job on a
DB2® for z/OS® subsystem
to configure it for the current version of the
Optim™ Query Tuner client
.
Choose the appropriate JCL job to use:
If the subsystem is not configured for any previous version of the
Optim Query Tuner client
,
configure the subsystem by running an AOCDDL JCL job
.
If the subsystem is already configured for the
Optim Query Tuner client
Version 2.2.0.2, or you migrated your
DB2 for z/OS
subsystem to another version,
migrate the existing EXPLAIN and Query Tuner tables, packages, and stored procedures by running an AOCJOC or AOCTIJ JCL job
.
Feedback