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.

Before you begin

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

About this task

See Monitoring database space for more information.

Procedure

  1. Set user to ccm_root.
    $ su - ccm_root
    Password: *****
  2. Unpack the base.cpk file, which contains the base database.

    For OracleYou 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

      For InformixIf 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.

      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