Top DB2 bind options you always need to give (1 of 2)

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.

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.

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.

Comments are closed.