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 do I import a csv file into db2?
Explain how can you do the explain of a dynamic sql statement?
Explain about mirror activator disk mirroring?
How is deadlock resolved?
What is innodb buffer pool?
What is a cursor in programming?
How to check last update on table in db2?
What language is db2 written in?
How to execute stored procedures?
Can we insert update delete in view?
What does db2 plan contain?
Explain db2.
Explain in brief how does db2 determine what lock-size to use?
What is a plan and package in db2?
How do I optimize a query in db2?