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
- 18628 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 copy pending status in db2?
what is the responsibility of the construction superintendent
What db2 400?
How to find schema of a table in db2?
How can we retrieve the total number of records in RPG & CLLE?
What is phantom read in db2?
What is buffer pool and list some of them?
How do you find the maximum value in a column in db2?
What is db2?
What is bind plan?
What does a deadlock mean in DB2?
What are the various isolation levels possible?
How to create db2 table in mainframe?
What is a dbrm in db2?
How to find the number of rows in a db2 table?
