Answer Posted / amarnadh reddy
hi,
Bind parameters are:
MEMBER - In bind package,
LIRARY - DBRM library name ,
ACTION(add/replace)- package or plan can be add or replace.
ISOLATION - Determines the duration of the page lock.
AQUIRE - Lock a tableon use
RELEASE - releases when the plan terminates
VALIDATE - It will be check about authorization.
EXPLAIN - loads the access path selected by the optimizer
in table
| Is This Answer Correct ? | 41 Yes | 2 No |
Post New Answer View All Answers
How can we retrieve the total number of records in RPG & CLLE?
What are the bind parameters ibm db2?
What is db2 catalog database?
What does db2 blu stand for?
Explain the contents that are a part of dclgen.
What is the picture clause of null indicator variable?
Explain in detail about buffer manager and its functionalities?
What is the purpose of using commit?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How do you stop a db2 database in linux?
On which levels locks can be applied?
How is the value function used?
Mention the location where the output received from explain statement is stored.
What is consistency token in db2?
How can deadlocks be resolved?