The DBA Planning Calendar (DB2 UDB for UNIX and Windows) 

Use

You can use the DBA Planning Calendar to automate database administration actions that have to be performed regularly. You can schedule operations, such as online backups, have them automatically performed, and then check that the operation was successful.

The main function of the DBA Planning Calendar is to define the start times and parameters for database actions. Since these actions run without interaction with the administrator, you have to make sure in advance that the necessary resources will be available.

Integration

The DBA Planning Calendar is part of the Computing Center Management System (CCMS) and can be accessed using the DBA Cockpit.

Features

Initial Screen

The initial screen of the DBA Planning Calendar is divided into three frames:

·        The frame on the left contains all information and parameters to select the set of actions to be displayed. You can:

¡        Select the system from which you want to read planning data.

¡        Select the category of an action:

§         DBA Actions

These are plannable actions.

§         DB Collectors

These are actions that are automatically selected by the system to collect, for example, data on performance or history and are only available for RFC-monitored systems.

¡        Select the week to be displayed using the calendar control.

The default is the current week. To navigate to another week, double-click the week you want to display.

¡        Select a factory calendar.

Specifying a factory calendar only has an impact on the calendar display. Holidays are the same color as weekend days. It does not result in any restrictions for planned actions.

·        The frame on the right contains a list of all plannable actions that are currently available for DB2 UDB for UNIX and Windows.

·        The frame in the lower half of the screen contains the calendar, which displays one week starting with Monday. The calendar contains cells for each hour of the day. Actions can be scheduled in advance using background processing. These actions are then executed automatically. Once the action has run, the status is indicated using the following colors:

Color	Meaning
Green	The action has run successfully.
Yellow	The action has finished with a warning. You should check the job log for details.
Red	An error has occurred and the action was interrupted. Check the job log for details and reschedule the action.
Grey	·        The action has not yet started. ·        The action has not yet finished. ·        The status could not be determined.

Drag & Drop of Actions

You can move or copy actions within the calendar by using the drag & drop function.

 

See also:

Setup of the DBA Planning Calendar