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
How can the duplicate values be eliminated from db2 select?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is a db2 table?
Why select is not preferred in embedded sql programs?
What are the two types of logging in the db2 database? Explain them.
What are the various data types available in db2?
What is db2 bind?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is db2 plan table?
What is reorg and runstats in db2?
What is load utility in db2?
What is the maximum number of columns in a db2 table?
What is runstats and reorg in db2?
What is check constraint. Explain with example.
Can there be more than one cursor open for any program?