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
Are view updateable?
What is dbrm? What it contains?
Describe major components of db2?
How does cobol compile db2 program?
Is db2 a programming language?
How do I add a column in db2?
What is the picture clause of null indicator variable?
How do I import data from excel to db2?
What are the 2 sqlcodes that are returned?
What is cursor with hold option in db2?
What is clone table?
What is access path in db2?
What is the role of union all and union
What do you mean by between and in? Is between inclusive of specified range values?
What is cursor in dbms?