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
- 17528 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
What is cursor with hold option in db2?
List out the three types of page locks that can be held.
What is the difference between plan and package in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How can deadlocks be resolved?
What are the contents of a dclmgen?
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?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
what is the role of the cursor in db2?
Is schema the same as database?
What is reorg?
what is utility for parm lib
What is sqlca’s maximum length?
What is the connection string to connect to the DB2 Database ?
