Configuring and Using Diagnostic Tools › CA SOI Toolbox Utility › Database Cleanup Commands

Database Cleanup Commands

You can use the following commands to clean up the data in a CA SOI database.

--archiveHistoryData

Moves all historical data older than a specified number of days to an archive database.

Note: You specify the number of days by adding a number to the end of the command, for example --archiveHistoryData=10.

Note: The default name for the archive database is SOIArchiveDB. You can change the name of the archive database with the --dbArchiveName command.

--cleanHistoryData

Deletes all the historical data from the CA SOI database that is older than a specified number of days.

Note: You specify the number of days by adding a number to the end of the command which specifies the number of days.

--cleanImportedData

Deletes all the data that came from connectors that you specify in the --connector parameter.

Note: This command does not delete data that users create manually.

--cleanSecurityData

Deletes all service access rights that are set for specific users and groups within the CA SOI instance.

--cleanData

Deletes all history data, imported data, and security data for all the connectors in a CA SOI instance.

--purgeClearedAlerts

Deletes cleared alerts from the database that are older than a specified number of days. You can specify two different purge types, :full or :strict, by adding full or strict to the end of the command:

:full

Deletes all alerts that are cleared in at least one system.

:strict

Deletes only those alerts which are cleared in all systems.

--rebuildIndexes

Rebuilds database indexes.

--reinitializeDB

Clears the whole CA SOI database, deleting the data from all the tables.

Note: You can use this command to start with a clean state similar to that of a new installation.

--restoreHistoryData

Restores from the archive database all archived historical data that are not older than the specified number of days.

Note: You specify the number of days by adding a number to the end of the command, for example --restoreHistoryData=10.