Environment

Last updated on Jan 25, 2021

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.

Environment variables can also be in the environment of the HVR Scheduler, but these are only inherited by HVR processes that run locally on the hub machine; they are not exported to HVR child processes that are used for remote locations.

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   Since    v5.7.5/6  

ctx

Ignore action unless the Hvrrefresh or Hvrcompare 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_COMPRESS_LEVEL

Controls amounts of replication for capture and integrate jobs. Value s disables compression, which will reduce CPU load. By default, compression is enabled. This variable must have the same value for all locations.

HVR_LOG_RELEASE_DIR

Ingres

Oracle

PostgreSQL

Directory chosen by Hvrlogrelease for private copies of DBMS journal or archive files. By default, Hvrlogrelease writes these files into the DBMS tree (inside $II_SYSTEM or $ORACLE_HOME).

In Oracle, if Capture /ArchiveLogPath is defined then the value set in this environment variable is ignored/overridden.

HVR_SORT_BYTE_LIMIT

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

HVR_SORT_COMPRESS

When set to value 1 the sorting of large amounts of data will be compressed on the fly to reduce disk room.

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.