Creating databases for UNIX®

You can create a database easily and quickly by unpacking the base.cpk file. Create the database on a file system large enough to accommodate growth.

About this task

See Monitoring database space for more information.

Procedure

  1. Set user to ccm_root.
    $ su - ccm_root
    Password: *****

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

  2. Unpack the base.cpk file, which contains the base database.

    You must have already set ORACLE_HOME and ORACLE_SID, or use the-s option, to use this command. If you are not using the default server name, you must use the -s servername option on the ccm unpack command.

    $ ccmdb unpack base.cpk -to /vol/hydra/ccmdb/database_name

  3. If necessary, change the delimiter and add users.

    If you want to change the delimiter for this database, do so now.

    See Rational® Synergy CLI Help for more information about the ccm delimiter command.

    1. Start a Rational Synergy session in the ccm_admin role.

      $ ccm start -d database_path -r ccm_admin -nogui

      If you are prompted to enter a password, you are connecting to a client session across a firewall. You must type your password to continue.

    2. Change the delimiter to the new character to be used in this database. For example, set the delimiter to a comma, as follows:

      $ ccm delim ","

    3. Add users.

      To add users to the Rational Synergy database, do so now before proceeding to the next step (see Adding users to a database for Windows or Adding users to a database for Windows).

      If you do not need to add users to the Rational Synergy database, proceed to the next step.

    4. Exit from the Rational Synergy session.

      $ ccm stop

  4. Implement a check and backup plan for your database, and execute it daily.
  5. Exit from user ccm_root.
    Note: You must check and back up your database at least once a day should the system fail. If your database is corrupted, you must have a backup of the database or you might lose all data.

Feedback