CLEAN_PX_DELETE Procedure

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

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

PxService.Cleanup

Setting Name

DeleteBatchSize

Default Setting

5000

Type

Numeric

Related Topics

DAMON (Data Monitor) Procedures

BGPLOG_CLEANUP Procedure

CLEANUP_DBERRLOG Procedure

REFRDEL_CLEANUP Procedure

REFRDEL Bypass Procedure

CLEANUP_PRMQUEUE Procedure

USESSION_CLEAR_LOGICAL_DELETES Procedure

CLEANUP_LOGICAL_DELETES Procedure

PAUDIT_CLEANUP Procedure

CLEANUP_PKXREF

CLEANUP_PCKEYXREF

CLEANUP_USESSAUD Procedure

USER_DEFINED_BACKGROUND Procedure


Last Published Friday, August 8, 2025