Creating an Explain report

Use your ISPF editor to create a JCL job that creates an Explain report.

The following JCL is an example. Remember to change the setup information (starting with // in your JCL) as appropriate for your installation.

Figure 1. Explain JCL

EDIT ---- ANDREW.OMPE.JOBS.EXPL1    ------------------------- Columns 001 072 
Command ===> ________________________________________________Scroll ===> CSR_ 
***************************** TOP OF DATA ******************************
0001  /*  JCL to produce an explain report  */ 
0002  // AWOMPEA JOB  (TTS1,YUS7),'ANDREW',
0003  // MSGCLASS=V,CLASS=D,NOTIFY=ANDREW 
0004  // EXEC PGM=FPECMAIN 
0005  // STEPLIB  DD  DSN=OMPE.RKANMOD,DISP=SHR 
0006  // SYSOUT   DD  SYSOUT=*
0007  // EXPLAIN  DD  SYSOUT=*
0008  // DPMOUTDD DD  DSN=ANDREW.OMPE.OUT.EXPL1,DISP=OVR 
0009  // JOBSUMDD DD  SYSOUT=A  
0010  //SYSIN DD * 
0011   EXPLAIN                                   
0012 PACKAGE (KO2EX520.DGO@TPG3.(-2))
0013       SSID(SDA2)
0014       LEVEL(DETAIL)
0015       HOSTVAR(YES) 
0016  EXEC 
****************************BOTTOM OF DATA ****************************  
F1=Help     F2=Split    F3=Exit     F5=Rfind  
 F6=Rchange  F7=Up  F8=Down     F9=Swap    F10=Left    F11=Right   F12=Cancel

This example produces an Explain detail report for the second generation of a package (DGO@TPG3) on Db2 subsystem SDA2.