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?
- 8 Answers
- 16193 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / guest
ACQUIRE, RELEASE determines when a partition, table or
tablespace lock will be acquired and released. ISOLATION
determines when a row, page lock will be acquired and
released. PAGE, ROW locks are released depending on the
ISOLATION level but almost always at commit or rollback.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is check constraint. Explain with example.
What is precompiler in db2?
What is dclgen (declaration generator)?
Define buffer pool.
B37 abend during spufi?
What is commit in db2?
Define data page.
What is a Foreign Key?
What is an instance database?
When do you specify the isolation level?
What do you mean by rollback?
What is bind package and plan in db2?
Define db2 and its databases?
How do I delete a table in database?
What is sqlca?
