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
Why do chiropractors use drop table?
Why do we need reorg in db2?
Is db2 a programming language?
Explain about rct.
What are the uses of db2 optimizer?
What is meant by union and union all?
How can we retrieve the total number of records in RPG & CLLE?
List down the types of triggers in the db2 database?
What is lock escalation in db2?
What is temporal table in db2?
Explain package in db2 and its advantages?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Explain various types of locks in db2?
What does db2 stand for?
can we view the access paths created by dbrm ? how ? thx