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?
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 os does db2 run on?
What is declare cursor?
What are the prerogatives?
What is a bind card?
What is node in db2?
What is db2 bind?
Is ibm db2 free?
How can we read records for specific member in CL? AND rpg?
What is the syntax for creating a table in the db2 database?
Explain what are the various isolation levels possible?
What is a cursor in programming?
When the like statement is used?
Describe major components of db2?
What r the comman abends in db2, jcl and cobol???????
How do I optimize a query in db2?