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
- 19009 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / rrgust
In ACQUIRE there are two options are available 1) Use
2)Allocate. When the bind card contains ACQUIRE(USE) when
there there is first hit to the table, lock willbe held. If
you use the second option, during the executin the lock
will be held.
Reg: RELEASE, it will take RELEASE(COMMIT). Once commit is
perfomed, the lock will be released..
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is the usage of open cursor command?
Can you tell me how can you find out the # of rows updated after an update statement?
What is the difference between db2 and oracle?
Is db2 a programming language?
What is sqlca’s maximum length?
What is nvl in db2?
Which are the db2 tools to protect integrity of the database?
What does a deadlock mean in DB2?
What is a page in db2?
What is cloudant database?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How do I copy a table in db2?
What is plan in cobol db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is load replace in db2?
