Try OpenEdge Now
skip to main content
Database Management
Database Maintenance Job Templates : Creating database maintenance job instances : Setting up Database Backup jobs
 

Setting up Database Backup jobs

The job page and the options that you use to set up and run an online database backup are identical to an offline backup.
To complete the Database Backup Properties page:
1. Provide values for the Name and Description fields.
2. From the list of available databases, select the database for which you want to perform the backup.
3. Identify the backup device you are using:
*If you select Tape, you must also define the absolute path for the tape device.
*If you select Disk, you must also specify the directory and the filename. If you want to overwrite an existing backup at this location, select the Overwrite file option.
4. In the Volume size (-vs) field, identify the size, in database blocks, that you want the backup to be before prompting for another volume.
If you select the Volume size (-vs) parameter, the following happens:
*The Backup job looks for a file in your work directory with the name of <resource name>-backup.txt. This file should contain names for each backup file. If this file exists, the Backup job uses it as input to the OpenEdge Backup Utility (PROBKUP).
*The following shows an example <resource name>-backup.txt file:
e:\dbwork/ftd.bak1
e:\dbwork/ftd.bak2
e:\dbwork/ftd.bak3
e:\dbwork/ftd.bak4
e:\dbwork/ftd.bak5
e:\dbwork/ftd.bak6
e:\dbwork/ftd.bak7
e:\dbwork/ftd.bak8
e:\dbwork/ftd.bak9
e:\dbwork/ftd.bak10
e:\dbwork/ftd.bak11
e:\dbwork/ftd.bak12
e:\dbwork/ftd.bak13
e:\dbwork/ftd.bak14
e:\dbwork/ftd.bak15
e:\dbwork/ftd.bak16
e:\dbwork/ftd.bak17
e:\dbwork/ftd.bak18
e:\dbwork/ftd.bak19
e:\dbwork/ftd.bak20
e:\dbwork/ftd.bak21
*If this file does not exist, the Backup job creates the file in the working directory. The file is the name of the backup (entered in Step 1) with a number from 1 to 99 appended to it. The Backup job uses this file as input to PROBKUP.
*Any files created by the Backup job remain after the program ends. The Backup job does not delete them.
5. Complete the following fields:
*Blocking factor (-bf) — Specifies the blocking factor size used to flush buffers out of the backup device.
*Redundancy factor (-red) — Specifies the redundancy count to create redundancy in the backup.
*Incremental overlap (-io) — Identifies how many previous backups you want included in this incremental backup. Use this field simultaneously with the Incremental check box.
*Incremental — If selected, this backs up the blocks that have changed since the last backup. Use this field simultaneously with the Incremental overlap (-io) parameter field.
*Estimate size — If selected, this generates a report that estimates the size of the backup.
This setting does not back up the database.
*Verbose listing — If selected, this provides output every 10 seconds concerning the status of the backup.
*Compression — If selected, this indicates you want to compress data blocks as they are backed up.
*No recovery — If selected, this prevents the database from rolling forward an AI file. This option is used for mirrored backups.
6. Verify the name of the command's current working directory in the Working Directory field. If specified, this directory must exist. This property defaults to the working directory defined at installation.
7. To append subsequent messages to the .out or .err files, select the Append option. The Output file field indicates where messages will be retained.
8. Select the Debug log file option to obtain diagnostic details that help debug job properties when setting up a job. For example, you can set this option and use the Run Now feature on the Job Summary page. Once you have submitted the job, OpenEdge Management makes debug data available through the debug log file link on the Job Summary page.
9. Select the Indicate if the job can be used as an action option if you want this job to appear in the list of actions that can be selected for execution from the Alerts and Job completion action page.
10. If you intend to set up actions and alerts for this job, click the Edit button associated with the Completion Actions and Alerts field to display the Job Completion Actions and Alerts page. See OpenEdge Management: Resource Monitoring for more information about the Job Completion Actions and Alerts page.
11. Click Save. The Job Summary page appears. You can now schedule the job to run at a later time, or you can run it immediately. You can also edit advanced information, as detailed in Editing advanced job information.