Maintaining the BMCUTIL and BMCUTIL2 tables

When a utility abends, unwanted rows might remain in the BMCUTIL and BMCUTIL2 tables. 

On rare occasions, you might need to take action to control the expansion of the BMCUTIL and BMCUTIL2 tables.

To control the expansion of the BMCUTIL and BMCUTIL2 tables

Use one of the following methods to delete rows from the BMCUTIL and BMCUTIL2 tables:

• Use the TERM restart parameter on the EXEC statement to delete rows from the BMCUTIL, BMCUTIL2, and BMCSYNC tables. Do not delete any rows for instances of utilities that are awaiting restart.

• Manually delete invalid rows from the BMCUTIL2 and BMCSYNC tables. Do not delete any rows for instances of utilities that are awaiting restart. Then use the following SQL statements to delete invalid rows from the BMCUTIL2 and BMCSYNC tables:

  DELETE
  FROM <creatorName>.CMN_BMCUTIL2
   WHERE UTILID NOT IN
    (SELECT UTILID FROM <creatorName>.CMN_BMCUTIL);

  DELETE
  FROM <creatorName>.CMN_BMCSYNC
   WHERE UTILID NOT IN
    (SELECT UTILID FROM <creatorName>.CMN_BMCUTIL);

  Important

  The names of the BMCUTIL, BMCUTIL2, and BMCSYNC tables might have been changed at your site during installation.