delete the historical data from DB causing SOI manager to keep re-writing same entries to the DB

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

SOI 4.2 

 

Customer needs the command to delete the historical data from DB causing SOI manager to keep re-writing same entries to the DB.

 

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

Here are the steps to clean the historical data from the DB using the soitoolbox utility.

Open a command prompt to \soi\tools\ folder

Run the following commands

soitoolbox.exe -x -t 7200 -b 7200 --cleanHistoryData=500

soitoolbox.exe -x -t 7200 -b 7200 --cleanHistoryData=400

soitoolbox.exe -x -t 7200 -b 7200 --cleanHistoryData=300

soitoolbox.exe -x -t 7200 -b 7200 --cleanHistoryData=200

soitoolbox.exe -x -t 7200 -b 7200 --cleanHistoryData=100

soitoolbox.exe -x -t 7200 -b 7200 --cleanHistoryData=50

soitoolbox.exe -x -t 7200 -b 7200 --cleanHistoryData=30