Cleaning up RECOVER UNLOADKEYS entries

Successful completion of a RECOVER UNLOADKEYS job leaves rows in BMCSYNC with blank utility IDs for table space partitions and indexes related to the unloaded keys. The table space rows prevent other BMC utilities from obtaining exclusive control of the table space.

Related topics

BMCSYNC-table

Managing-common-utility-tables

To clean up RECOVER UNLOADKEYS entries

Use one of the following methods to remove the invalid BMCSYNC rows:

  • Run a RECOVER BUILDINDEX job.

  • Run a job that uses the following statement for the table space and each index:

    DELETE FROM <creatorName>.CMN_BMCSYNC
       WHERE UTILID=' '
           AND NAME1='<databaseName>'
           AND NAME2='<spaceName>'
           AND UTILNAME='RECOVER';

 

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