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
- 18731 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
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What are the 2 sqlcodes that are returned?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How do I change the column size in db2?
What is the information associated with sysibm.syslinks table?
What is difference between rollback and commit?
What is netezza database?
How to retrieve rows from a db2 table in embedded sql?
What is the difference between dbm cfg and db cfg file in db2 ?
What is the use of value function?
What are the rules for db2 programming?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How can we read records for specific member in CL? AND rpg?
What are the contents of dclgen?
What are db2 tables?
