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
How do you select a row using indexes in db2?
What is a buffer in memory?
What are host variables in db2?
Who uses db2?
What is buffer pool and list some of them?
What is clone table?
What is bind plan?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How connect db2 database to datastage?
What does db2 mean?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
List out the buffer pools in db2
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is the difference between oracle and db2?
Explain about rct in db2?
