DBA Planning Calendar (Informix) 

Purpose

You can schedule a variety of database administration (DBA) tasks with the Informix database. For more information, see "Features" in DBA Planning Calendar.

Prerequisites

For more information about what you need to do before using the DBA Planning Calendar for the first time, see Getting Started in CCMS with Informix DBA.

Process Flow

  1. You schedule the activities you need, preferably choosing a predefined action pattern. Refer to Choosing an Action Pattern in the DBA Planning Calendar (Informix). If you want to set up your own schedule, see the next step.

    2. By using an action pattern, you are following SAP’s guidelines for database activities that can be carried out 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 carry out the activities.

    You should 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:

    4. – 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 CCMS (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:

 

See also:

SAP/Informix DBA in CCMS

BC R/3 Database Guide: Informix