Creation of a Database Backup (ON-Bar) 

Purpose

To back up the Informix database with ON-Bar, you can do either of the following:

·        Use the Computing Center Management Center (CCMS) in the SAP System (recommended by SAP)

CCMS provides a complete environment so that you can manage your database backups from one place without having to switch between different tools. For example, you can schedule database backups and check the results in CCMS.

For more information, see CCMS: Informix.

·        Enter your own ON-Bar commands (not recommended by SAP)

You need to know the ON-Bar commands for this method. For further information, refer to the Informix documentation.

Prerequisites

You have worked out an approach and met its requirements.

Before you perform a database backup, verify database consistency. Do this as often as possible before database backups. Make sure that you always have at least one database backup that you have checked for data consistency.

Process Flow

Computing Center Management System (CCMS)

...

       1.      You use the DBA Planning Calendar in CCMS to schedule your database backups.

       2.      You make sure the necessary resources (tapes, tape drives, and so on) are available.

       3.      You use the archive and backup monitor to check the results of your database backups.

For more information about planning your database backups with the DBA Planning Calendar, see Archiving or Backing Up the Database in the DBA Planning Calendar (Informix).

Entering ON-Bar Commands Manually

For more information if you are new to ON-Bar, see ON-Bar for Data Recovery.

...

       1.      You perform the database backup manually.

       2.      You check the status and result of the database backup in either of the following ways:

-   Checking Database Backup Status and Result with Activity Log (ON-Bar)

-   Checking Result of Database Backup or Archive with Message Log

Result

The database is backed up. Therefore, you have a copy of database data that can be restored in the event of database failure.

Finally, you complete the database backup, whether you use CCMS or manual backups.

 

See also:

Informix documentation at http://www.informix.com