Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Copy for Db2 13.1.

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.


Related topics

Common-utility-tables

BMCXCOPY-table

Managing-common-utility-tables


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Copy for Db2 12.1