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
What is the use of db2?
What is load utility in db2?
What parameters are used to control the free space in DB2?
What is cobol db2?
What are the 2 sqlcodes that are returned?
What is the physical storage length of timestamp data type?
How to connect to db2 database from windows command line?
Why do chiropractors use drop table?
How would the varchar column remarks defined?
What is the difference between bind and rebind in db2?
What is the difference between drop table and delete table?
Explain correlated sub-queries.
How to find the number of rows in a db2 table?
What is db2 plan table?
How to check sequence on a table in db2?