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

What are db2 objects?

1045


How to find primary key of a table in db2?

1065


What is db2 command?

1035


Why do chiropractors use drop table?

1106


What is the use of value function?

1149


What is the use of db2 optimizer?

1114


Can you tell me how can you find out the # of rows updated after an update statement?

1101


What is the usage of open cursor command?

1100


Why select is not preferred in embedded sql programs?

1299


What is null value in db2?

1024


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2248


Define buffer pool.

1053


How to get the ddl of a table in db2?

1131


Is db2 a mainframe?

1043


Are view updateable?

1043