How can I delete an Analysis from RC/Migrator in a Batch job?

Products

• RC Compare for DB2 for z/OS

Issue/Introduction

Description:

There is a need to clean up old strategies and analyses in RC/Migrator. The method to delete strategies and analyses is available Online but a Batch method would be preferred.

Solution:

To delete strategies, there is a member in the hilvl.CDBASRC named RCMAINT. This program will generate DELETE statements for the required tables.

SQL is available to delete analyses 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);

Environment

Release:
Component: RCM