REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space. It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented.
Imagecopy is full backup of a DB2 table which can be used in recovery.
we will use To take routine backup of tables
And after a LOAD with LOG NO
Also after REORG with LOG NO
COPY PENDING status is a state in which, an image copy on a table needs to be taken, In this status, the table is available only for queries. We cannot update this table. To remove the COPY PENDING status, we need to take an image copy or use REPAIR utility.
When a table is LOADed with ENFORCE NO option, then the table is left in CHECK PENDING status. This means that the LOAD utility did not perform constraint checking.
|
|
||||||||||||||||||||||||||||
