Setting the environment variables

Setting up the RAP environment

The rap_bfap_env.sh and rap_flap_env.sh scripts set the RAP environment variables for the shell. These scripts are called by other load process scripts as necessary.

Variable name	Description
RAP_HOME	Base directory for RAP data loading. All other paths should be relative to this directory.
RAP_DATA	Input directory for loading files into RAPCache. Monitored by the loading process.
RAP_STAT	Used for placing a tickler file to stop the load process.
RAP_IN	General input directory. Files are linked to the $RAP_DATA, $IQ_DIR and $RAP_ARCH directories for loading. Monitored by loading process.
RAP_ARCH	Archive directory. The loading process compares files between this directory and the $RAP_IN directory to determine whether to link files to other input directories for loading.
IQ_DIR	Input directory for loading files into VLDBServer. Monitored by loading process.
LOAD_IQ_SCRIPT_DIR	Directory where sql scripts used by the dbisql utility during VLDBServer loading are stored.
TICKLER_FILE	Name of the tickler file that stops the loading script.
MAX_PTN_QUOTE	Maximum number of partitions for the STOCK_QUOTE table. Set to 3 by the installer.
MAX_PTN_TRADE	Maximum number of partitions for the STOCK_TRADE table. Set to 3 by the installer.
ASE_SERVER	Name of the RAPCache server.
ASE_INTERFACE	Path to the RAPCache interfaces file.
ASE_UID	The RAPCache user ID.
ASE_PWD	The RAPCache user password.
ASE_DB_QUOTE	RAPCache database name for storing STOCK_QUOTE table data.
ASE_DB_TRADE	RAPCache database name for storing STOCK_TRADE table data.
IQ_ENGINE	Name of the VLDBServer. See the note below.
IQ_HOST	Host machine name of the VLDBServer.
IQ_PORT	Port number of the VLDBServer.
IQ_UID	The VLDBServer user ID.
IQ_PWD	The VLDBServer user password.
IQ_DB_QUOTE	VLDBServer database name for storing STOCK_QUOTE table data.
IQ_DB_TRADE	VLDBServer database name for storing STOCK_TRADE table data (should be the same as IQ_DB_QUOTE).

Variable name

Description

RAP_HOME

Base directory for RAP data loading. All other paths should be relative to this directory.

RAP_DATA

Input directory for loading files into RAPCache. Monitored by the loading process.

RAP_STAT

Used for placing a tickler file to stop the load process.

RAP_IN

General input directory. Files are linked to the $RAP_DATA, $IQ_DIR and $RAP_ARCH directories for loading. Monitored by loading process.

RAP_ARCH

Archive directory. The loading process compares files between this directory and the $RAP_IN directory to determine whether to link files to other input directories for loading.

IQ_DIR

Input directory for loading files into VLDBServer. Monitored by loading process.

LOAD_IQ_SCRIPT_DIR

Directory where sql scripts used by the dbisql utility during VLDBServer loading are stored.

TICKLER_FILE

Name of the tickler file that stops the loading script.

MAX_PTN_QUOTE

Maximum number of partitions for the STOCK_QUOTE table. Set to 3 by the installer.

MAX_PTN_TRADE

Maximum number of partitions for the STOCK_TRADE table. Set to 3 by the installer.

ASE_SERVER

Name of the RAPCache server.

ASE_INTERFACE

Path to the RAPCache interfaces file.

ASE_UID

The RAPCache user ID.

ASE_PWD

The RAPCache user password.

ASE_DB_QUOTE

RAPCache database name for storing STOCK_QUOTE table data.

ASE_DB_TRADE

RAPCache database name for storing STOCK_TRADE table data.

IQ_ENGINE

Name of the VLDBServer. See the note below.

IQ_HOST

Host machine name of the VLDBServer.

IQ_PORT

Port number of the VLDBServer.

IQ_UID

The VLDBServer user ID.

IQ_PWD

The VLDBServer user password.

IQ_DB_QUOTE

VLDBServer database name for storing STOCK_QUOTE table data.

IQ_DB_TRADE

VLDBServer database name for storing STOCK_TRADE table data (should be the same as IQ_DB_QUOTE).

If the VLDB Server is installed on a different machine than the RAPCache Server, you must manually set the value of the IQ_ENGINE environment variable.

Setting up the utilities environment

Before starting the load process, you must set up the environment for the bcp and dbisql utilities if you have not already done so.

To set up the environment for the bcp utility used by RAPCache, run the SYBASE.sh or SYBASE.csh script, which is located in the $RAP30/RAPCache directory.

To set up the environment for the dbisql utility used by VLDBServer, run the ASIQ-12_6.sh or ASIQ-12_6.ch script, which is located in the $RAP30/VLDBServer/ASIQ-12_6 directory.