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.

Prerequisites

DBA Planning Calendar

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.

Actions

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

Procedure

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.

See: Archiving Backup Files

       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.