Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

Maintaining the BMCXCOPY table

Periodically, you should review BMCXCOPY table and delete old rows to control its expansion. To delete all rows from the BMCXCOPY table that are older than 30 days, use the following statement as an example:

Related topic

Maintaining 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*

CHECK PLUS for DB2 13.1