Maintaining the BMCXCOPY table

Periodically, you should review BMCXCOPY and delete old rows to control its expansion.

To control expansion of the BMCXCOPY table

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:

Related topics

BMCXCOPY-table

Managing-common-utility-tables


DELETE
FROM <creatorName.CMN_BMCXCOPY
 WHERE DAYS(CURRENT TIMESTAMP) - DAYS(TIMESTAMP) > 30;

 

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