About this task
This feature is useful when you need to
change the database ID that has previously been used and update all
the objects that were created in that database to reflect the new
database ID.
Note: If a database is a member of an
existing DCM cluster, changing its database ID can adversely affect
other databases in the cluster.
In databases
in which many objects have been created, there could be many objects
that require updating, so this operation could take some time. It
is vital that the new database ID is unique in the DCM cluster. Verify
that the database ID is unique and that you ensure you have a valid
backup of the database before proceeding.
Changing
a database ID can have an impact on the work area paths for projects
in that database
All DCM administrators of a cluster must
be informed when the ID of one of the databases in the cluster
is to be changed. DCM does not automatically notify DCM administrators
of the change.
The steps to perform a change of
database ID and update objects are:
- Notify all DCM administrators of the intended change
of database ID and coordinate a good time to perform the change.
- Suspend DCM operations in the database whose ID
is being changed and all other databases that have received objects
from that database.
- In the database to be changed, use the Change
database ID and update affected objects option.
- In all other databases in the DCM cluster that possibly
received objects from the database whose ID has changed, use the Convert
the database ID of objects created in another database option.
Coordinate with remote administrators who perform this operation on
the databases at their location.
- In all other databases, change the database ID in
the DCM database definition for that database. Coordinate with remote
administrators who perform this operation on the databases at their
location.
- When you have received confirmation from all DCM
administrators that all databases requiring change have been updated,
notify all administrators that the change is complete and that they
can resume DCM operations.
- Resume DCM operations from the database whose ID
has been changed.