Explaining a package in batch
Use the following procedure to perform a batch Explain on a package.
To perform a batch Explain
- Generate a list of packages to Explain.
- Specify options for the Explain.
In the space beside an object or statement, type XB, and press Enter.
The Batch Explain Type panel is displayed.
Batch Explain Type panel
PSSPA116 Batch Explain Type
Explain Type . . . 1 1. XD=Explain Dynamic
2. XS=Explain Static from bind with EXPLAIN(YES)
3. XC=Explain Compare Dynamic and Static Explains
4. XP=Explain Package- Specify the batch Explain Type as follows:
- XD performs a dynamic Explain.
- XS performs a static Explain.
- XC compares a dynamic Explain and a static Explain.
Press Enter.
The Batch Job panel is displayed.
Specify options for the batch Explain.
You can also change the layout data set using the Data Set Options panel (see the panel in Step 7).
- (optional) Customize the display of your batch Explain:
In the Set JCL Options field, type Y, and press Enter.
The JCL Options panel is displayed.
JCL Options panel
PSSPOJ00 ------------------------- JCL Options --------------------------------
Command ===>
Specify one of the options and press ENTER to continue.
Options 1. SMS Classes
2. Data Sets
3. Job CardsIn the Options field, select Data Sets, and press Enter.
The Data Set Options panel is displayed.
Data Set Options panel
PSSPODS1 ----------------------- Data Set Options -----------------------------
Command ===>
Specify options and press ENTER to continue.
Use #### in member name to have counter variable generated into member name.
Counter . . . . . . . . 24 (Replaces #### in member name, then incremented)
Note: The JCL, SYSPRINT, and Summary data sets can be partitioned or
sequential. The Layout data set must be partitioned with a member
name specified.
JCL Data Set . . . . . 'RDAGXR2.SQLXPLR.CNTL(SQLX####)'
SYSPRINT Data Set . . . 'RDAGXR2.SQLXPLR.SYSPRINT(SQLX####)'
SYSPRINT SYSOUT . . . . Y (Y/N) SYSOUT Class . . . *
Summary Data Set . . . 'RDAGXR2.SQLXPLR.SUMMARY(SQLX####)'
Summary SYSOUT . . . . Y (Y/N) SYSOUT Class . . . *
Layout Data Set . . . . 'RDAGXR.PSSC1.SAMP(PSSREPA)'Verify that the options on the panel are correct, and press Enter.
The Job Card Options panel is displayed .
Specify job card options as needed, and press Enter.
The JCL Options panel is displayed.
- Press F3 to display the generated job.
- Review and submit the batch Explain job.