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
- 19006 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 the physical storage length of the data types: date, time, timestamp in the db2 database?
What is database alias db2?
Define data page.
Explain various types of locks in db2?
What is the connection string to connect to the DB2 Database ?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the role of schema in the db2 database?
What are the full forms of spufi and dclgen and why are they used?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What are db2 tables?
List out the three types of page locks that can be held.
What are the contents of dclgen?
What is the use of with ur in db2?
What is role in db2?
What is the use of dclgen in db2?
