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 / neeti

Isolation level parameters are used on page level while the
ACQUIRE and RELEASE parameters work on tablespace levels

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is ibm db2 free?

575


What does sqlcabc has?

633


What is the maximum length of sqlca?

869


Explain about dbrm.

609


List some fields from sqlca?

613






B37 abend during spufi?

982


What is runstats utility in db2?

569


What is the purpose of using commit?

618


Is it possible using max on a char column?

609


What is db2 command?

586


How to run db2 command in windows?

652


What is cobol db2?

569


List out the data types available.

704


What is clone table?

592


What do you mean by storage group (stogroup)?

583