Using utilities with ALTER and Change Manager

The Front End of the ALTER and 

BMC AMI Change Manager for Db2

 products generates keywords in the ALUIN input stream. Using the ALUIN input stream, the Analysis component generates utility commands in the worklist.

These keywords and commands perform the following functions:

  • Unload and load data
  • Check referential constraint violations
  • Reorganize table spaces and indexes
  • Create image copies
  • Generate and update catalog statistics

You can use the BMC utilities or the IBM utilities to perform these functions. If you select a utility to use, that utility must be installed.

Important

If the DDL for a table space or an index sets DEFINE to NO, Change Manager does not use the utilities to perform any of the preceding functions.

This section contains the following topics:

 

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