DB2 Job Control

To assign a configuration file to a job, set the environmental variable DB2_BEX_CFGFILE to the fully qualified name (with path) of that configuration file. If DB2_BEX_CFGFILE is not set, the default sbt11cfg.BEX will be used. Assigning DB2_BEX_CFGFILE is valuable if you want to run more than one DB2 backup or restore job concurrently.

To set DB2_BEX_CFGFILE in a Windows environment, add a registry entry under HKEY_LOCAL_MACHINE\SOFTWARE\Syncsort\BackupExpress\hostname\0. Remember to include the configuration file’s complete path as part of the value.

Warning! Changes to registries or environmental variables should be done only by qualified administrators. If done incorrectly, such changes can adversely affect applications or operating systems. Contact Catalogic Software Data Protection Technical Support if you need assistance.

Note. When you change an environmental variable, DB2 must be stopped and restarted for the change to take effect.

The following optional variables, which provide additional job control, can be set in the configuration file:

  • BEX_JOB_NAME - A unique name for the backup or restore job.

  • BEX_DB2_RESTORE_INSTANCE - The specific instance that you want to restore. This is used for cross-instance restores. For example, if the instance you backed up was db2inst and you want to do a cross-instance restore, then while restoring to a new instance you would specify BEX_DB2_RESTORE_INSTANCE in your configuration file.

  • BEX_DB2_RESTORE_DATABASE - The specific database to restore. This is used for cross-instance restores.

Last updated