As a database administrator, you must periodically carry out certain administration tasks. In addition to these, you may need to carry out further administration tasks after specific system events have occurred.
Some administration tasks can be automated using special automating functions, others can be planned with the scheduler, triggered by events or triggers, or planned with the DBA Planning Calendar.
Automatic Log Backup
For more information, see
Database Studio, Activating or Deactivating Automatic Log Backup
Database Manager CLI, autolog_on
Database Administration in CCMS, Activating Automatic Log Backup
Dynamic Data Area Adjustment (database size)
The system automatically adds new data volumes when the fill level of the data area exceeds a specified limit, and removes data volumes when the fill level falls below a specified limit.
For more information, see
Database Studio, Activating or Deactivating the Dynamic Adjustment of the Data Area
Database Manager CLI, auto_extend, auto_shrink
Automatic Recreation of Bad Indexes
For more information, see
Database Studio, Activating or Deactivating the Automatic Recreation of Damaged Indexes
Database Manager CLI, auto_recreate_bad_index
Automatic Statistics Update
For more information, see
Database Studio, Updating SQL Optimizer Statistics
Database Manager CLI, auto_update_statistics
Database Administration in CCMS, Scheduling Updates of the SQL Optimizer Statistics
You can use the scheduler to schedule DBM commands to be executed at specific times. For that purpose, you log on to the database and create a job in the scheduler for every DBM command to be executed. You must activate the scheduler for the jobs to be executed.
The scheduler uses a separate DBM server process for the connection to the database. Therefore, the scheduler remains active when you stop the database.
For more information, see Database Manager CLI, Using the Scheduler Function.
You can define that database events are triggered under specific circumstances, and that certain actions are carried out in response to these events, for example sending an e-mail, executing a DBM command or executing a command from another program.
For more information, see
Glossary, Event
Database Studio, Using Database Events
Database Manager CLI, Using Database Events
You can use database triggers to trigger actions in the database following certain data changes or a restart.
For more information, see SQL Reference Manual, Trigger Name (trigger_name).
In SAP systems, you can plan periodic administration tasks with the DBA Planning Calendar.
For more information, see Database Administration in CCMS, DBA Planning Calendar.