Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is COPY PENDING status?

asked mar August 3, 2014 04:50 AM  

What is COPY PENDING status?


1 Answers

answered By Mswami   0  
A state in which, an image copy on a table needs to be taken,  In this status, the table is available only for queries. You cannot update this table. To remove the COPY PENDING status, you take an image copy or use REPAIR utility.

COPY-pending status:

The COPY-pending (COPY) restrictive status indicates that the affected object must be copied.

DB2 ignores informational referential integrity constraints and does not set CHECK-pending status for them.

Refer to the following table for information about resetting the COPY-pending status. This table lists the status name, abbreviation, affected objects, and any corrective actions.

Resetting COPY-pending status
StatusAbbreviationObject affectedCorrective actionNotes
COPY-pendingCOPYTable space, table space partitionTake an image copy of the affected object. 
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  1 person following this tag

  Question tags

Asked 2 years and 3 months ago ago
Number of Views -299
Number of Answers -1
Last updated
3 years and 4 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!