Archiving or Backing Up the Database in the DBA Planning Calenda

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

Use

You can use the DBA Planning Calendar in the Computing Center Management System (CCMS) to schedule database backups (ON-Bar) or archives (ON-Archive) for the Informix database. For more information about database backup or archive, see:

Database Backup (ON-Bar)

Archive (ON-Archive and ontape)

Prerequisites

You are ready to use CCMS. Refer to Getting Started in CCMS with Informix DBA.

You know how to use the DBA Planning Calendar. For more information, see:

DBA Planning Calendar for an overview

DBA Planning Calendar (Informix) for Informix-specific aspects

For more information about scheduling an action (for example, a database backup) in the DBA Planning Calendar, see Scheduling Actions in the DBA Planning Calendar.

Your storage devices are ready and have media loaded with enough available space. For example, if using tape, your tape device is ready to receive data and you have loaded a tape with enough available space.

Procedure

Choose Tools ® CCMS ® DB Administration ® DBA Planning Calendar.

Choose the day when you want the database backup or archive to take place.

Choose Create action.

Select an Action from the list as follows:

ON-Archive

Select	To perform
Database full archive	A full archive of all dbspaces of the database
Incremental archive level 1	An incremental archive of all dbspaces changed since the last full archive
Incremental archive level 2	An incremental archive of all dbspaces changed since the last incremental archive at level-1

For more information about archiving with ON-Archive outside CCMS, see Creation of an Archive (ON-Archive).

ON-Bar

Select	To perform
Database backup (dbspaces)	A full backup of all or selected dbspaces of the database
Incremental database backup (dbspaces)	An incremental backup of dbspaces changed since the last database backup
Whole system backup (serial)	A full backup of all dbspaces and the logical log, executed serially
Incremental whole system backup (serial)	An incremental backup of all dbspaces changed since the last database backup and a logical-log backup, executed serially

For more information about backing up the database with ON-Bar outside CCMS, see Creation of a Database Backup (ON-Bar).

Enter data as required in the fields Start Time, Period (weeks), and Calendar. For more information, see Scheduling Actions in the DBA Planning Calendar.

Choose Continue.

If your chosen action requires more parameters, the system prompts for them.

For example, with ON-Archive, you have to select the Vset name (that is, volume set name) for the archive. SAP recommends that you use volume set DBTAP for archives. For more information, see Volume Sets and Volumes for ON-Archive.

Enter data as required and choose Continue.

If either of the following conditions applies, a full (level-0) database backup or archive is executed, even though you scheduled an incremental (level-1 or level-2) backup or archive:

· There is no successfully executed level-0 database backup or archive.

· You have altered the dbspace structure since the last level-0 database backup or archive. In other words, you have added or deleted non-temporary dbspaces. A prompt warns you of this when you start the DBA Planning Calendar.

If you enter more than one volume set for an archive with ON-Archive, the archive runs in parallel. CCMS automatically determines the allocation of dbspaces to volume sets. For more information about planning parallel archives, see Parallel Archive Approach (ON-Archive).

Result

The database backup or archive is now scheduled. It will be created at the scheduled date and time. For more information about looking at the results of the database backup or archive, see Using the Archive and Backup Monitor in CCMS (Informix).