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
- 19255 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
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is the difference between bind and rebind in db2?
What is the clustering index in the db2 database?
What is netezza database?
What is the result of open cursor statement?
Discuss about db2 bind?
What is dpf in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Is db2 a database?
List down the types of triggers in the db2 database?
What is the use of dclgen in db2?
Give a brief description of db2 isolation levels?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the meaning concurrency in the db2 database?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
