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
- 19263 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
How can we read records for specific member in CL? AND rpg?
What is dclgen (declaration generator)?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What db2 400?
What action db2 takes when a program aborts in the middle of a transaction?
What is a db2 collection?
what is utility for parm lib
What is the syntax for seeing the columns and data types of a table in the db2 database?
When do you specify the isolation level?
Give a brief description of db2 isolation levels?
What is a db2 schema?
What is db2 stogroup?
What is blu acceleration in db2?
What is a plan and package in db2?
What is dbrm? What it contains?
