DB2 Bind Options This is the Example How to Use in JCL

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

DB2 Bind Options How to Use in 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.

Top Bind options

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.

DEGREE:  1/ANY

1- means it prohibits using parallel processing. ANY-means it allows parallel processing. I will give some more details in my next post.

Related Posts