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
- 16180 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / gopi
(1) Isolation specifies type of lock that should be used
(2) Acquire tells when the lock should be acquired
(3) Release tells when it should be unlocked
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How can we read records for specific member in CL? AND rpg?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is dbrm library?
What are the full forms of spufi and dclgen and why are they used?
What is db2 command?
What is the difference between db2 and oracle?
What is the maximum size of varchar data type in db2?
Comment whether the cursor is closed during commit or not.
List down the data types in the db2 database.
what is a corelated subquerry?
How to resolve deadlock issue
What types of tables are there in the db2 database?
How can you count the number of rows from a table tab?
What are concurrency issues?
What is dpf in db2?
