Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18882 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
What is the maximum size of a char data type in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is a trigger in the db2 database?
What is null indicator in db2?
What is package in cobol db2?
Is it possible using max on a char column?
What is ibm db2 used for?
What is db2 catalog database?
What r the comman abends in db2, jcl and cobol???????
What is db2 instance?
How can you quickly find out the # of rows updated after an update statement?
What is db2 command?
What does db2 blu stand for?
What is the difference between bind and rebind in db2?
Outputs of explain are with matchcols = 0. What does this signify?
