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
- 16195 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / gopi
(1) Isolation specifies type of lock that should be used
(2) Acquire tells when the lock should be acquired
(3) Release tells when it should be unlocked
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are db2 objects?
Explain in detail about buffer manager and its functionalities?
How do you pull up a query which was previously saved in qmf?
What is buffer pool in the db2 database?
Mention some fields that are a part of sqlca.
What does a deadlock mean in DB2?
What is rebind in db2?
Explain about rct in db2?
Comment whether the cursor is closed during commit or not.
What is a db2 collection?
What is precompiler in db2?
What is an instance database?
What is cursor in dbms?
What is the usage of open cursor command?
What is performance tuning db2?
