Moving the scripts to the server  Chapter 3: Cache Database Setup

Chapter 2: Repository Database Setup

Running the RAP repository database setup and load scripts

To run the scripts that setup the RAP repository and load the sample data into the reference tables, you must have the Sybase IQ 12.6 client tools installed on your system.

After you make the appropriate changes to the scripts, run the rap_setup.sh and load_unix_rap_tables.sh scripts (in this order) on the machine that hosts the Sybase IQ database. These scripts start the processes that complete the RAP repository database setup and load the reference table sample data.

NoteNote The scripts executed by rap_setup.sh create global temporary tables and set Sybase IQ database options.

To check the status of the data loads, 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.

Refer to the section “Loading additional TAQ sample data” in Chapter 4, “Loading TAQ Data” for information on loading sample data into the STOCK_TRADE and STOCK_QUOTE tables in the RAP repository.





Copyright © 2005. Sybase Inc. All rights reserved. Chapter 3: Cache Database Setup

View this book as PDF