Overview of managing changes to a database

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
The steps required to manage changes to a database are change specification, deployment, and auditing.
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.


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.