This procedure deletes records from the REFRDEL table. REFRDEL_CLEANUP runs based on the frequency of data_monitor_job, which has a default frequency of one week. Alternatively, you can run REFRDEL_CLEANUP by itself if needed.
Refer to the following table for information about the settings associated with the REFRDEL_CLEANUP procedure:
REFRDEL_CLEANUP Settings
Setting Description: Identifies the number of days that records are stored in the REFRDEL table before they can be removed. For example, the default setting keeps the REFRDEL records from the last five days. | |
---|---|
Namespace | database.cleanup.Refrdel |
Setting Name | KeepInterval |
Default Setting | 5d |
Type | Interval |
Setting Description: Identifies the number of days that are set to be removed from the REFRDEL table starting with the oldest record in the table. | |
Namespace | database.cleanup.Refrdel |
Setting Name | DaysToDelete |
Default Setting | 1 |
Type | Numeric |
Setting Description: Determines the intervals of time (in minutes) in which data is grouped and removed from the REFRDEL table. The number of IntervalSteps is equal to DaysToDelete (in minutes) divided by IntervalStep. | |
Namespace | database.cleanup.Refrdel |
Setting Name | IntervalStep |
Default Setting | 15 |
Type | Numeric |