How to delete old strategies and analysis from RC/Migrator in a Batch job

Products

• RC/Migrator for DB2 for z/OS
• RC Compare for DB2 for z/OS

Issue/Introduction

There is a need to clean up old strategies and analyses in RC/Migrator for Db2 for z/OS (RCM).
The method to delete strategies and analyses is available Online but a Batch method would be preferred.

Resolution

To delete strategies, there is a member in the hlq.CDBAJCL named RCMMAINT. This program will generate DELETE statements for the required tables.

SQL is available to delete analysis information and this SQL can be placed in a JCL member to run in batch.

 DELETE FROM PTI.PTMG1_STRAT_0200
 WHERE STRATEGY_NAME = xxxxxxxx       <===== replace with the specific strategy name 
 AND STRATEGY_CREATOR = xxxxxxxx      <===== replace with the strategy Creator
 AND INTERNAL_TYPE IN (4, 5, 9);