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);