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
Can we insert update delete in view?
Before you give the explain statement, what are the prerogatives?
How to create db2 table in mainframe?
What is dbrm? What it contains? When it will be created?
How to find the number of rows in a db2 table?
How do I delete a column in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is the physical storage length of date data type?
Comment whether the cursor is closed during commit or not.
What is syscat in db2?
Explain in brief how does db2 determine what lock-size to use?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
List out the three types of page locks that can be held.
What are db2 objects?
How do I change the column size in db2?
