DBA Planning Calendar 

Use

The DBA Planning Calendar is part of the Computing Center Management System (CCMS) in the R/3 System. You can use it to schedule and execute certain database administration (DBA) tasks, such as backups, updating statistics for the cost-based optimizer, database system checks, and so on. The tasks available differ according to the database platform but the method of use is the same.

The main functions of the DBA Planning Calendar are as follows:

Integration

The DBA Planning Calendar is one of a number of tools available in CCMS for performing DBA tasks. Refer to Database Administration in CCMS. The DBA Planning Calendar is available for all database platforms supported by SAP with the exception of DB2/400 (which does not require the Planning Calendar, because DB2/400 provides good equivalent tools.) It is delivered as a standard part of the R/3 System.

Features

The features implemented for the Informix database management system (DBMS) are as follows:

DBMS

Feature

Informix
  • 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

Activities

  1. You choose a predefined action pattern (or make up your own schedule).
  2. If you want to alter the schedule (for example, add new tasks, delete or change existing tasks), you can do so at any time before the scheduled time.
  3. You make sure that the resources required to complete each task (for example, tape devices) are correctly set up.

    4. The system automatically performs the task at the scheduled time (or immediately if you want).

  4. You look at the action and job logs to check the results.

For more information about activities, see DBA Planning Calendar: Informix.