Setting
Up and Using the DBA Planning Calendar
The first time you start your system, the DBA Planning Calendar is empty. You can use it to schedule new actions (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.
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.
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.
At present, the following actions are available in the DBA Planning Calendar in the Action Pad.
Actions
Task Area |
Actions |
Short Name |
Data and log backups |
Complete data backup Incremental data backup Activating automatic log backups Deactivating automatic log backups Log backup Archiving log backup files |
DataBackup IncrBackup AutoLogOn AutoLogOff LogBackup ArchivFiles |
Determining statistics for the SQL Optimizer |
Selecting 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 |
Executing a DBM Command |
DBMExecute |
OLTP: In the Database Assistant, select the function Tools → DBA Planning Calendar or from the User Menu go to Database: Operation→ DBA Planning Calendar (transaction DB13).
liveCache: In the liveCache Assistant, select the function
liveCache:
Monitoring→ Tools → DBA Planning Calendar or from the
User Menu, go to
DBA
Planning Calendar(transaction DB13).
...
Create any
backup templates that you need (OLTP/
liveCache).
1. You can use the available action patterns to schedule your actions.
See: Action Patterns
2. If you have not already done so by using the action pattern, schedule your data backups.
See: Data Backups
3. Perform log backups.
You should always activate automatic log backup.
See: Activating Automatic Log Backups
If necessary, schedule an interactive log backup.
See: Scheduling Interactive Log Backups
You should archive log backup files regularly.
4. If you have not already done so by using the action pattern, schedule optimizer statistics updates.
See: Scheduling Updates of the SQL Optimizer Statistics
5. If you have not already done so by using the action pattern, schedule your database structure checks.
See: Scheduling a Database Structure Check
6. Schedule any further actions required, such as Checking Backups or Updating Table Statistics.
7. Edit the schedule to make any required changes to activities or start times.
See: Changing or Deleting an Action, Scheduling an Action
8. 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.
See: Displaying Actions
If any action did not run successfully, analyze the problem and repeat the action if necessary.
See: Starting an Action Immediately

It is not possible to execute all the tasks necessary for managing the database from the DBA Planning Calendar. Information about actions you need to execute if the SAP system is not available can be found in the documentation Concepts of the Database System.