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
- 18730 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / p praveen kumar
1) Isolation specifies types of locks to be used by
Repeatable Reads(Table space locks), Reads
Stability(page level locks), Cursor Stability(Row level Locks)
Uncommitted locks(no Locks)
2) Acquire tells when the lock should be acquired(USE,ALLOCATE)
3) Release tells when it should be unlocked(COMMIT, DEAL LOCATE)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is iseries database?
How to find primary key of a table in db2?
What is the use of predicate?
What are the bind parameters ibm db2?
What is runstats db2?
What does sqlcabc has?
What is database manager in db2?
Define declaration generator (dclgen).
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the information associated with sysibm.syslinks table?
What is reorg and runstats in db2?
What is ibm db2 connect?
Comment whether the cursor is closed during commit or not.
Differentiate between cs and rr isolation levels? Where do you specify them?
What's The Error Code For Unique Index Voilation?
