Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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);

    Note

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

Related topic


Was this page helpful? Yes No Submitting... Thank you

Comments