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

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

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