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
- 18644 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 is the difference between plan and package in db2?
What is alias in db2?
How to rename a table in DB2 ?
What is ibm db2 connect?
What are the rules for db2 programming?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What do you mean by rollback?
What is a db2 tablespace?
How can deadlocks be resolved?
What is the use of runstats in db2?
Mention the definition of cobol in varchar field.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the physical storage length of the data types date, time, and timestamp?
What is db2 connect?
can we view the access paths created by dbrm ? how ? thx
