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
- 19007 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / p praveen kumar
1) Isolation specifies types of locks to be used by
Repeatable Reads(Table space locks), Reads
Stability(page level locks), Cursor Stability(Row level Locks)
Uncommitted locks(no Locks)
2) Acquire tells when the lock should be acquired(USE,ALLOCATE)
3) Release tells when it should be unlocked(COMMIT, DEAL LOCATE)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is reorg?
What is role in db2?
What is database manager in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What os does db2 run on?
What language is db2 written in?
How does db2 sample database connect?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
is it compulsory commitment control in journal?
How do I add a column in db2?
What is cursor stability in db2?
Which components manage deadlocks in db2?
Explain about cursor stability?
How to find the number of rows in db2 tables?
