CLEANUP_PKXREF

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

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_PCKEYXREF

CLEANUP_USESSAUD Procedure

CLEAN_PX_DELETE Procedure

USER_DEFINED_BACKGROUND Procedure


Last Published Thursday, October 3, 2024