> #### Environment variables

> Use the information provided in Table 4–1 if you choose to create custom jobs by modifying the provided job templates.

> Table 4–1: Environmental variables for database maintenance jobs
> Job | Variable | Description
> --- | --- | ---
> Database Backup | FM_BKPDEVICE | Identifies the backup device, 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 is overwritten. This information applies only to files, not tapes.
> Database Backup | FM_BKPONLINE | Identifies the option that determines whether the backup job is to be performed online or offline. If this option is not set, Fathom 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 Fathom will provide a verbose output every 10 seconds concerning 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 redundancy count to create redundancy in the backup.
> Database Restore | FM_RSTDEVICE | Identifies the device to which the database is restored. It 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 name of the database you intend to restore. This name is 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_CONTAINERNAME | Specifies the resource's container and the resource. For example: Dev01.sports2000.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095