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
Outputs of explain are with matchcols = 0. What does this signify?
What are the prerogatives?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is phantom read in db2?
What is the difference between drop table and delete table?
Explain packages.
How does db2 sample database connect?
What is the difference between db2 and oracle?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What do you mean by commit and rollback?
What is query_cache_limit?
How to check last update on table in db2?
What is commit in db2?
How do you find the maximum value in a column in db2?
What is netezza database?