Central DBAPlanning Calendar 

Use

The Central DBA Planning Calendar is part of the Computing Center Management System (CCMS) in the SAP system. It gives you a single point from which to manage database administration (DBA) actions in an integrated SAP environment. The actions available differ according to the database platform but the method of use is the same. Examples of actions are backups, updating statistics for the cost-based optimizer, database system checks, and so on.

The Central DBA Planning Calendar is only for viewing DBA actions by system. However, you can easily switch to the local DBA Planning Calendar for any SAP system to process – that is, schedule, change, delete, or execute – actions.

The central and the local versions of the DBA Planning Calendar have a very similar user interface. The main difference is that the:

·         Central version shows systems (although you can drill down to look at actions if required)

·         Local version shows actions

The Central DBA Planning Calendar gives you a single point from which to manage:

·        Databases of different types and versions on remote SAP systems

·        Databases for different versions of the SAP system

·        Databases of non-ABAP SAP systems

Integration

·        The Central DBA Planning Calendar is one of a number of DBA tools in CCMS. It runs with all database platforms delivered as a standard part of the SAP system and supported by SAP except DB2/400 (which has good equivalent tools).

·        Only SAP systems based on the ABAP server support the local planning of DBA actions. Therefore, you must start these actions for non-ABAP SAP systems remotely from an SAP ABAP system, using the Local Calendar function of the Central DBA Planning Calendar.

Features

·        Display can be refreshed for local or remote systems.

·        Links provided to all systems in your network using remote function calls (RFCs).

·        Status color-coding for each system indicates if actions have executed successfully.

·        Local Calendarfunction enables full management of remote systems – including non-ABAP systems – from a single SAP system.

·        System definitions can be taken from the CCMS system repository.

·        Number of actions and number of actions with the highest status severity are displayed for each system, as shown in the following example:

Mo. 07.01.2002

3 FUD   2

On system FUD for Monday 7^th January 2002 (in the past), there were 3 actions planned, 2 of which had the highest status severity. For example, the highest status severity might be “Warning”, in which case the entry is displayed with a yellow background.

Activities

...

       1.      You choose a system from which to run the Central DBA Planning Calendar. We recommend you to do this.

       2.      On the chosen system, you plan a regular job to update the results from remote systems. For example, you plan a job to run daily at 06:00.

       3.      You regularly check the results using the Central DBA Planning Calendar.

       4.      If you need to schedule, change, delete, or execute actions, you switch to a suitable local calendar.

You can switch to any local calendar that runs the same database as the system on which you want to schedule an action. For example, if you want to schedule an action on system FUD, you can do this from the local calendar on system FIB, assuming that both systems are equivalent (that is, both run the same database and a similar database version, which supports the action you want to schedule).

For more information, see Using the Central DBA Planning Calendar.