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
Mention data types used in db2 ?
Explain about mirror activator disk mirroring?
What is drop table?
How does db2 sample database connect?
How to compare data between two tables in db2?
What is db2 connect?
what is the sqlcode -501
What's The Percentage Free Space ?
What is a db2 table?
What is phantom read in db2?
What is the use of predicate?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is performance tuning db2?
What is a Foreign Key?