Try OpenEdge Now
skip to main content
Database Management
Database Maintenance Job Templates : Editing advanced job information : Environment variables for database maintenance jobs
 

Environment variables for database maintenance jobs

If you choose to create custom jobs by modifying the job templates provided, use the information provided in the following table.
Table 5. Environmental variables for database maintenance jobs
Job
OpenEdge Management variable
Description
Database Backup
FM_BKPDEVICE
Identifies the backup device, which is either the tape or complete path to the file.
Database Backup
FM_BKPDEVICETYPE
Indicates the type of device to be used—disk or tape.
Database Backup
FM_BKPTAPEDIR
Identifies the full tape device name. This name can match the value defined for FM_BKPDEVICE.
Database Backup
FM_BKPDIRECTORY
Identifies the directory for file backup.
Database Backup
FM_BKPFILENAME
Identifies the filename for file backup.
Database Backup
FM_BKPOVERWRITEFILE
Indicates whether a file, but not a tape, is overwritten.
Database Backup
FM_BKPONLINE
Identifies the option that determines whether to perform a backup job online or offline. If this option is not set, OpenEdge Management assumes the backup is offline.
Database Backup
FM_BKPINCREMENTAL
Indicates whether data in blocks that have been changed since the last backup will be backed up.
Database Backup
FM_BKPESTIMATESIZE
Indicates whether a report that estimates the size of the backup will be generated.
Database Backup
FM_BKPVERBOSELISTING
Indicates whether OpenEdge Management provides a verbose output every 10 seconds giving the status of the backup.
Database Backup
FM_BKPCOMPRESSION
Indicates whether you want data blocks compressed as they are backed up.
Database Backup
FM_BKPNORECOVERY
Used for mirrored backups. Set this option if you do not want the database to be able to roll forward an AI file.
Database Backup
FM_BKPVOLUMESIZE
Identifies the size that you want the backup to be before prompting for another volume.
Database Backup
FM_BKPBLOCKINGFACTOR
Specifies the blocking factor size used to flush buffers out of the backup device.
Database Backup
FM_BKPREDUNDANCYFACTOR
Specifies the count to create redundancy in the backup.
Database Restore
FM_RSTDEVICE
Identifies the device to which the database is restored. The device can be either a tape or a complete path to a file.
Database Restore
FM_RSTDEVICETYPE
Indicates the type of device to be used—disk or tape.
Database Restore
FM_RSTVERIFY
Identifies one of three possible restore options:
*Partial verification
*Full verification
*Creation of a structure file from the backup that was completed
Database Restore
FM_RSTDBNAME
Identifies the full path and name of the database you want to restore.
GrowBI
FM_BICLUSTERNUMBER
The number of clusters to pregrow the BI file to when the command is run. The initial size of the BI file is determined by taking the BI cluster size times the BICLUSTERNUMBER.
Database Analysis
FM_DBAUTILIZATIONNUMBER
Specifies the percentage of utilization of the blocks for the index to validate against.
Database Analysis
FM_COMPACTIONNUMBER
Specifies the percentage to which indexes will be packed when index compaction is run.
Database Analysis
FM_DBABLOCKNUMBER
Specifies the threshold for the number of blocks that the index must contain for the rule to be run.
Database Analysis
FM_DBARULEVALIDATION
Indicates that you want this job to test your rules.
Index Compaction
FM_IDXTABLENAME
Identifies the name of the table to compact.
Index Compaction
FM_IDXINDEXNAME
Identifies the name of the index to compact.
Index Compaction
FM_COMPACTIONNUMBER
Specifies the percentage to which indexes will be packed when index compaction is run.
All database maintenance jobs
FM_ADMINSERVERNAME
Specifies the resource's AdminServer and the resource. For example: Dev01.sports2000.