Creating databases for Windows

You can create a database easily and quickly by unpacking the base database from the pack file that is shipped with the Rational® Synergy software.

Before you begin

Before you unpack a database:

You must be working as local administrator to perform this command. You must be logged on to a machine where the Admin Tools are installed, such as on a server machine.

Procedure

To create databases by unpacking from the pack file for Windows:

  1. Log on as the Rational Synergy administrator.
  2. Unpack the base.cpk file, which contains the base database.

    > ccmdb unpack packfile /to database_path

    packfile is the name of the file you want to unpack.

    database_path is the path name to your new database.

    Type the path using the universal naming convention (UNC).

    For example, to restore base to a database named test, type:

    > ccmdb unpack base.cpk /to \\loon\ccmdb\test
  3. Optionally, change the case keyword from LOWER to PRESERVE. If you do not need to change the case, skip this step.
    Attention: Do not change the case mode of a database in which any uppercase or mixed-case objects have been created. Doing so causes inaccurate or incomplete query results.

    Rational Synergy supports case-sensitive file names in two ways. PRESERVE maintains the case preserving default setting. (Case-sensitive means that you must always type the file or project name exactly the way you created it, that is, Main.c, never main.c or MAIN.C.) LOWER causes file and directory names to be stored in lower case in the Rational Synergy database.

    The default is LOWER.

    If you do not need to change the case, skip this step.

    1. Set the CASE keyword to PRESERVE.

      > ccmdb info database_path /keyword case /value preserve

    2. Check the CASE keyword.

      > ccmdb info database_path /keyword case CASE=PRESERVE

  4. To change the delimiter for this database, you must do so now. For more information, see delimiter command.
    • Start a Rational Synergy CLI in the ccm_admin role.

      > ccm start /d database_path /r ccm_admin

    • Change the delimiter to the new character to be used in this database.

      > ccm delim “,”

  5. If you need to add users to the Rational Synergy database, do so now before proceeding to the next step. If you do not need to add users to the Rational Synergy database, proceed to step 6.
  6. Stop the Rational Synergy session.
  7. Implement a check and backup plan for your database, and then run it daily.
  8. Log off from the Rational Synergy administrator.
    Attention: You must check and back up your database daily should the system fail. If your database is corrupted, you must have a backup of the database or you might lose all data.

    Certain considerations regarding database location are important in configuring your system.


Feedback