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
InfoSphere Optim™ Query Tuner client
.
Choose the appropriate JCL job to use:
If the subsystem is not configured for query tuning with the
InfoSphere Optim Query Tuner client
,
configure the subsystem by running an AOCDDL JCL job
.
If the subsystem is already configured for query tuning with the
InfoSphere Optim Query Tuner client
Version 2.2.1 or Version 2.2.1.1, 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 AOCM or AOCTIJ JCL job
.
Feedback