Renaming or moving databases for Windows and Informix

You can move (or rename) a database to use the database on a different machine or a different drive, or to duplicate a database for use elsewhere. Use the ccmdb copy command to rename or move a database from one location to another. You can copy a pack file from UNIX to Windows but not from Windows to UNIX.

Database moves are restricted as follows:

When you move a Rational® Synergy database, you can pack the database using an older product version, then unpack it using a newer product version. (Unpacking to a newer version requires additional steps. For more information, see For Windows Upgrading Rational Synergy on Windows or For UNIX Upgrading Rational Synergy on UNIX.

After moving a database, you might need to change some of the database properties, such as the paths to projects work areas. See Rational Synergy CLI Help for the ccm wa (work area) command for important information about changing a moved database properties.

Windows

Procedure

To rename or move a database for Windows:

  1. Ensure that you are working as the local administrator.

    You must be logged on to a machine where the Admin Tools are installed. A main server and additional server include the Admin Tools.

  2. Log on as the Rational Synergy administrator.
  3. Copy the database to a new location.

    > ccmdb copy src_database_path dest_database_path

    src_database_path specifies the source path of the database.

    dest_database_path specifies the destination path of the new database (UNC).

    For example:

    > ccmdb copy \\loon\ccmdb\prod_db \\loon\ccmdb\tstgonzo

  4. Verify that the new database is usable.

    Run this command on the database server machine.

    ccmdb check database_path

    Rational Synergy protects the database so that users do not log on to it. Then, the system unprotects the database when the check is over.

  5. Pack the new database.

    Modify your backup plan.

    ccmdb pack database_path /to packfile

    database_path is the path (full or relative) to the database.

    packfile is a path to the directory where the backup files are written. Use a path that goes to a directory that is regularly backed up through normal file system backup procedures. Or use a path that goes to a directory on an independent file system.

  6. Remove the old database.

    > ccmdb delete database_path

  7. Log off from the Rational Synergy administrator.

Informix

Before you begin

If you did not set up CCM_HOME and PATH for user informix during installation, set these environment variables now.

Procedure

To rename or move a database for Informix®:

  1. Log on to the database server.
  2. Set user to ccm_root.
    $ su - ccm_root
    Password: *****
  3. Copy the database it to a new location.

    For example, rename the prod_db database by copying it to a new database named trask, as follows:

    $ ccmdb copy /vol/hydra/ccmdb/prod_db /vol/hydra/ccmdb/trask

  4. Verify that the new database is usable.

    For example, check the trask database as follows:

    $ ccmdb check /vol/hydra/ccmdb/trask

    Rational Synergy protects the database during the check so that users cannot start new sessions. Then, the system unprotects the database when the check is completed.

  5. Pack the new database.

    $ ccmdb pack database_path -to packfile

    Write the pack file to a directory that is backed up regularly through normal file system backup procedures, or at least to a directory on an independent file system.

  6. Remove the old database.

    $ ccmdb delete database_path

  7. Exit from user ccm_root, and then update your backup plan.

Feedback