DROP TARGET OBJECTS NOT ON THE SOURCE

Document ID : KB000019509
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Doing a Compare strategy, a user would like to drop all the objects on the target that are not on the source subsystem.

Solution:

After the objects are mapped, on the RC/M Compare Explode Services screen you will want to change the E option to X. This will display the RC/M All Type Exclude Options screen. This will provide a list of the object types available for dropping.


PRIMARY OBJECT PAIR:                                                     
   SOURCE DATABASE ===> DPWSTA01        TARGET DATABASE ===> DLWSTA01   
   SOURCE CREATOR  ===> @DB2ADM  >      TARGET CREATOR  ===> @DBLWDBA   
---------------------------------------------------------------------    
EXCLUDE DEPENDENT OBJECTS:                                               
   A - exclude all unmatched dependent objects of this type             
   S - display a selectable list of unmatched dependent objects         
                                                                        
   SOURCE TABLESPACES ===> _            TARGET TABLESPACES ===> s       
   SOURCE TABLES      ===> _            TARGET TABLES      ===> _       
   SOURCE INDEXES     ===> _            TARGET INDEXES     ===> _       
   SOURCE VIEWS       ===> _            TARGET VIEWS       ===> _       
   SOURCE SYNONYMS    ===> _            TARGET SYNONYMS    ===> _       
   SOURCE ALIASES     ===> _            TARGET ALIASES     ===> _       
   SOURCE TRIGGERS    ===> _            TARGET TRIGGERS    ===> _   

Place an S by Target Tablespaces it will display a list of available tablespaces to drop on the RC/M Exclude Target Tablespaces screen. You then have the option to exclude the tablespaces you want dropped by using the X option next to the tablespace name.