Question
LTIMindTree
US
Last activity: 30 Jun 2017 18:04 EDT
How to clean declarative network using DB
Hi,
We have UAT environment where we are using many business rules for our application. UAT team is complaining about the performance of the environment. We need to clear the declarative network from DB level. Can someone please let me know
- what is the DB table (name) in pega PRPC where these data stores.
- How to clean up this table.
BUPA
AU
Hi Nagendra,
Ideally SMA should be used to clear the cache if instructed or advised by Pega GCS. DB cache truncation is not advised by Pegasystems unless there is no alternative and it is strongly advised by Pegasystems. Pls perform a full DB backup before clearing the cache table from DB. Better to check with Pega GCS.
DB Query for cache cleaning:
TRUNCATE TABLE PEGA_RULES.PR_SYS_APPCACHE_DEP;
TRUNCATE TABLE PEGA_RULES.PR_SYS_APPCACHE_ENTRY;
TRUNCATE TABLE PEGA_RULES.PR_SYS_APPCACHE_SHORTCUT;
TRUNCATE TABLE PEGA_RULES.PR_SYS_CACHE_DEP;
TRUNCATE TABLE PEGA_RULES.PR_SYS_CACHE_IMPL;
TRUNCATE TABLE PEGA_RULES.PR_SYS_CACHE_ENTRY;
TRUNCATE TABLE PEGA_RULES.PR4_RULE_SYSGEN;
TRUNCATE TABLE PEGA_RULES.PR_ASSEMBLEDCLASSES;
Steps from SMA:
Hi Nagendra,
Ideally SMA should be used to clear the cache if instructed or advised by Pega GCS. DB cache truncation is not advised by Pegasystems unless there is no alternative and it is strongly advised by Pegasystems. Pls perform a full DB backup before clearing the cache table from DB. Better to check with Pega GCS.
DB Query for cache cleaning:
TRUNCATE TABLE PEGA_RULES.PR_SYS_APPCACHE_DEP;
TRUNCATE TABLE PEGA_RULES.PR_SYS_APPCACHE_ENTRY;
TRUNCATE TABLE PEGA_RULES.PR_SYS_APPCACHE_SHORTCUT;
TRUNCATE TABLE PEGA_RULES.PR_SYS_CACHE_DEP;
TRUNCATE TABLE PEGA_RULES.PR_SYS_CACHE_IMPL;
TRUNCATE TABLE PEGA_RULES.PR_SYS_CACHE_ENTRY;
TRUNCATE TABLE PEGA_RULES.PR4_RULE_SYSGEN;
TRUNCATE TABLE PEGA_RULES.PR_ASSEMBLEDCLASSES;
Steps from SMA:
- Access the System Management Application.
- Click Advanced > Declarative Rules Management > Clear