Maintaining the BMCHIST table

When a utility completes successfully, it inserts a row into the BMCHIST table. You can control the expansion of this table by deleting old rows. If you use REORG PLUS, you can also control inserts into the BMCHIST table.

To delete old rows from the BMCHIST table

To delete selected rows from the BMCHIST table based on the date that the utility was completed, use the following sample SQL statement:

DELETE
FROM <creatorName>.CMN_BMCHIST  
 WHERE DATE < 'yyyy-mm-dd';

Related topics

Common-utility-tables

BMCHIST-table

Managing-common-utility-tables

To control inserts into the BMCHIST table (REORG PLUS only)

Use the TERMEXIT option to specify a user exit that controls inserts into the BMCHIST table.

 

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