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...

What is ACQUIRE/RELEASE in BIND?

Answer Posted / ramesh naidu

Acquire:it acquire the locks on table spaces

Acquire(use): Acquire the locks at bind time
Acquire(allocate):Acquire the locks at run time.

Release:It release the locks on the table space

Release(commit):It saves the changes made to the data in database permanently.

Release(rollback):it undo the changes made to the database.

Is This Answer Correct ?    3 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Outputs of explain are with matchcols = 0. What does this signify?

1051


What are the prerogatives?

1076


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2060


What is phantom read in db2?

1153


What is the difference between drop table and delete table?

1203


Explain packages.

1108


How does db2 sample database connect?

1024


What is the difference between db2 and oracle?

1126


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1044


What do you mean by commit and rollback?

1033


What is query_cache_limit?

968


How to check last update on table in db2?

1055


What is commit in db2?

1051


How do you find the maximum value in a column in db2?

1101


What is netezza database?

1021