purge commands for SOI Manager

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

How to use the purge commands  for SOI Manager

Environment

Release : 4.2

Component : CATALYST CONNECTOR FOR UIM

Resolution

 

We strongly recommend to clean up old data from SOI Database as you haven't performed DB maintenance activity from past 2 years

 

Here is the procedure to purge older data from SAMStore, make sure run this procedure 2 times per month to keep DB healthy.

1) soitoolbox.exe --machine=<DB Host> --dbName=SAMStore --dbUsername=sa --dbPassword=<sa password> --purgeClearedAlerts 365

2) soitoolbox.exe --machine=<DB Host> --dbName=SAMStore --dbUsername=sa --dbPassword=<sa password> --cleanHistoryData 365

Note: The above 2 commands purge older data from various tables in SAMStore Db older than 365 days, you may adjust this number of days value accordingly