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

When a tablespace is locked, another task cannot have
access to the entire table itself. So here, does page level
locking matter and what difference remains between
ISOLATION and ACQUIRE/RELEASE?

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

B37 abend during spufi?

1455


What is the use of with ur in db2?

1056


Define check constraint.

1076


How is deadlock resolved?

1146


What is the clustering index in the db2 database?

1001


What is the use of db2 optimizer?

1112


What is the role of union all and union

1127


How would you find out the total number of rows in a db2 table?

1050


What is scrollable cursor in db2?

1055


What does runstats do in db2?

1115


What is difference between alias and synonym in db2?

1140


What is ibm db2 client?

939


How to check sequence on a table in db2?

1057


Explain the function done by data manager?

1276


What is buffer pool in the db2 database?

1096