DBA Planning Calendar 
You can use the DBA Planning Calendar 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.
Integration
The DBA Planning Calendar can be called as follows:
SAP MaxDB: In the Database Assistant, choose the function
Tools 
DBA Planning Calendar 
or from the user menu, choose Database: Operation DBA Planning Calendar (transaction DB13).SAP liveCache Technology: In the liveCache Assistant, choose the liveCache: Monitoring function
Tools DBA Planning Calendar or in the User Menu, chose the DBA Planning Calendar (transaction DB13).The DBA Planning Calendar can be opened via the Central Calendar (transaction DB13C). You can find information about the Central Calendar in the following sections: Central Calendar, Using the Central Calendar.
The Central Calendar and the DBA Planning Calendar are elements of the DBA Cockpit (transaction DBACOCKPIT), and can therefore be called as follows: In the DBA Cockpit, select the function
Jobs Central Calendar or Jobs DBA Planning Calendar .
Prerequisites
SAP liveCache Technology: In accordance with the Authorization Concept, the user was assigned one of the roles SAP_BC_LVC_ADMINISTRATOR or SAP_BC_LVC_SUPERUSER.
Features
The initial screen of the DBA Planning Calendar includes the following frames: DBA Planning Calendar, Action Pad, Calendar
DBA Planning 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.
Action Pad
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 |
Calendar
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 Administration
Left-Right Split View 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.
Dragging & Dropping Actions
You can move or copy actions in the DBA Planning Calendar using Drag & Drop; from the Action Pad to the Calendar too, for example.