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
- 18626 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / priya
When a tablespace is locked, another task cannot have
access to the entire table itself. So here, does page level
locking matter and what difference remains between
ISOLATION and ACQUIRE/RELEASE?
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is db2 restart?
What is the difference between dbm cfg and db cfg file in db2 ?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
what is utility for parm lib
Is db2 a mainframe database?
What is the max length of sqlca?
What is buffer pool?
What is the difference between oracle and db2?
What is runstats and reorg in db2?
List out the three types of page locks that can be held.
What is with ur in db2?
What is the use of runstats in db2?
Is schema the same as database?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Which components manage deadlocks in db2?
