Example 27: Using XCOPYDEL option with MODIFY to remove orphaned rows from BMCXCOPY

Use MODIFY with OPTION XCOPYDEL LIST to display orphaned rows in BMCXCOPY. Orphaned rows are entries that exist in BMCXCOPY but represent objects that have been dropped from the IBM Db2 catalog. To delete the orphaned rows, change OPTION XCOPYDEL LIST to OPTION XCOPYDEL YES.

Related topic

Examples-of-BMC-AMI-Copy-jobs

The XCOPYDEL option works in conjunction with the MODIFY command, so there must be at least one valid MODIFY command for XCOPYDEL processing to occur.

To specify XCOPYDEL YES on the MODIFY command

//ACPEX27  JOB (PACP),'EXAMPLE 27',CLASS=Q,MSGCLASS=X,NOTIFY=&SYSUID    
//**********************************************************************
//*                                                                     
//* Use MODIFY with OPTION XCOPYDEL LIST to *display* orphaned rows     
//* in BMCXCOPY.  Orphaned rows are entries that exist in BMCXCOPY      
//* but represent objects that have been dropped from the IBM Db2       
//* catalog.                                                            
//*                                                                     
//* Change XCOPYDEL LIST to XCOPYDEL YES to *delete* the orphaned rows  
//* from BMCXCOPY.                                                      
//*                                                                     
//* Note: The XCOPYDEL option works in conjunction with the MODIFY      
//*       command, so there must be at least one valid MODIFY command   
//*       for XCOPYDEL processing to occur.                             
//*                                                                     
//**********************************************************************
//BMCCOPY  EXEC PGM=ACPMAIN,REGION=0M,                                  
//         PARM='DEJM,ACPEX27,NEW/RESET,MSGLEVEL(1)'                  
//STEPLIB  DD DSN=DB2QA.INST1210.BMCLINK,DISP=SHR                               
//         DD DSN=DB2QA.INST1210.UBMCLINK,DISP=SHR                              
//         DD DSN=DB2QA.INST1210.BMCPSWD,DISP=SHR                               
//         DD DSN=CSG.DEJM.DSNEXIT,DISP=SHR                                     
//         DD DSN=CSGI.DB2V12M.DSNLOAD,DISP=SHR                                 
//ACPERROR DD SYSOUT=*                                                  
//SYSPRINT DD SYSOUT=*                                                  
//SYSIN    DD *                                                         
                                                                       
  OPTIONS                                                               
    XCOPYDEL LIST         -- DISPLAY OBSOLETE BMCXCOPY ROWS             
                          --   WHEN MODIFY RUNS                         
                                                                       
  MODIFY                  -- RUN MODIFY                                 
    TABLESPACE ACPEXDB1.* --   FOR THESE TABLE SPACES                   
      DELETE              --   DELETE RECOVERY DATA THAT IS NOT NEEDED  
        MAXRECDAYS 30     --   FOR RECOVERY TO A POINT IN LAST 30 DAYS  
      ANALYZE YES         -- DISPLAY DATA TO DELETE WITHOUT DELETING  


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*