You can use the DBA Planning Calendar in the Jobs user menu of the DBA Cockpit to automate database administration. You can schedule, perform, and check database administration actions.
You can use the DBA Planning Calendar for almost all regular database administration actions. The database actions required are automatically executed at the time you specify. Therefore, you should make sure in advance that the required resources will be available at the time of execution. You can carry out planning periodically. This reduces the amount of planning required for recurring actions.
The DBA Planning Calendar can be called as follows:
Open the DBA Cockpit (transaction DBACOCKPIT) and choose .
The DBA Planning Calendar can be opened using the Central Calendar. Open the DBA Cockpit (transaction DBACOCKPIT) and choose Central Calendar, Using the Central Calendar.
. You can find information about the Central Calendar in the following sections:The initial screen of the DBA Planning Calendar includes the following frames: DBA Planning Calendar, Action Pad, Calendar
The top left frame (DBA Planning Calendar) contains all the information and parameters for choosing actions that should be displayed:
System: Select the system you would like to use to schedule DBA actions.
Calendar ID: Select the calendar ID and a factory calendar at the same time.
Specifying the factory calendar only affects the calendar display. Public holidays are displayed in the same color as weekends. This leads to no restrictions on any actions already scheduled.
Planning Mode: You can select planning mode.
Local: Planning is carried out for the system that you selected.
Global: Planning is carried out for all integrated, attainable systems. This type of procedure may be necessary, for example, if database structure checks are to be carried out on all systems.
Calendar Control: With Calendar Control you can select the week that should be displayed.
The default value is the current week. To navigate to another week, double-click the week you would like to display.
The Action Pad contains a list of all schedulable actions currently available for the database system.
Task Area | Entry in the Action Pad | Short Name |
---|---|---|
Data and log backups | Complete data backup Incremental data backup Activate Automatic Log Backups Deactivate automatic log backups Log backup Archive log backup files | DataBackup IncrBackup AutoLogOn AuotLogOff LogBackup ArchivFiles |
Determining statistics for the SQL Optimizer | Select tables for update statistics Update statistics for selected tables Update all optimizer statistics | PrepUpdStat UpdStats UpdAllStats |
Database structure checks | Check the database structure Check the database structure (tables only) | CheckData CheckTables |
Determining table size and growth | Update table statistics | CollTabSize |
Determining class container sizes (liveCache only) | Update class container statistics | CollClaccCo |
Checking backups | Check complete data backup Check incremental data backup Check log backup | CDataBackup CIncrBackup ClogBackup |
Executing DBM commands | Execute DBM Command | DBMExecute |
The calendar can be displayed with either a weekly, daily or monthly view using either a top-bottom layout or left-right split view layout. To change the layout, choose
or Top-Bottom Split View Layout. To change, for example, from a weekly view to a daily or monthly view, choose the corresponding button in the application toolbar.Note
You can only change the layout for the week or month view. For the day view, only the left-right split view layout is available.
To change your preferred settings – that is, the layout and the view – choose Save Settings.
The calendar shows the actions that were scheduled using background processing. These actions are then automatically executed.
Once the action has run, the status is indicated using the following colors:
Color |
Meaning |
---|---|
Light blue |
The action has not yet started. |
Dark blue |
The action has not yet finished. |
Green |
The action has run successfully. |
Yellow |
The action has finished with a warning. 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. |
Dark yellow |
No more information is available. |
Dark red |
Scheduling failed, that is, there is no status available and the action is overdue. |
You can display the meaning of each color by choosing Legend.
You can move or copy actions in the DBA Planning Calendar using Drag & Drop; from the Action Pad to the Calendar too, for example.
For more function descriptions for the DBA Planning Calendar, see the following sections in Database Administration in CCMS: