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 a db2 schema?
How is a typical db2 batch pgm executed?
Mention the location where the output received from explain statement is stored.
What is concurrency?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How can you count the number of rows from a table tab?
What is package in cobol db2?
How do we specify index to include or not during bind process.
What is the physical storage length of time data type?
What is plan in cobol db2?
Is db2 a mainframe?
Define db2 and its databases?
Explain correlated sub-queries.
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is a system catalog table in db2?