Obtaining sample JCL files
- Db2 subsystem ID (SSID) or group attach name of the system where the Performance Advisor REORG candidate table is installed
- Creator ID and name of the Performance Advisor REORG candidate table
- Db2 load and exit library names
- A PDS to hold the output JCL that BMCTRIG generates
- A PDS to hold the worklists that BMCTRIG generates
- Creator ID for the installed DASD MANAGER tables
- Default options module name installed for DASD MANAGER PLUS
To obtain the sample files
Obtain the sample files from the LLQ SAMP library (where LLQ is DB, XX, BB, and UBB) of the
files. The following listing shows the portion of the library that contains the sample JCL:
VIEW userID.AFDREORG.SAMPLIB Row 00001 of 00005
Command ===> Scroll ===> PAGE
Name Prompt Size Created Changed ID
. INSCACT 110 yyyy/mm/dd yyyy/mm/dd 09:37:17 RDAMAV2
. INSOBJS 123 yyyy/mm/dd yyyy/mm/dd 09:36:37 RDAMAV2
. INSTHRSH 110 yyyy/mm/dd yyyy/mm/dd 09:37:47 RDAMAV2
. TRIGEXCP 162 yyyy/mm/dd yyyy/mm/dd 09:38:54 RDAMAV2
. TRIGFORC 137 yyyy/mm/dd yyyy/mm/dd 09:39:24 RDAMAV2
Command ===> Scroll ===> PAGE
Name Prompt Size Created Changed ID
. INSCACT 110 yyyy/mm/dd yyyy/mm/dd 09:37:17 RDAMAV2
. INSOBJS 123 yyyy/mm/dd yyyy/mm/dd 09:36:37 RDAMAV2
. INSTHRSH 110 yyyy/mm/dd yyyy/mm/dd 09:37:47 RDAMAV2
. TRIGEXCP 162 yyyy/mm/dd yyyy/mm/dd 09:38:54 RDAMAV2
. TRIGFORC 137 yyyy/mm/dd yyyy/mm/dd 09:39:24 RDAMAV2
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*