3.2.5 Periodically deleting SSO collection data

The amount of data in the SSO collection database monotonically increases because the database does not have a retention period. Thus, as SSO continues to collect data and the size of the database increases, the collection or deletion performance of the database might decrease significantly. For this reason, we recommend that you periodically back up the database or delete collection data to maintain the performance of the collection database. Set the retention period of the collection data to a maximum of one year.

Procedure

1. Execute the ssodbdel command.

   The following shows an execution example of the command to delete collection data for which the retention period has expired:

   ssodbdel -all -stop BMONTH 13

   When you execute this command, of the data in the collection database, data for which the retention period (of one year) has expired is deleted. If you execute this command on the first day of every month, the collection database will store data only for about one year.

To Page Top