Maintaining the BMCHIST table
When a utility completes successfully, it inserts a row into the BMCHIST table. You can control 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 completed, use the following sample SQL statement:
DELETE
FROM <creatorName>.CMN_BMCHIST
WHERE DATE < 'yyyy-mm-dd';
FROM <creatorName>.CMN_BMCHIST
WHERE DATE < 'yyyy-mm-dd';
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*