Answer Posted / thiruvenkata varaga moorthy
After a Bulk Load of the Table or Table Space by means of a
DB2 Load Utility, we need to go for an Image Copy so as to
restore the system in case of some unexpected situations.
Generally, DB2 system itself will expect such an imagecopy
and will prompt the message in the output saying 'Image
Copy Required', 'Table Space Remains in Copy Pending State'.
It is upto the wish of the programmer either to go for an
Image Copy or to cancel the Copy Pend state by means of the
Repair set.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What is clone table?
Define sqlca.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a db2 cursor?
When do you specify the isolation level?
Explain about cursor stability?
What is scrollable cursor in db2?
Is it possible using max on a char column?
How to test SQL -911 error while developing COB-DB2 program
What is a cursor in programming?
What are the various data types available in db2?
What is access path in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the syntax for creating a table in the db2 database?
Why cursor is used in db2?