DB2 Change Management Expert overview

DB2® Change Management Expert is a powerful and flexible tool that simplifies the process of identifying, analyzing, and implementing database schema changes for DB2 UDB for Linux®, UNIX, and Windows®.
DB2 Change Management Expert simplifies the process of managing schema changes. You can use DB2 Change Management Expert to visualize your changes before you make them.
Figure 1. Simplifying database changes with DB2 Change Management ExpertDB2 Change Management Expert simplifies the change process by allowing you to visualize your changes before you deploy them to the DB2 database.

You can use DB2 Change Management Expert to apply change commands to physical data models, which enables you to see the results of the change commands before you deploy the changes against the actual DB2 database. Applying a change command to a model is similar to issuing a command against DB2.

DB2 Change Management Expert helps solve or alleviate many of the problems that a DBA faces:

Table 1. Problems that DB2 Change Management Expert helps solve
Typical DBA problem DB2 Change Management Expert solution and value
Failing to recognize a schema change can be dangerous to system integrity. Provides an internal model of database dependencies to enable the DBA to fully understand the effects of the changes before they are made.
Finding all related schema change elements is difficult. Displays related schema changes to help the DBA better understand the change. Finding schema changes is a difficult task to perform manually. This feature saves time.
Analyzing the impact of a schema change is time consuming. Aggregates summary information and allows the DBA to drill down into the model. This feature enables the DBA to fully understand the issues that relate to impact and migration.
Planning the migration requires deep consideration. Visualization capabilities such as graphical compare, graphical dependency viewing, SQL source text formatting, and context-sensitive help. These capabilities allow the DBA to see exactly how a change will affect a database.
Applying changes to a database necessitates expert precision. Finding which objects will be affected by a change is difficult and time consuming. DB2 Change Management Expert makes the process easier by automatically propagating changes. Automatically propagating changes also increases reliability and reduces human error when analyzing, migrating, and issuing changes to the database schema.
DB2 Change Management Expert provides the following features:

DB2 Change Management Expert can also manage database objects in an Enterprise Server Edition (ESE) and Database Partitioning Feature (DPF) environment. However, DB2 Change Management Expert does not change manage DPF objects or configurations.


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.