Clearing the Cache

Clear the data from the RAPCache on a regular schedule.

Use Interactive SQL (isql) to run the script truncate_cache_TAQ_tables.sql.

The script truncate_cache_TAQ_tables.sql is located in the $RAP/RAPCache/datamodel/scripts directory. It clears the data by truncating the STOCK_TRADE and STOCK_QUOTE tables in the RAPCache.

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


Created October 8, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com