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
- 16715 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
How connect db2 database to datastage?
What is blu acceleration in db2?
What are the contents of dclgen?
Define check constraint.
What is dbrm? What it contains? When it will be created?
What is package in db2 mainframe?
What is db2 connect?
What is the use of db2?
Can one database have multiple instances?
What type of database is db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is performance tuning db2?
What are the full forms of spufi and dclgen and why are they used?
what is the role of the cursor in db2?
What is check constraint. Explain with example.
