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:
·
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 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
...
1. Choose CCMS ® DB Administration ® DBA Planning Calendar.
2. Choose the day when you want the database backup or archive to take place.
3. Choose Create action.
4. 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).
5. Enter data as required in the fields Start Time, Period (weeks), and Calendar. For more information, see Scheduling Actions in the DBA Planning Calendar.
6. 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.
7. 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).