Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

Why do chiropractors use drop table?

1044


Why do we need reorg in db2?

922


Is db2 a programming language?

983


Explain about rct.

1024


What are the uses of db2 optimizer?

1223


What is meant by union and union all?

948


How can we retrieve the total number of records in RPG & CLLE?

577


List down the types of triggers in the db2 database?

963


What is lock escalation in db2?

967


What is temporal table in db2?

988


Explain package in db2 and its advantages?

1134


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1102


Explain various types of locks in db2?

1081


What does db2 stand for?

959


can we view the access paths created by dbrm ? how ? thx

6973