Deleting RDBMS Repository Temporary and History Data

MEGA Administration : Administrator Guide : Managing Repositories : Optimizing Repository Access Performance : Deleting RDBMS Repository Temporary and History Data

To prevent repository size increase and keep optimized performances, you should regularly delete data of the completed private workspaces of MEGA users.

MEGA recommends that you delete all RDBMS repository temporary and history data:

• every week for less than 10 users

• every evening if you have more than 10 users.

To delete the temporary and history 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".