Deleting RDBMS Repository Temporary and Historical Data
To prevent repository size increase and keep optimized performances, you should regularly delete data of the completed private workspaces of HOPEX users.
MEGA recommends that you delete all RDBMS repository temporary and historical data:
• every week for less than 10 users
• every evening if you have more than 10 users.
To delete the temporary and historical data of an RDBMS repository, you (or your database administrator) must include the following procedures in your regular maintenance tasks:
To perform these procedures, see RDBMS Repository Installation Guide deployment guide.• SP_CLEAN_MEGA_DATABASE
To consult the date of last private workspace cleanup (last execution of this procedure), see Consulting and Modifying Repository Properties.• SP_CONSOLIDATE_MEGA_DATABASE
To consult the date of last consolidation (last execution of this procedure), see Consulting and Modifying Repository Properties.