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 / rrgust
In ACQUIRE there are two options are available 1) Use
2)Allocate. When the bind card contains ACQUIRE(USE) when
there there is first hit to the table, lock willbe held. If
you use the second option, during the executin the lock
will be held.
Reg: RELEASE, it will take RELEASE(COMMIT). Once commit is
perfomed, the lock will be released..
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What are the 2 sqlcodes that are returned?
What's The Error Code For Unique Index Voilation?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is a page in db2?
What is db2 look?
Mention the location where the output received from explain statement is stored.
What is the difference between cursor and select statement?
What is null value in db2?
What is plan in cobol db2?
How to view db2 table structure?
What is clone table?
What is the reason behind not using select * in embedded sql programs?
What is explain in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is rct?