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 the 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.

Related topics

Common-utility-tables

BMCSYNC-table

Managing-common-utility-tables

  • 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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*