These tables needs to be cleared on a regular basis by F10 in MHS850 and MMS800 

Keep the required number of days of data by setting up MMS865 for the partner.


 

Filed records will appear in MHS890, MMS890.

This maintenance should be done on a regular basis to keep the performance of the warehouse integration interfaces.

Note: There is no program to schedule so this needs to be part of a manual maintenance schedule

MHS090 – Delete download data

This program should be scheduled if any of the below programs are populated

 

With the partner set up for WA (this relates to inbound messages so often we do not need these files populated when running warehouse action)


Note: If we are using the MA BI reports provided we often rely on the staging tables so instead of 30 days it may be better to keep 180 or even up to 365 days of history.