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
- 18745 Views
- Syntel, I also Faced
- E-Mail Answers
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 maximum size of varchar data type in db2?
What is the meaning concurrency in the db2 database?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the physical storage length of timestamp data type?
What is universal database?
What is table space in db2?
What is db2 plan table?
Which components manage deadlocks in db2?
How to find the number of rows in db2 tables?
What is null value in db2?
How can you do the explain of a dynamic sql statement?
Explain about rct.
What is commit in db2?
What's The Percentage Free Space ?
What are the contents of dclgen?
