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 / priya
When a tablespace is locked, another task cannot have
access to the entire table itself. So here, does page level
locking matter and what difference remains between
ISOLATION and ACQUIRE/RELEASE?
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How can you classify the locks in db2?
What is the role of union all and union
What is reorg?
Why db2 is called db2?
What is db2 purescale?
Define data page.
What's The Percentage Free Space ?
What is precompiler in db2?
What is nvl in db2?
What is the physical storage length of date data type?
What is meant by explain?
How to execute stored procedure in db2 command editor?
What is check constraint. Explain with example.
What is dbrm in db2 database?
What is the use of reorg in db2?