Default language.

Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Maintaining the BMCXCOPY table


Periodically, you should review BMCXCOPY and delete old rows to control its expansion. To control the 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: 

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*

REORG PLUS for DB2 13.1