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
- 16198 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
How do I connect my db2 database to ibm?
Why db2 is called db2?
can all users have the privilage to use the sql statement select * (dml)?
What is db2 connect?
If I have a view which is a join of two or more tables, can this view be updateable?
Is db2 a mainframe database?
Explain dclgen.
List down the data types in the db2 database.
What is the difference between cursor stability and repeatable read isolation levels?
What is performance tuning db2?
How do I delete a table in database?
Which components manage deadlocks in db2?
Before you give the explain statement, what are the prerogatives?
What is meant by explain?
Explain about rct in db2?
