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:
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 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.