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
Highlight all the advantages that are attached to a package.
When the like statement is used?
What is query_cache_limit?
How and when does the db2 enforces the unique key?
What is the connection string to connect to the DB2 Database ?
What is buffer pool and list some of them?
How can we read records for specific member in CL? AND rpg?
What do you mean by commit and rollback?
What is the difference between db2 and oracle?
What does db2 plan contain?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the difference between drop table and delete table?
How to create db2 table in mainframe?
What is a collection in db2?
What is the picture clause of null indicator variable?