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?
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
B37 abend during spufi?
What is the use of with ur in db2?
Define check constraint.
How is deadlock resolved?
What is the clustering index in the db2 database?
What is the use of db2 optimizer?
What is the role of union all and union
How would you find out the total number of rows in a db2 table?
What is scrollable cursor in db2?
What does runstats do in db2?
What is difference between alias and synonym in db2?
What is ibm db2 client?
How to check sequence on a table in db2?
Explain the function done by data manager?
What is buffer pool in the db2 database?