You already know that you can run DB2 program using batch jcl. The below JCL helps you understand quickly on what all parameters you need
Sample DB2 batch JCL
//STEP001 EXEC PGM=IKJEFT01 //* //STEPLIB DD DSN=SRINIDATA.URMI.DBRMLIB,DISP=SHR //* //input files //output files //SYSPRINT DD SYSOUT=* //SYSABOUT DD SYSOUT=* //SYSDBOUT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //DISPLAY DD SYSOUT=* //SYSOUT DD SYSOUT=* //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(SSID) RUN PROGRAM(SRINICOB) PLAN(PLANNAME) PARM(parameters to cobol program) - LIB('SRINIDATA.URMI.LOADLIB') END /*
In the above JCL ‘SRINICOB’ is DB2 program. Before you execute you need to follow DB2 program preparation steps.
During DB2 program bind using online method, the first step is you need to select some of the options given below.
Then, you need to mention DBRM library, then, Plan name you need to give.
My favourite books definitely help you to get ahead in work/getting new job.
Isolation CS/RR – These are locks any one we can select.
Acquire: Use It means to use table space locks only when they are used.
Action: ADD/REPLACE It is for Bind plan whether to ADD or Replace the object
CURRENT DATA : YES/NO
Yes means data currency for Read only cursors. No means no data currency for Read only cursors.
1- means it prohibits using parallel processing. ANY-means it allows parallel processing. I will give some more details in my next post.