Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

Using scripting tools to automate change management

The CM/PILOT component of the BMC AMI Change Manager for Db2 product enables you to quickly and easily utilize the vast change management power of Change Manager.

By following the panels that are provided in the CM/PILOT component’s scripts or in a script that you create, you can specify, analyze, and execute a worklist to accomplish the following tasks:

  • Change data structures
  • Migrate data structures
  • Receive data structures
  • Receive DDL to create data structures
  • Create full-recovery baselines
  • Recover data structures with current or old data
  • Create a user-defined script
  • Replicate work IDs

CM/PILOT accomplishes these tasks by using the following features:

  • Task IDs, which are units of work with unique identifiers
  • Worklists, which are data sets that contain commands for Change Manager components and information that is provided through a dialog
  • Scripts, which are dialogs that enable you to combine various Change Manager functions into one job

  • Data Manipulation Language (DML), which is an SQL-like language that is used by CM/PILOT to update, delete, and migrate data structures

    DML uses syntax that is slightly different than Db2 DML. For information about the DML used by CM/PILOT, see Command-and-syntax-reference.

  • Applications, which are sets of Change Manager profiles that can be used repeatedly for the change management tasks of a specific Db2 application

When you want to perform a change management task, CM/PILOT takes care of the processes that Change Manager will use and ensures that they are performed in the correct sequence. CM/PILOT enables you to set forth tasks that can be performed later by some one else or through job scheduling. By reusing the task ID, you can ensure that the change management task is performed the same way every time.

When you use CM/PILOT, you can easily prepare for various Change Manager tasks that can be processed on demand. The CM/PILOT dialog is task-oriented and easy to use. It describes the change management tasks that can be performed and directs you to provide information for preparing worklists that can be processed at any time.

This section discusses each of the preceding features (with the exception of DML) and how you can use them. Tasks for using the CM/PILOT component to perform a specific change management function are described in the appropriate sections of this space.

GUID-47E5A770-A760-442A-9F5A-06872981813D-low.png

For more information, view the Quick Course CM/PILOT Overview.

This section contains the following topics:

 

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