Reloading the Small Sample Data Set into RAPCache

Reload the smaller TAQ sample data set into RAPCache.

  1. Change to $RAP/RAPCache.
  2. Source the environment variables: source SYBASE.csh or . ./SYBASE.sh.
  3. Change to $RAP/RAPCache/datamodel/scripts.
  4. From a command window on the machine that hosts the Adaptive Server Enterprise database, run the script load_unix_cache_TAQ_tables.sh.

    This script uses the bulk copy utility bcp to load the sample data into the RAPCache rapt and rapq databases. Errors are written to the files STOCK_TRADE.err and STOCK_QUOTE.err.

    To check the status of the data loads, review the log file for Adaptive Server Enterprise. The default location of the log file is $RAP/RAPCache/ASE-15_5/install/servername.log.

Related concepts
TAQ Data Queries