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
What is package in db2 mainframe?
what is db2 restart?
What is check constraint in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is table space in db2?
Which command is used to remove all rows from a table?
What is the difference between drop table and delete table?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What are bind parameters in db2?
What is db2 plan table?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Mention data types used in db2 ?
Explain the benefits you can get from mainframe connect?
What is dclgen in db2?
How to find schema of a table in db2?