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

●     Database events

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:

Administration