Generating JCL for batch processing
You can use the BATCH command to generate JCL to be used in batch processing.
- From any processing panel of the Basic Processing Options (these panels include
ANLPPKGE, ANLPDBRM, ANLPFILE, ANLPQNO, ANLPQMF, ANLPTCMP, ANLPTTST and ANLPSDQ),
enter the
BATCHcommand. The Batch Output Data Set panel is displayed. For ANLPTTST and ANLPTCMP panels, the Access Path changes return option will not be displayed.Note: For ANLPTTST and ANLPTCMP panels, theAccess Path changes returnoption will not be displayed.SQLPA520 ------------- Batch Output Data Set ------------- Enter the batch output data set name DSNAME: 'RSQA.SQLPA.ANL520.BATCH(ANLBATCH)' Option: Display output . . . . . . . . . . Y (Y/N) Access Path changes return RC=05. Y (Y/N) - Enter the data set name to which you want to save the JCL.
- To view the correct JCL created by the BATCH command without exiting SQLPA, set the display option to Y and press Enter.
- For the ANLPTCMP and ANLPTTST panels, an additional option named Access Path
changes return RC=05 is available. Enter Y to identify access path changes in
the compared data by checking the return code from the job execution an
additional option named Access Path changes return RC=05 is available.
EDIT ---- TS6224.SQLT26 ---------------------------------------------- Columns 001 080 Command ===> Scroll ===> PAGE ****** ********************************* Top of Data ********************************** 000001 //ANLBATCH JOB , 000002 // USER=TS6224,NOTIFY=TS6224,MSGCLASS=H, 000003 // MSGLEVEL=(1,1),REGION=0M,TIME=10 000004 /*JOBPARM S=* 000005 //* 000006 //* 000007 //*#################################################################### 000008 //*------------------------------------------------------------------- 000009 //* >>> SQL PERFORMANCE ANALYZER - SQL PA <> COPYRIGHT NOTICE <<< 000010 //*------------------------------------------------------------------- 000011 //* 000012 //* LICENSED MATERIALS - PROPERTY OF IBM CORPORATION - 5697-W51 000013 //* 000014 //* (C) COPYRIGHT IBM CORPORATION 2000, 2016 ALL RIGHTS RESERVED 000015 //* (C) COPYRIGHT INNOVATIVE MANAGEMENT SOLUTIONS, INC. 1993, 2006 000016 //* ALL RIGHTS RESERVED 000017 //* 000018 //* US GOVERNMENT USERS RESTRICTED RIGHTS - USE, DUPLICATION OR 000019 //* DISCLOSURE RESTRICTED BY GSA ADP SCHEDULE CONTRACT WITH IBM CORP. 000020 //* 000021 //* COPYRIGHT ROCKET SOFTWARE, INC. 2023 ALL RIGHTS RESERVED 000022 //* 000023 //*------------------------------------------------------------------- 000024 //* PI62220 PI64927 PI88329 PH52477 000025 //*------------------------------------------------------------------- 000026 //*#################################################################### 000027 //ANLSTEP1 EXEC PGM=ANLEEE,REGION=0M, 000028 // PARM='/ACT=EEEPLAN2' 000029 //STEPLIB DD DISP=SHR, 000030 // DSN=TS6224.ANL520.SANLLOAD 000031 // DD DISP=SHR, 000032 // DSN=DC1Q.SDSNEXIT 000033 // DD DISP=SHR, 000034 // DSN=DSN.VC10.SDSNLOAD 000035 // DD DISP=SHR, 000036 // DSN=CEE.SCEERUN 000037 //*-------------------------------------------------------------------- 000038 //SYSTSPRT DD SYSOUT=*,DCB=LRECL=200 000039 //SYSPRINT DD DUMMY 000040 //*-------------------------------------------------------------------- 000041 //ANLINFO DD DSN=&ANLINFO, 000042 // DISP=(,PASS), 000043 // DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000), 000044 // SPACE=(CYL,(1,1),RLSE) 000045 //*-------------------------------------------------------------------- 000046 //ANLCNTL DD DISP=SHR, 000047 // DSN=TS6224.ANL520.SANLPARM(DC1QCNTL) 000048 //ANLPARM DD DISP=SHR, 000049 // DSN=TS6224.ANL520.SANLPARM(DC1QPARM) 000050 //ANLPRINT DD DUMMY 000051 //ANLOUT DD DUMMY 000052 //ANLWORK DD DSN=&ANLWORK, 000053 // DISP=(,DELETE,DELETE), 000054 // DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000), 000055 // 000056 //*-------- Customize, Submit, or Save in another file. ----------- 000057 //REPORT 000058 //ANLCBAS DD DISP=SHR,This JCL is saved in the specified data set. You can also select another file to customize, submit or save this JCL.
- Submit the saved JCL to run the job in batch.