AOCJOC 样本 JCL 作业

您可以使用 AOCJOC 样本 JCL 作业来迁移当前版本客户机的 Optim™ Query Tuner Client V2.2.0.2 使用的 EXPLAIN 和 Query Tuner 表、软件包以及存储过程。

执行 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

反馈