Clean Up History Data

Configuring and Using Diagnostic Tools › How to Clean Up Data with the CA SOI Toolbox › Clean Up History Data

Clean Up History Data

When history data is no longer useful and you do not want to store in your database, you can clean up the history data. Maintenance of history data is important, because the history data can increase over time and can consume memory, thus adversely affecting the operation of the database. You can avoid buildup of unwanted data by cleaning up history data at regular intervals. With this command, you clean data which is older than a specified number of days. To clear unwanted history data in a database, run a cleanup command from the toolbox folder on a command prompt.

Follow these steps:

Open the toolbox with a command prompt.
Run the history cleanup command and specify the database connection password. For example, if your database connection password is yourpw, and you want to delete history data that is older than 2 days, you would run:
```
soitoolbox -p yourpw --cleanHistoryData=2
```
-p

Specifies the password. In this example, the password is yourpw.

--cleanHistoryData

Runs the command for deleting history data.

2

Specifies that only history data that is older than two days is deleted.

The toolbox confirms that it found the services, connects to the database, and warns that you selected a destructive operation.

Important! The example command assumes that your CA SOI instance runs entirely on a local system. If you are running a CA SOI instance that is not located entirely in one location, create a toolbox configuration file. For information about creating the toolbox configuration file, see Create a CA SOI Toolbox Configuration File.
When prompted, confirm the destructive operation by typing Y for Yes.
The toolbox verifies that CA SOI is running, and then asks you to stop the services before proceeding.
Confirm that you want to stop the services by typing Y for Yes.
The toolbox stops the services and then deletes all the history data in the database.
Verify that the imported connector data was deleted by running the --getStatisticalData command.
The toolbox returns information about the statistical data for the connector, confirming that the history data was deleted.

Clean Up Imported Connector Data

When a connector provides data that you do not want to store in your database, you can clean up data from the connector. To clean up imported connector data, run a cleanup command from the toolbox folder on a command prompt.

Follow these steps:

Open the toolbox with a command prompt.
Run the cleanup command with the information about the connector name location and the location of the database where the connector data is stored.
For example, if you wanted to delete data from the connector Example_con stored in a database that resides on the server server1 with the database connection password yourpw, you would run:
```
soitoolbox -p yourpw -m server1 --cleanImportedData --connector=Example_con
```
The toolbox confirms that it found the services, connects to the database, and warns that you selected a destructive operation.

Important! The example command assumes that your CA SOI instance runs entirely on a single server, server1 in this case. If you are running a CA SOI instance that is not located entirely in one location, create a toolbox configuration file. For information about creating a toolbox configuration file, see Create a CA SOI Toolbox Configuration File.

Note: If you do not know your connector name, run the --getAvailableConnectors command first.
When prompted, confirm the destructive operation by typing Y for Yes.
The toolbox verifies that SOI is running, and then asks you to stop the services before proceeding.
Confirm that you want to stop the services by typing Y for Yes.
The toolbox stops the services and then deletes the imported connector data in the database.
Verify that the imported connector data was deleted by specifying the connector name with the --connector option and running the --getStatisticalData command.
The toolbox returns information about the statistical data for the connector, confirming that the data was deleted.

Note: If you are cleaning up data from a connector that is providing incorrect data, fix the connector problems before restarting its services.