Environment
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. |
/ContextSince 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_DIRIngresOraclePostgreSQL | 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. |