In BIND, isolation level parameter specifies the duration
of page lock and ACQUIRE, RELEASE also do almost the same
thing. What is the exact difference between the two? Do
they work in conjunction while executing SQL queries and
obtaining locks?
Answer Posted / g
ACQUIRE, RELEASE parameters refer to when the resources for
the application program will be acquired and released. This
includes when datasets will be allocated/deallocated, when
storage will be allocated/deallocated for DBDs,
plans/packages in EDM pool.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Mention the location where the output received from explain statement is stored.
What are the full forms of spufi and dclgen and why are they used?
what are bind concepts in db2 cobol?
What is load utility in db2?
How to check last update on table in db2?
List out the buffer pools in db2
What are packages in db2?
What does db2 blu stand for?
Explain the contention situations caused by locks?
What is the function of logging in the db2 database?
Mention the definition of cobol in varchar field.
Explain the function done by data manager?
What do you mean by between and in? Is between inclusive of specified range values?
What is a page in db2?
Explain packages.