The three most important tasks that a DBA can perform with DB2® Change Management Expert are change specification,
deployment, and auditing.
The following figure depicts the sequence of steps that are required to
manage changes to a database:
Figure 1. Steps required to manage changes
- Change specification
- The process of defining a set of changes that you want to apply to a database.
This phase involves creating models of the database that you want to change
and using the models to define the changes, analyze the impact of the changes,
and generate the operations to implement the changes against the database.
- Deployment
- The process of changing the database to reflect the conditions that were
specified in the model specification phase. Deployment encompasses the process
of applying the changes to the actual database, and if necessary, undoing
the changes.
- Auditing
- The process of looking back after a change is made to understand the evolution
of the database model. This phase is important because the catalog reflects
only the current state of a database and does not keep a record of its history.
Auditing helps you keep track of who performed what actions and helps you
to prevent unknown or unanticipated access to the data.