Question
Alight.com
IN
Last activity: 15 Jan 2025 21:25 EST
Guidance on Cleaning OOTB Cache Tables and Data Folders for Pega Upgrade
Hi Team,
We are planning to upgrade from Pega 8.8.3 to Pega 24.1.1 soon. Could you please provide the following information:
-
List of OOTB Cache Tables to be Cleaned:
- Could you suggest the list of out-of-the-box (OOTB) cache tables that should be cleaned during the upgrade process to ensure optimal performance?
-
Cleaning Up Kafka-Data and Cassandra-Data Folders:
- Could you provide insights on cleaning up the
kafka-dataandcassandra-datarelated folders? Specifically, we would like to know if it is safe to clean up any previous data that gets written into these folders post-upgrade.
- Could you provide insights on cleaning up the
We appreciate your assistance with these queries as we prepare for the upgrade.
Thank you!
HCA Healthcare
US
@RavikiranN7109 To ensure a smooth upgrade from Pega 8.8.3 to 24.1.1, it's important to clean specific cache tables and data folders. Common OOTB cache tables to clean include pr_sys_statusnodes, pr_perf_stats, pr_sys_updatescache, pr_sys_appcache_dep, pr_sys_appcache_entry, and pr_sys_lru_cache. Before cleaning, ensure all Pega nodes are shut down and back up the database. Cleaning these tables will help remove stale or unused data, improving performance. For kafka-data and cassandra-data folders, back them up first, then safely delete older log files or temporary data that’s no longer required. Avoid deleting entire folders unless you are certain the data is no longer used. Always test the cleanup in a non-production environment first and monitor logs after restarting the system to ensure no critical data was removed. Thanks