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
- 19260 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
Give the name of some fields form sqlca.
How to check table size in db2 sap?
What is phantom read in db2?
What are host variables in db2?
How do I add a column to an existing table in db2?
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?
Can there be more than one cursor open for any program?
Outputs of explain are with matchcols = 0. What does this signify?
Explain about open switch business continuity software?
What is database alias db2?
Which command is used to remove all rows from a table?
Mention some fields that are a part of sqlca.
What is the max length of sqlca?
What is db2 purescale?
What is a db2 collection?
