Setting Up and Using the DBA Planning Calendar 
To make sure that your database operates efficiently and in line with security requirements, you need to execute certain database management tasks, some of which need to be repeated regularly. You can plan these using the DBA Planning Calendar: DBA Cockpit, DBA Planning Calendar, or Database Assistant, or liveCache Assistant, DBA Planning Calendar.
The first time you start your system, the DBA Planning Calendar is empty. You can use it to schedule new actions (for example, data backups, log backups, updates of SQL Optimizer statistics and database structure checks). These are then performed at the specified time.
You can set up the DBA Planning Calendar by selecting a planning pattern or choosing a predefined action from the Action Pad. If you add a new action, this is defaulted as a once-only execution.
You can schedule, change or delete actions as required. Most of the actions that can be planned with the DBA Planning Calendar should be scheduled as periodic actions. You must check the calendar daily to be sure that scheduled actions have been carried out correctly.
Actions
At present, the following actions are available in the DBA Planning Calendar in the Action Pad:
Task Area |
Entry in the Action Pad |
Short Name |
|---|---|---|
Data and Log Backups |
Complete Data Backup Incremental Data Backup Activate Automatic Log Backup Deactivate Automatic Log Backup 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 database structure of the snapshot Check the Database Structure Check the Database Structure (Tables Only) |
CheckDataSn CheckData CheckTables |
Determine Table Size and Growth |
Update Table Statistics |
CollTabSize |
Determine Class Container Sizes (SAP liveCache technology only) |
Update Class Container Statistics |
CollClaccCo |
Checking Backups |
Check Complete Data Backup Check Incremental Data Backup Check Log Backup |
CDataBackup CIncrBackup ClogBackup |
Execute DBM Commands |
Executing DBM Commands |
DBMExecute |
Prerequisites
Think about a suitable planning concept for the most important task areas. Before a scheduled backup action is due to start, make sure that the data carriers have been inserted and are ready to run. You can configure the back end of the DBA Planning Calender to control the execution of background jobs (Setting Up the DBA Planning Calendar).
Procedure
Also create any necessary backup templates.
More information: Backup Templates
You can use the available action patterns to schedule your actions.
More information: Action Patterns
If you have not already done so by using the action pattern, schedule your data backups.
More information: Scheduling a Data Backup
Perform log backups.
You should always activate automatic log backup.
More information: Activating Automatic Log Backup
If necessary, schedule an interactive log backup.
More information: Scheduling an Interactive Log Backup
You should archive the log backup files regularly.
More information: Archiving Backup Files
If you have not already done so by using the action pattern, schedule Optimizer statistics updates.
More information: Scheduling Updates of the SQL Optimizer Statistics
If you have not already done so by using the action pattern, schedule your database structure checks.
More information: Scheduling a Database Structure Check
Schedule any further actions required, such as Checking Backups or Updating Table Statistics.
Edit the schedule to make any required changes to activities or start times.
More information: Changing or Deleting an Action, Scheduling an Action
Check the DBA Planning Calendar daily to see whether your scheduled activities have been performed correctly. In the DBA Planning Calendar, check whether the backup actions that are scheduled for the next few days can be performed correctly.
More information: Displaying Actions
If any action did not run successfully, analyze the problem and repeat the action if necessary.
More information: Starting an Action Immediately
Note
It is not possible to execute all the tasks necessary for managing the database from the DBA Planning Calendar. Information, for example, about how you can execute actions if the SAP system is not available can be found in the documentation Database Administration.