Set up a scheduled task to perform database maintenance.

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

How can we set up an automatic task to clean the SOI db?

Environment

SOI 4.2

Cause

SOI uses MS-SQl and a database and like all data bases, they should be maintained and tuned:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/service-operations-insight/4-2/administrating/database-maintenance.html

 

Resolution

Here are the steps for setting up a scheduled task to perform database maintenance:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/service-operations-insight/4-2/administrating/database-maintenance/task-scheduler-for-soitoolbox-utility.html

 

SOIToolbox options that would not require shutting down SOI Services:

 

soitoolbox.exe -x -q -s --purgeClearedAlerts=365

soitoolbox.exe -x -q -s --cleanHistoryData=365

soitoolbox.exe -x -q -s --purgeOutageAlerts

soitoolbox.exe -x -q -s --purgeAlertQueueAssignment

soitoolbox.exe -x -q -s --rebuildIndexes

 

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/service-operations-insight/4-2/administrating/database-maintenance/how-to-clean-up-data-with-the-ca-soi-toolbox.html