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 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>';

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.

Related topic


Was this page helpful? Yes No Submitting... Thank you

Comments