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
- 18992 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 is a typical db2 batch pgm executed?
How to check table size in db2 sap?
What is db2 optimizer?
What is nvl in db2?
What are bind parameters in db2?
What is a collection in db2?
What are db2 tables?
How do I change the column size in db2?
What is the function of logging in the db2 database?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Can we insert update delete in view?
What do you mean by rollback?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
How does cobol compile db2 program?
What does db2 plan contain?
