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?
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
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the difference between using bind () and rebind () methods of naming class?
How to compare data between two tables in db2?
What is the physical storage length of time data type?
What is the difference between dbm cfg and db cfg file in db2 ?
What is a db2 tablespace?
Name the lockable units in DB2?
How do I delete a table in db2?
What is difference between rollback and commit?
What is a dbrm in db2?
How can deadlocks be resolved?
What is the role of schema in the db2 database?
If I have a view which is a join of two or more tables, can this view be updateable?
What is meant by explain?
What is the difference between cursor and select statement?