遵循配置 DB2 for z/OS 以搭配使用 InfoSphere Optim Query Workload Tuner 的核對清單中的步驟 1 至步驟 9。
如果您的子系統是針對 InfoSphere Optim Query Workload Tuner 3.1 版或 3.1.1 版所配置,則不需要遵循此程序中的步驟。
若要建立 EXPLAIN 表格、建立 Query Tuner 表格以及啟動產品授權,請執行下列動作:
JCL 檔案會以 ASCII 格式上傳,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 ID DB2OE 及 DB2OSCA。