Answer Posted / islam
RELEASE has two parametre : commit & deallocate
RELEASE specify when the the db2 resources has to be set
free
if you use RELEASE(commit) then at every commit point db2
resources will be set free
but if u use RELEASE(DEALLOCATE) then once the whole
transaction is terminated, the db2 resources will be set
free
ACQUIRE serves the purpose of maintaining data consistency.
It has two parametre : ALLOCATE & USE
ACQUIRE(USE) - Opens table spaces and acquires locks only
when the application program bound to the plan first
uses them.
ACQUIRE(ALLOCATE) - Opens all table spaces and
acquires all table space locks when the plan is
allocated.
ACQUIRE(USE) - Fixed for Packages
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
How to check sequence on a table in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Explain the contents that are a part of dclgen.
What does db2 plan contain?
What are the various isolation levels possible?
What is check constraint in db2?
What is a system catalog table in db2?
Outputs of explain are with matchcols = 0. What does this signify?
Explain what are the various isolation levels possible?
What is nvl in db2?
What is phantom read in db2?
What is role in db2?
Why do we use cursor?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
what is the role of the cursor in db2?
