You can change the database ID that was previously 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 might be many objects that require updating, so this operation might 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.
- After you receive confirmation from all DCM administrators that all databases requiring change were updated, notify administrators that the change is complete and that they can resume DCM operations.
- Resume DCM operations from the database whose ID changed.