CLEANUP_PCKEYXREF

This procedure deletes records from the PC_KEY_XREF and PC_PROCESS_STAT tables based on the KeepInterval parameter setting. The following table describes the settings associated with the CLEANUP_PCKEYXREF procedure.

CLEANUP_PCKEYXREF SETTINGS

Setting Description: The oldest records to keep in the PC_KEY_XREF and PC_PROCESS_STAT tables. Default is five days.

Namespace

database.cleanup.pckeyxref

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.pckeyxref

Setting Name

MaxRowsToDelete

Default Setting

100000

Type

Numeric

Setting Description: Determines the commit interval of deleted records. Default is to issue a commit every 10000 rows.

Namespace

database.cleanup.pckeyxref

Setting Name

DeleteBatchSize

Default Setting

10000

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_USESSAUD Procedure

CLEAN_PX_DELETE Procedure

USER_DEFINED_BACKGROUND Procedure


Last Published Friday, August 8, 2025