SQL PA Batch JCL
You can use this sample JCL for batch processing of your SQL PA job.
The sample JCL in the following figure shows the allocations necessary to run Db2 SQL Performance Analyzer under a sample user ID of TDT690. It includes an optional first step that deletes information left after a previous run.
This sample JCL is not intended to be used with generic IDs. To use generic IDs in batch, use the BATCH command to generate the JCL. If generic IDs are used incorrectly in batch, the IDs might not be properly freed in the REGISTRY. See Resetting the Db2 SQL Performance Analyzer REGISTRY, if no more generic IDs are available.
VIEW TS5264.ANL520.SANLJCL(LDS6JSPA) - 01.00 Columns 00001 00072
****** ***************************** Top of Data ******************************
000001 //ANLBATCH JOB ,
000002 // USER=&SYSUID,NOTIFY=&SYSUID,MSGCLASS=H,
000003 // MSGLEVEL=(1,1),REGION=0M,TIME=10
000004 /*JOBPARM S=*
000005 //*LDS6JSPA
000006 //*
000007 //**********************************************************************
000008 //* S Q L P A - - S Q L P E R F O R M A N C E A N A L Y Z E R *
000009 //**********************************************************************
000010 //*
000011 //* LICENSED MATERIALS - PROPERTY OF IBM CORPORATION - 5697-W51
000012 //* COPYRIGHT IBM CORPORATION 2000, 2015 ALL RIGHTS RESERVED
000013 //*
000014 //* US GOVERNMENT USERS RESTRICTED RIGHTS - USE, DUPLICATION OR
000015 //* DISCLOSURE RESTRICTED BY GSA ADP SCHEDULE CONTRACT WITH IBM.
000016 //*
000017 //* COPYRIGHT ROCKET SOFTWARE,INC. 2016, 2025 ALL RIGHTS RESERVED
000018 //**********************************************************************
000019 //* ANL520
000020 //*********************************************************************
000021 //* STEP 0: DELETE THE PREVIOUS RUN'S PERMANENT REPORTS, IF NECESSARY
000022 //*
000023 //ANLSTEP0 EXEC PGM=IEFBR14
000024 //GOAWAY1 DD DSN=&SYSUID..ANLREP.RPT,DISP=(MOD,DELETE),
000025 // SPACE=(TRK,(1,1),RLSE)
000026 //GOAWAY3 DD DSN=&SYSUID..QLIMIT.RPT,DISP=(MOD,DELETE),
000027 // SPACE=(TRK,(1,1),RLSE)
000028 //GOAWAY4 DD DSN=&SYSUID..ANLOUT.RPT,DISP=(MOD,DELETE),
000029 // SPACE=(TRK,(1,1),RLSE)
000030 //*
000031 //**********************************************************************
000032 //*
000033 //ANLSTEP1 EXEC PGM=ANLSQLPA,REGION=0M
000034 //*
000035 //STEPLIB DD DISP=SHR,
000036 // DSN=TS5264.ANL520.SANLLOAD
000037 // DD DISP=SHR,
000038 // DSN=CEE.SCEERUN
000039 // DD DISP=SHR,
000040 // DSN=LDS6.SDSNEXIT
000041 // DD DISP=SHR,
000042 // DSN=LDS6.SDSNEXIT
000043 // DD DISP=SHR,
000044 // DSN=DSN.VD10.SDSNLOAD
000045 // DD DISP=SHR,
000046 // DSN=DSN.VD10.SDSNLOAD
000047 //*
000048 //*SNTRACE DD SYSOUT=*
000049 //*
000050 //ANLCNTL DD DISP=SHR,
000051 // DSN=TS5264.ANL520.SANLPARM(LDS6CNTL)
000052 //ANLPARM DD DISP=SHR,
000053 // DSN=TS5264.ANL520.SANLPARM(LDS6PARM)
000054 //*******
000055 //ANLWORK DD DSN=&&ANLWORK,DISP=(,DELETE,DELETE),
000056 // SPACE=(CYL,(5,1),RLSE),DCB=(LRECL=80,RECFM=FB,BLKSIZE=4000)
000057 //*******
000058 //ANLIN DD DISP=SHR,
000059 // DSN=TS5264.ANL520.SANLSQL(ANLSTEST)
000060 //*******
000061 //ANLOUT DD DSN=&SYSUID..ANLOUT.RPT,DISP=(,CATLG,DELETE),
000062 // SPACE=(CYL,(1,1),RLSE),DCB=(LRECL=80,RECFM=FB,BLKSIZE=9040)
000063 //*
000064 //ANLPRINT DD SYSOUT=*,DCB=LRECL=133
000065 //SYSPRINT DD SYSOUT=*,DCB=LRECL=133
000066 //*
000067 //**********************************************************************
000068 //* ANLREP IS THE EXPLAIN REPORT: YOU MAY WISH TO NAME IT SO THAT
000069 //* YOU CAN RECOGNIZE WHICH INPUT SQL PRODUCED THIS PARTICULAR REPORT.
000070 //*
000071 //*
000072 //* QLIMIT IS THE QUERY LIMITS REPORT: IT CONTAINS A FLAG FOR EACH
000073 //* LIMIT EXCEEDED, PLUS COST VALUES, ONE LINE PER QUERYNO.
000074 //*
000075 //**********************************************************************
000076 //*
000077 //ANLREP DD DSN=&SYSUID..ANLREP.RPT,DISP=(,CATLG,DELETE),
000078 // SPACE=(CYL,(1,1),RLSE),DCB=(LRECL=132,RECFM=FB,BLKSIZE=23760)
000079 //QLIMIT DD DSN=&SYSUID..QLIMIT.RPT,DISP=(,CATLG,DELETE),
000080 // SPACE=(TRK,(1,1),RLSE),DCB=(LRECL=120,RECFM=FB,BLKSIZE=23520)
000081 //*
****** **************************** Bottom of Data ****************************