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
- 18874 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
Are view updateable?
Is db2 a programming language?
How to find the number of rows in db2 tables?
What is table space in db2?
How does cobol compile db2 program?
What is null indicator in cobol db2?
Are views updateable?
Which is faster delete or truncate?
Why do we use cursor?
What does a deadlock mean in DB2?
What is the clustering index in the db2 database?
What is dbrm? What it contains?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is rebind in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
