This procedure deletes records from the PRMQUEUE table based on the value of the KeepInterval setting. The remaining settings are similar to the REFRDEL_CLEANUP.
Refer to the following table for information about the settings associated with the CLEANUP_PRMQUEUE procedure:
CLEANUP_PRMQUEUE Settings
Setting Description: The oldest records to keep in the PRMQUEUE table. Default is five days. | |
|---|---|
Namespace | database.cleanup.Prmqueue |
Setting Name | KeepInterval |
Default Setting | 5d |
Type | Interval |
Setting Description: Determines whether the procedure will delete all of the PRMQUEUE records possible on each pass. | |
Namespace | database.cleanup.Prmqueue |
Setting Name | DeleteAll |
Default Setting | 0 (false) |
Type | Boolean |
Setting Description: Determines whether all of the records are cleaned. If the total record count is less than this number then all the records are cleaned. | |
Namespace | database.cleanup.Prmqueue |
Setting Name | DeleteAllThreshold |
Default Setting | 1,000 |
Type | Numeric |
Setting Description: Percentage of records to delete on each pass. | |
Namespace | database.cleanup.Prmqueue |
Setting Name | DeletePercentage |
Default Setting | 10(%) |
Type | Numeric |
Setting Description: Maximum rows to delete on each pass. | |
Namespace | database.cleanup.Prmqueue |
Setting Name | MaxRowsToDelete |
Default Setting | 10,000 |
Type | Numeric |