Managing Base Databases

Purpose

Follow this procedure to assign a base database to a network node. This assignment may be used by Serena Dimensions Replicator to transfer objects between remote Dimensions CM repositories.

NOTE  If you are using Serena Dimensions Replicator, then you need to ensure that not only are the base databases that you are replicating to are correctly registered, but also that the base database which you are logged into is correctly registered too. In addition, if the PCMS_SYS database was imported from another database, then the data in pcms_sys.pcms_db_details may need the column db_name updating (to NODENAME-DBCONN) before doing replication administration.

After assigning a base database to a node, you can edit it or unassign it from the node if necessary.

To assign a base database:

1. From the Network Administration main window, click the Network Nodes tab.

2. Select the network node to which you want to assign the base database.

3. Click the Add button:  in the Base Database section. The New/Edit Base Database Dialog Box appears.

4. Enter the name of the base database in the Base Database Name field.

5. Select or enter the name of the network instance in the DB Connection String field.

6. Enter the Dimensions CM version number in the Dimensions Release Version field.

7. If this node is to be included in request replications between sites, you will need to make sure that the site number is unique and consistent across all the sites involved in the replication. This is controlled by the Site No field.

8. Optionally, complete the rest of the fields in the dialog box.

9. Click OK to add the base database to the node.

To edit or unassign a base database:

1. Select the node to which the base database is assigned.

2. Select the base database from the Base Database section.

3. Do one of the following:

• Click the Edit button:  and modify the details of the New/Edit Base Database Dialog Box as necessary.

• Click the Deassign button:  and confirm that you want to unassign the base database from the node. If Replication Enabled was checked, you will have to first uncheck it by using the Edit button before you can successfully use the Deassign button.