The CLEANUP_PKXREF procedure deletes records from the PKXREF table based on the KeepInterval parameter setting. The following table describes the settings associated with the CLEANUP_PKXREF procedure.
CLEANUP_PKXREF SETTINGS
Setting Description: The oldest records to keep in the PKXREF table. Default is five days.
Namespace | database.cleanup.pkxref |
|---|---|
Setting Name | KeepInterval |
Default Setting | 5d |
Type | Interval |
Setting Description: Determines the maximum rows to delete after satisfying the KeepInterval parameter setting. Default is 10000 rows.
Namespace | database.cleanup.pkxref |
|---|---|
Setting Name | MaxRowsToDelete |
Default Setting | 100000 |
Type | Numeric |
Setting Description: Determines the commit interval of deleted records. Default is to issue a commit every 10,000 rows.
Namespace | database.cleanup.pkxref |
|---|---|
Setting Name | DeleteBatchSize |
Default Setting | 10,000 |
Type | Numeric |