This procedure is optional. The TAQ sample data provided for the RAP in-memory cache is also loaded into the RAP repository IQ database by the automated load process. The RAP repository TAQ sample data, however, contains millions of additional rows of data.
If you want to load more data than is included for the RAP cache, be sure you have already unzipped and transferred the RAP repository TAQ sample data files STOCK_QUOTE.csv and STOCK_TRADE.csv located in the %Sybase%\Data\IQ\RAP_Input folder on Windows as described in “Preparing the TAQ sample data”.
To run the script that loads the additional TAQ sample data into the RAP repository, you must have the Sybase IQ 12.6 client tools installed on your system.
Run the load_unix_IQ_TAQ_tables.sh script on the machine that hosts the Sybase IQ database. This script truncates existing data and loads the additional TAQ sample data into the RAP repository database.
If you want to preserve the TAQ data already in the
repository, edit the file load_unix_IQ_TAQ_tables.tst and
comment out the following commands:
truncate table DBA.STOCK_QUOTE; commit; truncate table DBA.STOCK_TRADE; commit;
load_unix_IQ_TAQ_tables.tst is called by load_unix_IQ_TAQ_tables.sh.
To check the status of the TAQ data load, review the log file for the Sybase IQ database, <database_name>.iqmsg. The default location of the IQ log file is the directory where the IQ database file (<database_name>.db) is located.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
