Change Management (CM)

The Change Management (CM) function in Db2 Admin Tool simplifies the process of recording and tracking the changes that you make to your Db2 objects. CM assigns a change ID for every change that you make to your Db2 objects and registers each change in the Change Management database.

CM provides the following features:
  • Enables you to analyze how a change affects existing objects.
  • Warns you if any pending changes exist on the same object that you plan to change. You can then specify whether your change should supersede or follow the pending changes.
  • Allows you to define new changes as if any pending changes have already been made.
  • Facilitates the generation of new versions to provide a snapshot of your database definitions after changes have been made.
  • Provides an interface that allows you to track and query changes to objects and quickly find all of the components that are involved in a change.
  • Provides an audit trail and helps automate the process of recovering changes.
  • Maintains the relationships between changes, versions, masks, ignores, generated DDL, and unloaded data.
  • Facilitates moving changes from one Db2 subsystem to another.
You can make changes by using the following features in Db2 Admin Tool or Db2 Object Comparison Tool:
  • SQL CREATE, ALTER, DROP, RENAME, COMMENT, and LABEL statements that are executed from the input screen or from a data set
  • SQL REVOKE statements that are executed from the input screen or from a data set as immediate changes
  • The AL line command to change or rename a database
  • The AL line command or ALT command to change a table space or index space
  • The AL line command or ALT line command to change a table
  • Comparisons in which changes are made to synchronize the target system with the source system
  • Changes that are defined through the Change Management panels
Restriction: The GRANT USAGE ON JAR statement is not supported in CHANGE MANAGEMENT or in the Db2 Object Comparison Tool.