Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18872 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / madhu
1) Acquire and Release are effective when lock rule of tablespace is either table lock or tablespace lock. In this case, bind level isolation has no effect.
2) Isolation Level is effective when lock rule of tablespace is either page lock or row lock. In this case, Acquire and Release has no effect.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a cursor in programming?
What is release/acquire in bind?
What is the purpose of using commit?
What is the role of data manager in the db2 database?
What is image copy in db2?
How can deadlocks be resolved?
What is rebind in db2?
What is declare cursor?
Explain about dbrm.
How do you stop a db2 database in linux?
What is the result of open cursor statement?
How will you return the number of records in table?
Define sqlca.
What is the use of db2 optimizer?
What is the maximum number of columns in a db2 table?
