Automating Administration Tasks
Use
You can automate both administration tasks that must be executed regularly and those that are executed as needed.
Activities
● Special DBM commands
○ Automatic log backup
See
Database Manager GUI,
Activating and
Deactivating Automatic Log Backup
Database Manager CLI,
autolog_on
○ Extending the data area automatically
See
Database Manager GUI,
Switching on/off
Automatic Extension of the Data Area
Database
Manager CLI,
auto_extend
○ Automatic updating of the SQL Optimizer statistics
See
Database Manager GUI,
Updating Statistical
Information
Database Manager CLI,
auto_update_statistics
● Automatic start
You can also configure the database instance so that it is automatically transferred to the ONLINE operational state when the operating system is started. See Automatic Start.
● DBA planning calendar in CCMS
In SAP
systems, you can automate regular administration tasks with the
DBA Planning
Calendar.
● Scheduler
You can use the scheduler to schedule DBM commands to execute at defined points in time. To do so, you create each DBM command to be executed as a job in the scheduler. The scheduler must be active for jobs to be executed.
See Database Manager CLI,
Using the
Scheduler
You can define a database event for specific states of the database instance. When one of these states occurs, the event dispatcher executes a certain action, such as a DBM command or a command from another program.
See Overview of Database
Event Categories,
Event Dispatcher
and Database Manager CLI,
Using Database
Events
● Database triggers
You can use
triggers to trigger actions in the database following certain data changes or
a restart. See the SQL Reference
Manual,
Trigger Name
(trigger_name)
See also: