REFRDEL_CLEANUP Procedure

This procedure deletes records from the REFRDEL table. REFRDEL_CLEANUP runs based on the frequency of the 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

REFRDEL_CLEANUP Settings

Related Topics