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.
1- means it prohibits using parallel processing. ANY-means it allows parallel processing.
I will give some more in my next post.