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 / neeti

Isolation level parameters are used on page level while the
ACQUIRE and RELEASE parameters work on tablespace levels

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why select is not preferred in embedded sql programs?

1277


How many types of page locks can be held in db2?

1020


Explain about open switch business continuity software?

1111


What is ibm db2 used for?

1051


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.

2697


Define db2.

1096


What are the benefits of using the db2 database?

1208


What is blu acceleration in db2?

1047


What is db2 optimizer?

1214


List down the data types in the db2 database.

1095


When reorg is used?

1106


What is a db2 tablespace?

1044


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1048


How to check sequence on a table in db2?

1043


What is difference between rollback and commit?

1133