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
- 18675 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / g
ACQUIRE, RELEASE parameters refer to when the resources for
the application program will be acquired and released. This
includes when datasets will be allocated/deallocated, when
storage will be allocated/deallocated for DBDs,
plans/packages in EDM pool.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is bind in db2?
Explain various types of locks in db2?
What db2 400?
What is the clustering index in the db2 database?
How to test SQL -911 error while developing COB-DB2 program
What are the benefits of using the db2 database?
How can deadlocks be resolved?
Explain how can you do the explain of a dynamic sql statement?
What is the maximum size of a char data type in db2?
What is dbrm? What it contains? When it will be created?
What is phantom read in db2?
How to compare data between two tables in db2?
How to rename a table in DB2 ?
What is null indicator in db2?
