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
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is the use of with ur in db2?
What is explain plan in db2?
What is db2 instance?
What is with ur in db2?
How to retrieve rows from a db2 table in embedded sql?
What is node in db2?
Mention the location where the output received from explain statement is stored.
What is an instance in db2?
Explain about open switch business continuity software?
What is difference between isnull and coalesce?
If I have a view which is a join of two or more tables, can this view be updateable?
How to access db2 tables in mainframe?
What are concurrency issues?
How do you eliminate duplicate values in db2?
