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 / 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
What is the usage of open cursor command?
What is a bind card?
What is an instance database?
What is package in cobol db2?
Is db2 free?
What is cobol db2?
What is rct?
How do you select a row using indexes in db2?
What is buffer pool?
How does cobol compile db2 program?
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 do I start db2 in windows?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How does coalesce work?
How many databases can be created inside an instance in db2 ?