Scheduling Backups and Archives with CCMS (ON-Bar and ON-Archive (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Scheduling Backups and Archives with CCMS (ON-Bar and ON-Archive)

Use

The DBA Planning Calendar in the Computing Center Management System (CCMS) of the SAP System lets you schedule the following for the Informix database:

Database backups (ON-Bar) or archives (ON-Archive)

Logical-log backups (ON-Bar and ON-Archive)

If the necessary resources (that is, storage media) are available, the DBA Planning Calendar executes the backup or archive on the date and time that you specify.

The advantages of the DBA Planning Calendar and CCMS are:

You have a single point from which to coordinate and supervise database backups, archives, and logical-log backups.

You do not need to enter ON-Bar or ON-Archive commands, since CCMS handles these for you. Therefore, there is less chance of error.

You can see a history of database backups, archives, or logical-log backups, showing past results.

You can see how full the logical log is at any time.

You can automatically see which volumes are needed for a future database backup, archive, or logical-log backup.

With ON-Archive you can use an automatic logical-log backup from the DBA Planning Calendar. The backup is triggered when the fill-level of the logical log reaches a certain percentage. You can specify the percentage, for example, 50%. Refer to Backing Up the Logical Log (Automatic) in the DBA Planning Calendar (Informix).

Procedure

Use the DBA Planning Calendar to schedule a database backup or an archive to run at the required date and time.

Refer to Archiving or Backing Up the Database in the DBA Planning Calendar (Informix).

Use the DBA Planning Calendar to schedule a logical-log backup to run at the required date and time.

Refer to Backing Up the Logical Log in the DBA Planning Calendar (Informix).

Check the results using the Checking the Results of Actions in the DBA Planning Calendar.

Look at an overview of the results, including the status of the logical log, using the archive and backup monitor in CCMS.

Result

The database and logical logs are backed up at the scheduled date and time, without you having to remember to execute them. Therefore, you can be more sure that, in the event of failure involving data loss, you have a backup that you can use to quickly restore the database with minimal data loss.