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.On an exceptional basis, with HOPEX you can perform these deletion tasks on several repositories in one action. This possibility enables you to mass launch these procedures on all the repositories with no need to validate the execution for each repository.
See:
Mass deleting temporary data of private workspace
To mass delete private workspace temporary data:
1. Connect to HOPEX Administration and select the environment concerned.
2. Expand the environment folder.
3. Right-click the Repositories folder and select Manage.
4. In the Action list pane, select Private workspace temporary data deletion.
To mass delete repository historical data, select also Repository historical data deletion.5. In the Repository list pane, select the repositories for which you want to delete temporary data.
6. Click Execute.
The cleaning is automatically launched on each repository selected with no need to validate each execution.
A dialog box enables you to stop the procedure at any time. If needed, click Stop to stop the procedure execution.Private workspace temporary data is deleted on all the selected repositories.
If you selected the option, repository historical data is also deleted on all the selected repositories.Mass deleting repository historical data
To mass delete historical data:
1. Connect to HOPEX Administration and select the environment concerned.
2. Expand the environment folder.
3. Right-click the Repositories folder and select Manage.
4. In the Action list pane, select Repository historical data deletion.
To mass delete repository historical data, select also Repository historical data deletion.5. In the Repository list pane, select the repositories for which you want to delete repository historical data.
6. Click Execute.
The consolidation procedure is automatically launched on each repository selected with no need to validate each execution.
A dialog box enables you to stop the procedure at any time. If needed, click Stop to stop the procedure execution.Repository historical data is deleted on all the selected repositories.
If you selected the option, private workspace temporary data is also deleted on all the selected repositories.