DB2- Bind Options

During DB2 program bind with online we need to select some of the options:

First, we need to mention DBRM library, then, Plan name we 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


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 in my next post.


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.