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

What is multi row fetch in db2?

614


Which component is responsible for db2 startup and shutdown?

634


What is meant by dclgen?

623


What is the role of the data page in the db2 database?

593


What is commit in db2?

600






What is the difference between nvl and coalesce?

608


What are the rules for db2 programming?

651


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

625


Why cursor is used in db2?

579


What is db2 catalog database?

589


What is db2 stogroup?

683


Why do chiropractors use drop table?

672


Are views updateable?

649


What is runstats and reorg in db2?

808


How to find the number of rows in db2 tables?

623