Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 18618 Views
- Syntel, I also Faced
- E-Mail Answers
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 os does db2 run on?
What is consistency token in db2?
What is cursor in dbms?
What is query_cache_limit?
What is the difference between oracle and db2?
What is sqlca’s maximum length?
What is page size in db2?
What are the contents of a dclmgen?
What is performance tuning db2?
What is commit in db2?
Comment whether the cursor is closed during commit or not.
What is bind and rebind in db2?
How can you find out the # of rows updated after an update statement?
What is the max length of sqlca?
What is runstats utility in db2?
