This section describes the scripts that control the loading process.
Shell scripts in the $RAP_HOME directory control the RAPCache loading process.
Some of the shell scripts in the $RAP_HOME directory are used by the RAP File Load Agent and Batch File Agent, which are controlled by the RAP Operations Console. For more information on the Operations Console agents, see Chapter 2, “Administering Operations Console” in the Risk Analytics Platform Administration Guide.
Script name |
Description |
|---|---|
rap_link.sh |
Links new data source files in the $RAP_IN directory to the $RAP_DATA, $IQ_DIR, and $RAP_ARCH directories. |
rap_bfap_start.sh |
Launches the file moving process. The incoming data files are moved to the $RAP_DATA and $IQ_DIR staging areas. Used by the Operations Console Batch File Agent. |
rap_flap_start.sh |
Launches the loading process. Used by the Operations Console File Load Agent. |
rap_bfap_stop.sh |
Creates a tickler file in the $RAP_STAT directory. The file moving process stops, once the tickler file exists. |
rap_flap_stop.sh |
Creates a tickler file in the $RAP_STAT directory. The loading process stops, once the tickler file exists. |
rap_bfap_env_pl.sh |
Sets environment variables. Called by rap_bfap_start.sh and rap_bfap_stop.sh. |
rap_flap_env_pl.sh |
Sets environment variables. Called by rap_flap_start.sh and rap_flap_stop.sh. |
rap_tbl_bcp_pl.sh |
Runs the bcp utility to load data into the Primary Cache database and determines completion status. Issues error messages if errors occurred, and logs trail files. Called by rap_tbl_mon_pl.sh. |
rap_tbl2_bcp_pl.sh |
Runs the bcp utility with arguments to load data into the Secondary Cache database and determines completion status. Issues error messages if errors occurred, and logs trail files. Called by rap_tbl_mon_pl.sh |
rap_tbl_dbisql_pl.sh |
Runs the dbisql utility to load data into the VLDB database and determines completion status. Issues error messages if errors occurred, and logs trail files. Called by rap_tbl_mon_pl.sh. |
rap_tbl_mon_pl.sh |
Looks for new data source files. This is a middle-level process called by rap_flap_start.sh. |
rap_truncate.sh |
Truncates the STOCK_QUOTE and STOCK_TRADE tables in the RAPCache. This script is used during the testing process, so that you can reuse the same data files. |
SQL scripts in the $LOAD_IQ_SCRIPT_DIR directory load the VLDB database.
Script name |
Description |
|---|---|
load_iq_stock_quote.sql |
Loads the STOCK_QUOTE table |
load_iq_stock_trade.sql |
Loads the STOCK_TRADE table |
