CONTROL supports the backup and restore procedures in a convenient way. These procedures can be activated immediately; or they can be performed at fixed times based on a weekly timetable. If desired, a segment of the archive log is automatically saved to a particular medium whenever the log segment has been completed.
Ad-hoc Backups
In WARM and COLD database mode, CONTROL provides the following kinds of interactive backups under the Backup / Save menu item:
- Data (physically complete),
- Updated Pages (physically incremental),
- Log (logically incremental),
- Log Segment (logically incremental).
Automatic Backup of Log Segments
The oldest log segment can be automatically backed up in CONTROL as soon as the log segment has been completed. For this purpose, the automatic backup of the log can be enabled or disabled in CONTROL either under the Options / Autosave Log menu item or in the schedule using the actions AUTO-ON and AUTO-OFF. For the automatic backup of the log segments, a separate backup device must be used which must be accessible to the backup process at any time.
Backups in the Schedule Manager
The schedule under the Backup / Schedule Manager menu item can be used to plan the same actions as for an ad-hoc backup:
- SAVEDATA (physically complete),
- SAVEPAGES (physically incremental),
- SAVELOG (logically incremental),
- SAVELOGSEG (logically incremental),
- AUTO-ON and AUTO-OFF.
Verification and Optimizer Support in the Schedule Manager
Verify and UPDSTAT (Update Statistics) must be performed from time to time to guarantee secure database operation and good performance. See the Sections Concepts, Consistency Check and Optimizer Support, Backup / Save / Verify Devspaces, orOperating / Update Statistics
Automatic backup of log segments as well as backup, verification, and optimizer support in the schedule are performed in batch operation; i.e., the parameters must be defined before starting the action or when defining them using the Schedule Manager.
See also: