When a utility completes successfully, it inserts a row into the BMCHIST-table. Periodically, review BMCHIST and delete old rows to control its expansion.
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';