Environment

Last updated on May 03, 2022

Contents

Description

Action Environment sets an operating system environment variable for the HVR process which connects to the affected location. It also affects an agent called for this location.

If this action is defined on a specific table, then it affects the entire job including data from other tables for that location.

Parameters

This section describes the parameters available for action Environment.

Parameter

Argument

Description

Name

env_var

Name of the environment variable.

Value

path

Value of the environment variable.

Context

ctx

Ignore action unless Refresh or Compare context ctx is enabled.

The value must be the name of the context (a lowercase identifier). It can also be specified as !ctx, which means that the action is effective unless context ctx is enabled. One or more contexts can be enabled for hvrcompare or hvrrefresh (on the command line with option –Cctx).

Examples

Variable

Description

HVR_LOG_RELEASE_DIR

PostgreSQL

Specifies alternative directory for reading DBMS backup log files. The value points to an alternative location where HVR can find the backups of the transaction files (alternative to where the database dictionary indicates they are). This variable is similar to the location property Archive_Log_Path.

PostgreSQL needs this for locating the archive files.

HVR_SORT_BYTE_LIMIT

Amount of memory to use before sorting large data volumes in temporary files. The default limit is 512Mb.

HVR_SORT_ROW_LIMIT

Number of rows to keep in memory before sorting large amounts of data using temporary files. The default limit is 10Mb.