Archiving migration data that is no longer required

Two archiving policies related to migration import and export have been added to the application. These policies are enabled by default and purge data from the MIGRATION_ACTION and MIGRATION_DATA tables. These archiving policies delete from these tables with these conditions:

For the MIGRATION IMPORT DATA archive policy:

  • Deletes from the MIGRATION_ACTION table and the condition is MIGTYP_ID IN (3, 4, 5) AND MIGACT_PROCESS_DATE < #WBAP_AGING_DATE#
  • Deletes from the MIGRATION_DATA table and the condition is MIGDAT_ID NOT IN (SELECT MIGDAT_ID FROM MIGRATION_ACTION)

For the MIGRATION EXPORT DATA archive policy:

  • Deletes from the MIGRATION_ACTION table and the condition is MIGTYP_ID IN (1, 2, 6) AND MIGACT_PROCESS_DATE < #WBAP_AGING_DATE#
  • Deletes from the MIGRATION_DATA table and the condition is MIGDAT_ID NOT IN (SELECT MIGDAT_ID FROM MIGRATION_ACTION)