Interested to Buy Any Domain ? << Click Here >> for more details...
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
How and when does the db2 enforces the unique key?
Explain various types of locks in db2?
What does a deadlock mean in DB2?
Is db2 free?
Explain the contents that are a part of dclgen.
What is the difference between nvl and coalesce?
On which levels locks can be applied?
What does db2 plan contain?
How many databases are there?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is a cursor in programming?
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 ?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Explain how can you do the explain of a dynamic sql statement?
B37 abend during spufi?
