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

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 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.