When a tablespace is locked, another task cannot have access to the entir

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

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

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

What is with ur in db2?

1256

What is a db2 table?

969

Define predicate?

1075

What happens in bind step in a db2 program?

930

How do I import a csv file into db2?

946

What is runstats db2?

970

Give the name of some fields form sqlca.

1033

What is precompiler in db2?

969

Explain db2.

998

What is cursor with hold option in db2?

1021

What is the role of schema in the db2 database?

1203

Explain about rct.

1036

Can we delete records from view?

927

Is ibm db2 open source?

1028

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1029