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
- 18982 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
What is a db2 cursor?
What is ibm db2 database?
Mention data types used in db2 ?
What do you mean by between and in? Is between inclusive of specified range values?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Define check constraint.
What is cursor stability in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is dbrm? What it contains? When it will be created?
When reorg is used?
What are the rules for db2 programming?
How does db2 sample database connect?
Explain about cursor stability?
Define predicate?
What is syscat in db2?
