DB2 COPY PENDING (COPY) restrictive status indicates that the affected object must be copied.
Following jobs remove copy pending and recovery pending status from a tablespace and removes copy pending, recovery pending status, and rebuild pending status from an index space
//STEPO1 EXEC PGM=DSNUTILB,REGIONM, // PARM='DB2X,MIGRDAN, ' //STEPLIB DD DSN=XXX.XXXXX.SDSNLOAD,DISP=SHR //SYSIN DD * REPAIR SET TABLESPACE XXXXX.XXXXX NOCOPYPEND REPAIR SET TABLESPACE XXXXX.XXXXX NORCVRPEND REPAIR SET INDEX XXXXX.XXXXX NOCOPYPEND REPAIR SET INDEX XXXXX.XXXXX NORCVRPEND REPAIR SET INDEX XXXXX.XXXXX NORBDPEND /* //SYSPRINT DD SYSOUT=* //UTPRINT DD SYSOUT=*
The COPY online utility creates up to four image copies of any of the following
objects: table space, table space partition, data set of linear table space, index
space, or index space partition.
The two types of image copies are:
The RECOVER utility uses these copies when recovering a table space or index
space to the most recent time or to a previous time. Copies can also be used by the
MERGECOPY, RECOVER, COPYTOCOPY, and UNLOAD utilities.
Optimize Outer Join queries is a powerful tool for retrieving data from multiple tables. However,…
OUTER JOIN Queries are a valuable tool in SQL, allowing you to retrieve data from…
Mastering impediments is crucial to the Scrum Master's role in fostering a high-performing Scrum Team.…
A Sprint Goal is a short, clear, and motivating target the Scrum Team aims to…
Context switching refers to changing focus or shifting attention from one task or activity to…
Embracing change is never easy, especially when it involves a shift in work methodology. Motivate…