Maintaining the BMCSYNC table

When a utility abends, rows might remain in the BMCSYNC table. On rare occasions, you might need to take action to control expansion of the BMCSYNC table.

To control expansion of the BMCSYNC table

Use one of the following methods to delete rows in the BMCSYNC 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 from 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.