The AOCJOC 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.
Two versions of the AOCJOC sample jobs are available:
Migration path | JCL job file |
---|---|
Migrating the Optim Query Tuner client from Version 2.2.0.2 to Version 2.2.1 on a DB2 for z/OS® Version 8 new-function mode subsystem | AOCJOC8N |
Migrating the Optim Query Tuner client from Version 2.2.0.2 to Version 2.2.1 on a DB2 Version 9.1 for z/OS subsystem | AOCJOC9 |
The following example shows the prologue of the AOCJOC9 sample job.
//****************** //* AOCTIJC9 //****************** //* Descriptive Name = //* DB2 Installation Job Stream //* //* Licensed Materials - Property of IBM //* 5655-V81 //* COPYRIGHT 2010 IBM Corp. All Rights Reserved. //* //* STATUS = Version 9 //* //* Function = JCL to migrate OQT V2.2.1 DB2 from //* V9 TO DB2 V10 CM9 //* //* 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) 'BP8K!' to the default 8K bufferpool //* (F) 'USER!!' user id for individual explain tables //* (G) '!GRANTEE! to one or more authorization IDs that //* need to use stored procedures //* SYSPROC.OPT_RUNSQL and //* SYSPROC.OPT_EXECUTE_TASK