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.

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