DBA Planning Calendar (Informix) 
Purpose
You can schedule the following database administration (DBA) tasks using the DBA Planning Calendar with the Informix database:
· Database archive (with ON-Archive) or database backup (with ON-Bar)
· Logical-log backup (with ON-Archive or ON-Bar)
· Check and update statistics for cost-based optimizer (CBO)
· System checks (that is, configuration and performance checks)
· Physical consistency checks
Prerequisites
· If you are using the DBA Planning Calendar for the first time, see Getting Started in CCMS with Informix DBA.
· You can call the DBA Planning Calendar for an Informix system from the Central DBA Planning Calendar on a remote system using Local Calendar. If you do this, you can also manage other Informix systems – including non-R/3 Systems – from a single point.
Process Flow
...
1. You schedule the activities you need, preferably choosing a predefined action pattern. For more information, see Choosing an Action Pattern in the DBA Planning Calendar. If you want to set up your own schedule, see the next step.
By using an action pattern, you are following SAP’s guidelines for database activities that can be performed from the CCMS. An action pattern implements a backup strategy and other database administration activities that need to be regularly performed.
When you choose an action pattern, the system enters the required activities into the DBA Planning Calendar. It also schedules the background jobs that perform the activities.
We recommend you to perform the following tasks daily.
2. If needed, you edit the schedule to make any required changes to activities or start times. For example, you might want to add a new job on a certain day or time, or delete a pre-scheduled job. Refer to Scheduling Actions in the DBA Planning Calendar.
3. You make sure that the resources required to complete each task are available. Typically, you need to make sure that:
¡ Storage devices (for example, tape drives) are correctly set up.
¡ New media (for example, tapes) are correctly initialized.
¡ The required media are inserted in the correct storage devices.
4. You check the result by looking at the action and job logs. Refer to Checking the Results of Actions in the DBA Planning Calendar. For archives and backups, you can also use the archive and backup monitor. Refer to Using the Archive and Backup Monitor in CCMS (Informix).
If any action did not run successfully, analyze the problem and repeat the action if necessary. Refer to Troubleshooting in the DBA Planning Calendar (Informix).
The information above is an overview of how to use the DBA Planning Calendar. For more information about how to perform actions specific to the Informix database, see the following:
· Archiving or Backing Up the Database in the DBA Planning Calendar (Informix)
· Backing up the Logical Log in the DBA Planning Calendar (Informix)
· Backing up the Logical Log (Automatic) in the DBA Planning Calendar (Informix)
· Checking Statistics in the DBA Planning Calendar (Informix)
· Updating Statistics in the DBA Planning Calendar (Informix)
· Checking Physical Consistency in the DBA Planning Calendar (Informix)
· Checking the DB System in the DBA Planning Calendar (Informix)
See also:
BC SAP Database Guide:
Informix