By default, data published to extended schema (PX) tables is not deleted when you delete data from P6. The CLEAN_PX_DELETE procedure cleans orphaned records from the PX tables. CLEAN_PX_DELETE runs based on the frequency of the data monitor job. Alternatively, you can run CLEAN_PX_DELETE by itself if needed.
All other settings are similar to the REFRDEL_CLEANUP procedure. The following table describes the settings associated with the CLEAN_PX_DELETE procedure.
CLEAN_PX_DELETE Settings
Setting Description: Determines the maximum amount of obsolete rows to delete from each extended schema table. Default is 100,000 rows. | ||
Namespace | database.cleanup.PxService.Cleanup | |
Setting Name | DeleteMaxSize | |
Default Setting | 100000 | |
Type | Numeric | |
Setting Description: Determines the commit interval of deleted records. Default is to issue a commit every 5,000 rows. | ||
Namespace | database.cleanup.PxService.Cleanup | |
Setting Name | DeleteBatchSize | |
Default Setting | 5000 | |
Type | Numeric | |