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_pathbackup 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