Cleaning up after a RECOVER UNLOADKEYS job


Successful completion of a RECOVER UNLOADKEYS job leaves rows in the BMCSYNC table with blank utility IDs for the table space partitions and the indexes for which keys are being unloaded.

If you decide not to run RECOVER BUILDINDEX after a RECOVER UNLOADKEYS, you can remove these rows with the SQL DELETE statement in Cleaning-up-RECOVER-UNLOADKEYS-entries.


 

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