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?
- 8 Answers
- 16176 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / guest
ACQUIRE, RELEASE determines when a partition, table or
tablespace lock will be acquired and released. ISOLATION
determines when a row, page lock will be acquired and
released. PAGE, ROW locks are released depending on the
ISOLATION level but almost always at commit or rollback.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
i want to maintain uniqueness on pdf without make lf??????????
What is db2 instance?
Where can you declare a cursor in a cobol-db2 program?
Which component is responsible for db2 startup and shutdown?
What is consistency token in db2?
How to get the ddl of a table in db2?
How to restart a DB2 program?
How to create backup table in db2?
How to find the maximum value in a column in the db2 database?
What is meant by union and union all?
How do I import data from excel to db2?
What is the difference between plan and package in db2?
What is data manager?
How does cobol compile db2 program?
Is db2 relational database?
