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
- 18703 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
Is db2 a mainframe?
What is a buffer in memory?
How to compare data between two tables in db2?
Mention the different locking levels that are available in db2.
Before you give the explain statement, what are the prerogatives?
What is the physical storage length of time data type?
What is phantom read in db2?
How do I copy a table in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is universal database?
Define buffer pool.
What is the difference between drop table and delete table?
How can you count the number of rows from a table tab?
What is difference between alias and synonym in db2?
what is a corelated subquerry?
