Backing up databases nightly

Back up your databases. Backups help queries run more quickly and updates the database statistics.

This topic contains steps for Windows® and UNIX®.

Windows

Procedure

  1. Log on to the database server as the Rational® Synergy administrator.
  2. Warn users that a backup is about to occur.
    1. Broadcast a backup message to the database users.

      > ccm message /database database_path "backup message"

    2. Show the database usage.

      > ccm monitor database_path

  3. Check and back up the database, and then update statistics.

    > ccmdb backup database_path /to destination_dir

UNIX

Procedure

  1. Set user to ccm_root.
    $ su - ccm_root
    Password: *****
  2. Warn users that a backup is about to occur.
    1. Broadcast a backup message to the database users.

      $ ccm message -database database_path “backup message”

    2. Show the database usage.

      $ ccm monitor database_path

  3. Check and back up the database, and then update statistics.

    $ ccmdb backup database_path -to destination_dir


Feedback