Clear the data from the RAPCache on a regular schedule, as the data is permanently stored in the VLDB database and is redundant in the cache. The script rap_truncate.sh, located in the $RAP_HOME directory, clears the data by truncating the STOCK_TRADE and STOCK_QUOTE tables in the RAPCache.
The script rap_truncate.sh can be run manually or called from your own scheduling program. This script depends on the environment variables set by rap_flap_env.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.
The RAP Operations Console also has an option to delete data from the RAPCache database using the Data Synch agent. See the Risk Analytics Platform Administration Guide for more information on the Operations Console and the Data Synch agent.