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
Why select is not preferred in embedded sql programs?
How many types of page locks can be held in db2?
Explain about open switch business continuity software?
What is ibm db2 used for?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Define db2.
What are the benefits of using the db2 database?
What is blu acceleration in db2?
What is db2 optimizer?
List down the data types in the db2 database.
When reorg is used?
What is a db2 tablespace?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How to check sequence on a table in db2?
What is difference between rollback and commit?