The AOCTIJ sample JCL job

You can use an AOCTIJ sample JCL job to migrate the EXPLAIN and Query Tuner tables, packages, and stored procedures that are used on the different version of the DB2® subsystems for the Optim™ Query Tuner client.

The AOCTIJ sample JCL jobs are extracted to the DB2 subsystem when you perform the SMP/E tape installation. You can also find this sample job in the \serverconfig\ZOS\migration subdirectory of the installation directory for the client on the client system.

Four versions of the AOCTIJ sample jobs are available:

Migration path JCL job file
Migrating the subsystem from DB2 for z/OS® Version 8 new-function mode to DB2 Version 10 for z/OS conversion mode from Version 8 for the Optim Query Tuner client Version 2.2.1 AOCTIJC8
Migrating the subsystem from DB2 Version 10 for z/OS conversion mode from Version 8 to DB2 Version 10 for z/OS new-function mode for the Optim Query Tuner client Version 2.2.1 AOCTIJ8X
Migrating the subsystem from DB2 Version 9.1 for z/OS to DB2 Version 10 for z/OS conversion mode from Version 9 for the Optim Query Tuner client Version 2.2.1 AOCTIJC9
Migrating the subsystem from DB2 Version 10 for z/OS conversion mode from Version 9 to DB2 Version 10 for z/OS new-function mode for the Optim Query Tuner client Version 2.2.1 AOCTIJ9X

The following example shows the prologue of the AOCTIJ9X sample job.

//******************
//* AOCTIJ9X
//******************
//*  Descriptive Name =
//*    DB2 Installation Job Stream
//*
//*     Licensed Materials - Property of IBM
//*     5655-V81
//*     COPYRIGHT 2010 IBM Corp.  All Rights Reserved.
//*
//*     STATUS = Version 10
//*
//*  Function = JCL to migrate OQT V2.2.1 FROM DB2 V10 CM9
//*             to DB2 V10
//*
//*  Pseudocode =
//*    AOCEXP    Step     Alter tables, drop indexes and create indexes
//*                       for user explain tables.
//*    AOCWCC    Step     Alter existing WCC tables and define
//*                       additional indexes
//*    AOCWIA    Step     Alter existing WIA tables
//*    AOCSP     Step     Cretae stored procedures:
//*                        SYSPROC.OPT_RUNSQL
//*                        SYSPROC.OPT_EXECUTE_TASK
//*    AOCBIND   Step     Bind QT packages
//*    AOCGRT    Step     Grant access on objects created by this job,
//*                       and grant execute on packages
//*
//*  Dependencies =
//*
//*  Notes =
//*    PRIOR TO RUNNING THIS JOB, customize it for your system:
//*    (1) Add a valid job card
//*    (2) Locate and change all occurrences of the following strings
//*        as indicated:
//*        (A) '!DSN!'      to the subsystem name of your DB2
//*        (B) 'DSNTIA!!'   to the plan name for DSNTIAD on your DB2
//*        (C) 'DSN!!0'     to the prefix of the target library for DB2
//*        (D) '!AOCPREFX!' to the prefix of target library for QT
//*                          DBRMs
//*        (E) 'USER!!'     user id for individual explain tables
//*        (F) '!GRANTEE!   to one or more authorization IDs that
//*                          need to use stored procedures
//*                           SYSPROC.OPT_RUNSQL and
//*                           SYSPROC.OPT_EXECUTE_TASK

Feedback