Maintaining BMCUTIL and BMCSYNC tables

When a product abends, unwanted rows might remain in the BMCUTIL and BMCSYNC tables.

If you need to control expansion of these tables, use one of the following methods to delete rows:

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

• Delete invalid rows in the BMCUTIL table. Do not delete any rows for instances of utilities that are awaiting restart or executing.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);

  Warning

  Important

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