Checking the load process  Appendix A: Sample ASE Configuration Settings

Chapter 4: Loading TAQ Data

Clearing the cache

Clear the data from the RAP cache on a regular schedule, as the data is permanently stored in the RAP repository and is redundant in the cache. The script rap_truncate.sh, located in the installation directory %Sybase%\Scripts\RAP_Load_Scripts, clears the data by truncating the STOCK_TRADE and STOCK_QUOTE tables in the RAP cache.

The script rap_truncate.sh script can be run manually or called from your own scheduling program. This script depends on the environment variables set by the set_rap_env_pl.sh as described in “Setting the environment variables”.

If errors occur during the truncate process, a message is displayed and error messages are written to the file truncate.err.





Copyright © 2005. Sybase Inc. All rights reserved. Appendix A: Sample ASE Configuration Settings

View this book as PDF