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
18625 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

List out the data types available.

1081

What is view db2?

1004

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1219

What is dbrm library?

999

What is an instance in db2?

982

What is db2 connect?

1008

What is database alias db2?

1066

What are the 2 sqlcodes that are returned?

1128

What is the difference between using bind () and rebind () methods of naming class?

1328

Is the primary key a clustered index?

1077

What is runstats and reorg in db2?

1236

What is page size in db2?

906

What types of tables are there in the db2 database?

1004

What does db2 mean?

955

What is the role of data manager in the db2 database?

1051