Preparing for backups

Archiving the database server is a prerequisite for backing up the logical log files. Archive the database server before proceeding.

This topic contains steps for Windows and UNIX.

Windows

Procedure

  1. Ensure that you are an Informix-Admin group member and working as local administrator.

    You must run this command on the machine where the Informix server resides

  2. Ensure that the tape capacity is appropriate.
  3. Take the database server offline.

    > ccmsrv offline

  4. Modify the tape parameter in the Informix server parameter file to use a different tape from the regular database server archive device.
    > ccmsrv modify /p LTAPEDEV /v \\.\TAPE1
    > ccmsrv modify /p LTAPESIZE /v 1000000

    \\.\TAPE1 is the name of the tape device.

    1000000 is the tape size in KB.

  5. Bring the database server online.

    > ccmsrv online

  6. Verify that the database server is online.

    > ccmsrv status

  7. Perform an Informix server Level 0 archive so that the changed parameters take effect.

    > ccmsrv archive /level 0

    After you have completed a successful database server archive, you can put the next archive on the same tape.

UNIX

Before you begin

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

Procedure

  1. Log on the database server as user root.
  2. Set user to informix.
    root# su - informix
    Password: *****
  3. Take the database server offline.

    $ ccmsrv offline

  4. Change the tape parameter in the database server parameter file to use a different tape from the regular database server archive device.

    For example, change the tape device to /dev/rst9 and the tape size to 500,000 KB as follows:

    $ ccmsrv modify -p LTAPEDEV -v /dev/rst9
    $ ccmsrv modify -p LTAPESIZE -v 500000
  5. Bring the database server online.

    $ ccmsrv online

  6. Verify that the database server is online.

    $ ccmsrv status

  7. Perform a Level 0 server archive.

    Because you have changed the parameters, perform a database server Level 0 archive.

    For example, create a Level 0 archive of the current database server using the tape device and size defined in the database server parameter file:

    $ ccmsrv archive -level 0

    After you have completed the database server archive, you can put the next archive on the same tape (or file).


Feedback