遵循用于配置 DB2 for z/OS 以用于 InfoSphere Optim Query Workload Tuner 的核对表中的步骤 1 到 9。
如果您的子系统已配置用于 InfoSphere Optim Query Workload Tuner V3.1 或 V3.1.1,那么您无需执行此过程中的步骤。
要创建 EXPLAIN 表,创建 Query Tuner 表并激活产品许可证,请执行以下操作:
以 ASCII 格式上载 JCL 文件并以二进制格式上载 DBRM。
| 子文件夹名称 | V9 | V10CM9 | V10 | V11 NFM | V11 CM |
|---|---|---|---|---|---|
| 文件列表 | JCL: AOCDDL9 DBRM: AOC5OADM AOC5OAPC AOC5OEPK AOC5OEXK AOC5OFMJ AOC5OIA1 AOC5OIA2 AOC5OIA3 AOC5OIA4 AOC5OIA5 AOC5OIA6 AOC5OIA7 AOC5OIA8 AOC5OIA9 AOC5OIAA AOC5OIAK AOC5OIAL AOC5ONPT AOC5OPKG AOC5OQA AOC5OQIA AOC5OSA AOC5OWCK AOC5OWQA AOC5OWSA AOC5OWSK |
JCL: AOCDDLX9 DBRM: AOC5OADM AOC5OAPC AOC5OEPK AOC5OEXK AOC5OFMM AOC5OIA1 AOC5OIA2 AOC5OIA3 AOC5OIA4 AOC5OIA5 AOC5OIA6 AOC5OIA7 AOC5OIA8 AOC5OIA9 AOC5OIAA AOC5OIAK AOC5OIAL AOC5ONPT AOC5OPKG AOC5OQA AOC5OQIA AOC5OSA AOC5OWCK AOC5OWQA AOC5OWSA AOC5OWSK |
JCL: AOCDDL10 DBRM: AOC5OADM AOC5OAPC AOC5OEPK AOC5OEXM AOC5OFMM AOC5OIA1 AOC5OIA2 AOC5OIA3 AOC5OIA4 AOC5OIA5 AOC5OIA6 AOC5OIA7 AOC5OIA8 AOC5OIA9 AOC5OIAA AOC5OIAK AOC5OIAL AOC5ONPT AOC5OPKG AOC5OQA AOC5OQIA AOC5OSA AOC5OWCM AOC5OWQA AOC5OWSA AOC5OWSM |
JCL: AOCDDL11 DBRM: AOC5OADM AOC5OAPC AOC5OEPL AOC5OEXM AOC5OFMM AOC5OIA1 AOC5OIA2 AOC5OIA3 AOC5OIA4 AOC5OIA5 AOC5OIA7 AOC5OIA8 AOC5OIAA AOC5OIAK AOC5OIAL AOC5ONPT AOC5OPKG AOC5OQA AOC5OQIA AOC5OSA AOC5OSCM AOC5OWCC AOC5OWCM AOC5OWSA AOC5OWSM |
JCL: AOCDDLBC DBRM: AOC5OADM AOC5OEPL AOC5OEXM AOC5OFMM AOC5OIA1 AOC5OIA2 AOC5OIA3 AOC5OIA4 AOC5OIA5 AOC5OIA7 AOC5OIA8 AOC5OIAA AOC5OIAK AOC5OIAL AOC5ONPT AOC5OPKG AOC5OQA AOC5OQIA AOC5OSA AOC5OWCC AOC5OWCN AOC5OWSA AOC5OWSM AOC5OWTA |
另外,如果取消注释此作业步骤,那么 Data Studio 中的单个用户必须先取消选择 Data Studio 客户机中的选项,然后再尝试调整在子系统上运行的 SQL。启动 Data Studio 客户机后,每个用户必须选择窗口 > 首选项。然后,展开数据管理并选择 Query Tuner。 要取消选择的首选项的标签为允许内部流程使用 RACF 标识 DB2OE 和 DB2OSCA。