Maintaining the BMCXCOPY table

Control table expansion by reviewing BMCXCOPY periodically and deleting old rows and orphaned rows.

To control expansion of the BMCXCOPY table

1. To delete all rows from the BMCXCOPY table that are older than 30 days, run an SQL DELETE statement, using the following statement as an example:

   DELETE
   FROM <creatorName>.CMN_BMCXCOPY
    WHERE DAYS(CURRENT TIMESTAMP) - DAYS(TIMESTAMP) > 30;
2. To delete orphaned rows from the BMCXCOPY table, use the XCOPYDEL option on a MODIFY job.
   For more information, see OPTIONS-syntax-option-description.