Isolation level parameters are used on page level while the ACQUIRE and R

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?

Question Posted / neeti

8 Answers
18704 Views
Syntel, I also Faced
E-Mail Answers

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

What is page size in db2?

922

How do I import a csv file into db2?

948

How is a typical db2 batch pgm executed?

1124

i want to maintain uniqueness on pdf without make lf??????????

2116

What are the different types of base tables?

1044

What is phantom read in db2?

1091

What is the usage of open cursor command?

1054

Is db2 a programming language?

999

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1129

What is database manager in db2?

980

What are iseries servers?

1027

Are view updateable?

994

What do you mean by between and in? Is between inclusive of specified range values?

1053

What does runstats do in db2?

1041

What is the role of schema in the db2 database?

1210