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
What does runstats do in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is a Foreign Key?
What is image copy in db2?
How do I change the column size in db2?
What is precompiler in db2?
What is an instance in db2?
What is copy pending status in db2?
How does cobol compile db2 program?
What is dpf in db2?
What is the role of data manager in the db2 database?
How do I optimize a query in db2?
What os does db2 run on?
What are concurrency issues?
How to find the number of rows in db2 tables?