Cleaning up the BMCUTIL and BMCSYNC tables


If an

Some content is unavailable due to permissions.

job fails and you do not plan to restart it, you must clean up the BMCUTIL and BMCSYNC tables and reset the space status before running any more BMC utilities against the space.

We recommend that you specify TERM/RESET for the restart parameter in the EXEC statement in the

Some content is unavailable due to permissions.

JCL and submit the job for execution. For more information, see Utility-parameters-on-the-EXEC-statement.

For copy jobs, if the original job failed in the COPY phase with the FULL YES and RESETMOD YES options specified for table spaces,

Some content is unavailable due to permissions.

also does the following things:

  • Puts a T entry in the ICTYPE column of SYSIBM.SYSCOPY to prohibit incremental copying until a full copy is successfully made.
  • For special case table spaces,

    Some content is unavailable due to permissions.

    issues a Db2 -TERM UTILITY command.

    Important

    Specifying TERM/RESET will also terminate XBM caching for restartable Snapshot Copies.

Subject to the warnings that follow, you can also clean up the BMCUTIL and BMCSYNC tables with

Some content is unavailable due to permissions.

. If you have installed

Some content is unavailable due to permissions.

you can issue the BMCUTIL TERM command within that product. For more information, see  BMC AMI Catalog Manager for Db2 documentation.

Warning

Be aware of the following situations:

  • If

    Some content is unavailable due to permissions.

    changed the space status, you must manually reset it with the Db2 -START command.
  • If a copy job was terminated in the COPY phase and it was specified using FULL YES and RESETMOD YES for table spaces, page-modification indicators might be partially reset. The next copy must be specified using FULL YES before making any more incremental copies because an incremental copy could not identify all changed pages.
  • To terminate and clean up following a failed Snapshot Copy (an XBM supported copy), run

    Some content is unavailable due to permissions.

    with the TERM/RESET option (Restart parameter (restartParm)).
  • If the space was in COPY-pending status,

    Some content is unavailable due to permissions.

    might have reset the status, so make a copy before updates.
  • XBM caching for restartable Snapshot Copies will not be terminated. You must terminate the caching through XBM. For restartable Snapshot Copies, you must be using XBM.


 

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