Maintaining the BMCUTIL table

When a utility abends, rows might remain in the BMCUTIL table.

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

To control expansion of the BMCUTIL table

Use one of the following methods to delete rows from the BMCUTIL table:

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

• Delete invalid rows in the BMCUTIL table. Do not delete any rows for instances of utilities that are awaiting restart.

  Then use the following SQL statement to delete rows from the BMCSYNC table:

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

  Important

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