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
- 19264 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
What is dbrm in db2 database?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What do you mean by commit and rollback?
What is dbrm? What it contains?
What r the comman abends in db2, jcl and cobol???????
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How connect db2 database to datastage?
What is the difference between dbm cfg and db cfg file in db2 ?
What is an instance database?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is db2 purescale?
What does db2 blu stand for?
Is schema the same as database?
What is access path in db2?
What is difference between alias and synonym in db2?
