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
- 18641 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 are packages in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the difference between plan and package in db2?
Mention the definition of cobol in varchar field.
What is universal database?
Is it possible using max on a char column?
Which isolation level provides maximum concurrency?
What is cobol db2?
Explain the contention situations caused by locks?
What is the information associated with sysibm.syslinks table?
Explain in brief how does db2 determine what lock-size to use?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What are the bind parameters ibm db2?
Is db2 a database?
What is difference between isnull and coalesce?
