The CLEANUP_USESSAUD procedure deletes records from the USESSAUD table based on the KeepInterval parameter setting. All other settings are similar to the REFRDEL_CLEANUP procedure. The following table describes the settings associated with the CLEANUP_USESSAUD procedure.
CLEANUP_USESSAUD Settings
Setting Description: Determines the oldest records to keep in the USESSAUD table. Based on the logout time, data beyond the KeepInterval parameter value will not deleted. The KeepInterval parameter setting overrides all other CLEANUP_USESSAUD settings. | |||
---|---|---|---|
Namespace | database.cleanup.Usessaud | ||
Setting Name | KeepInterval | ||
Default Setting | 5d | ||
Type | Interval | ||
Setting Description: Deletes all the REFRDEL records that satisfy the KeepInterval setting on each pass. The DeleteAll parameter setting overrides the settings of DeleteAllThreshold, DeletePercentage, and MaxRowsToDelete parameters. | |||
Namespace | database.cleanup.Usessaud | ||
Setting Name | DeleteAll | ||
Default Setting | 0 (false) | ||
Type | Boolean | ||
Setting Description: Determines the minimum number of records to delete after satisfying the KeepInterval parameter setting. By default, a minimum of 1000 records are deleted. If the total record count is less than this setting, all records are deleted. The DeleteAllThreshold parameter setting overrides the settings of the DeletePercentage and MaxRowsToDelete parameters. | |||
Namespace | database.cleanup.Usessaud | ||
Setting Name | DeleteAllThreshold | ||
Default Setting | 1,000 | ||
Type | Numeric | ||
Setting Description: Determines the maximum rows to delete on each pass after satisfying the KeepInterval parameter setting. The MaxRowsToDelete parameter setting overrides the DeletePercentage parameter setting. | |||
Namespace | database.cleanup.Usessaud | ||
Setting Name | MaxRowsToDelete | ||
Default Setting | 10,000 | ||
Type | Numeric | ||
Setting Description: Determines the percentage of records to delete on each pass after satisfying the DeleteAllThreshold and MaxRowsToDelete settings. However, the percentage of records deleted is limited to the default value of the MaxRowsToDelete setting. | |||
Namespace | database.cleanup.Usessaud | ||
Setting Name | DeletePercentage | ||
Default Setting | 10 (%) | ||
Type | Numeric |