Clearing the Cache

Clear the data from RAPCache on a regular schedule, as the data is permanently stored in RAPStore and is redundant in the cache.

Clear the cache manually or automatically:

Option	Action
Clear the cache manually	Use Interactive SQL (isql) to run truncate_cache_TAQ_tables.sql, in $RAP/RAPCache/datamodel/scripts. The script clears the data by truncating the `STOCK_TRADE` and `STOCK_QUOTE` tables in the RAPCache.
Clear the cache automatically	In the OpsConsole, create a truncation rule to perform regularly scheduled clean-up. See RAP - Operations Console Users Guide > Data Administration > Creating a Truncation Rule.

Option

Action

Clear the cache manually

Use Interactive SQL (isql) to run truncate_cache_TAQ_tables.sql, in $RAP/RAPCache/datamodel/scripts.

The script clears the data by truncating the STOCK_TRADE and STOCK_QUOTE tables in the RAPCache.

Clear the cache automatically

In the OpsConsole, create a truncation rule to perform regularly scheduled clean-up. See RAP - Operations Console Users Guide > Data Administration > Creating a Truncation Rule.

Watch for errors and resolve as needed.

If errors occur during manual truncation, you see a message, and error messages are written to truncate.err.

If errors occur during rule-based truncation, you see a status of Failed in the Truncation Summary in the OpsConsole Truncations subtab. The Detailed Truncation History in the OpsConsole Truncation History subtab shows an error code.