Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Copy for Db2 13.1.

Maintaining the BMCDICT table

If LOADPLUS or REORG PLUS abends during the time between building the compression dictionary and completing compression, rows might remain in the BMCDICT table.

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

To control expansion of the BMCDICT table

  1. Delete any rows in the BMCUTIL table that you know are no longer valid.Do not delete any rows for instances of utilities that are awaiting restart.

  2. Use the following SQL statement to delete rows from the BMCDICT table:

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

    Important

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

Related topics

Common-utility-tables

BMCDICT-table

Managing-common-utility-tables

 

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