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


Please Help Members By Posting Answers For Below Questions

How can you classify the locks in db2?

861


What is the role of union all and union

888


What is reorg?

874


Why db2 is called db2?

797


What is db2 purescale?

785


Define data page.

848


What's The Percentage Free Space ?

992


What is precompiler in db2?

800


What is nvl in db2?

844


What is the physical storage length of date data type?

1020


What is meant by explain?

877


How to execute stored procedure in db2 command editor?

776


What is check constraint. Explain with example.

870


What is dbrm in db2 database?

815


What is the use of reorg in db2?

845