执行 SMP/E 磁带安装时,会将 AOCJOC 样本 JCL 作业抽取到 DB2® 子系统。您也可以在客户机系统上客户机的安装目录的 \serverconfig\ZOS\migration 子目录中找到此样本作业。
有两个版本的 AOCJOC 样本作业可用:
迁移路径 | JCL 作业文件 |
---|---|
在 DB2 z/OS® 版 V8 新功能方式子系统上,将 Optim Query Tuner Client从 V2.2.0.2 迁移到 V2.2.1 | AOCJOC8N |
在 DB2 z/OS 版 V9.1 子系统上,将 Optim Query Tuner Client从 V2.2.0.2 迁移到 V2.2.1 | AOCJOC9 |
以下示例显示了 AOCJOC9 样本作业的开头部分。
//****************** //* 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