Choosing an Action Pattern in the DBA Planning Calendar 

Use

The DBA Planning Calendar provides easy-to-use predefined action patterns specific to each database platform. You specify a reference time, on the basis of which all schedules are defined. It is possible later to delete an action pattern. For more information about how to change actions in a pattern, see Scheduling Actions in the DBA Planning Calendar. However, SAP recommends you to use a predefined action pattern.

If you started the DBA Planning Calendar using Local Calendar from the Central DBA Planning Calendar, you can choose action patterns for all remote systems running on the same platform and with the same characteristics. This assumes that you have already defined the remote systems to the Central DBA Planning Calendar.

For example, assume that you call the DBA Planning Calendar from the Central DBA Planning Calendar on system FUD, which runs Oracle version 8. You can then choose  action patterns for all other Oracle systems running Oracle version 8. If the actions in the action pattern that you want to schedule also run on Oracle version 7, then you can also schedule that action pattern for all systems running Oracle version 7.

This only applies if you started the local calendar from the Central DBA Planning Calendar.

Prerequisites

·        You are ready to use CCMS. Refer to Getting Started in CCMS with Informix DBA.

·        If you have started the DBA Planning Calendar using Local Calendar from the Central DBA Planning Calendar, you can choose action patterns for all systems on the same platform and with the same characteristics.

For example,  assume that you call the DBA Planning Calendar on system FUD, which is an Oracle system running Oracle version 8. You can then set up an action pattern for all other Oracle systems running Oracle version 8.

This only applies if you started the calendar from the Central DBA Planning Calendar.

Procedure

...

       1.      Choose CCMS  ® DB Administration ® DBA Planning Calendar ® Calendar ® Action Pattern.

       2.      Select a predefined action pattern.

       3.      Enter the time at which the key action is to be carried out.

The system suggests an appropriate time, which you can accept if you want. The system uses this time to work out the schedule for the activities in the action pattern.

If there are conflicts between the action pattern you have chosen and activities that are already scheduled in the Planning Calendar, then the system presents a list of the conflicts.

       4.      If there are conflicts, do the following:

...

                            a.      Print the list with the Shift-F1 key combination. Then choose Cancel. No activities from the new action pattern are scheduled.

                            b.      Review and eliminate the conflicts before trying to schedule the action pattern again.

       5.      To delete a predefined action pattern, you have to delete the next scheduled occurrence of the action that was scheduled as part of an action pattern. All future scheduling of the action is deleted.

       6.      Make sure that the required resources are available when an action is scheduled to run.

Result

The activities in the action pattern are automatically inserted into the planning calendar. The system also schedules background jobs for executing the activities. All jobs are scheduled for periodic repetition according to the schedule in the action pattern.

 

See also:

Checking the Results of Actions in the DBA Planning Calendar