Question
Consolidated Edison Company of New York Inc
US
Last activity: 26 Apr 2018 7:32 EDT
Rules clean up Scripts after skimming
Hi All,
We are planning a major Infrastructure Upgrade along with Pega Upgrade from 7.2 to 7.3 for our Application. We have a huge code base and we are planning to a major version Skim and code base cleanup. I have verified for some DB scripts in PDN and I found the below. Can anyone help me if the below are fine?
DELETE FROM RULES.pr_sys_decchg WHERE PXRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PXRULESET LIKE 'Pega-%';
DELETE FROM RULES.pr4_rule_property WHERE PYRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PYRULESET LIKE 'Pega-%';
DELETE FROM RULES.pr4_rule_file WHERE PYRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PYRULESET LIKE 'Pega-%';
DELETE FROM RULES.pr4_fieldvalue WHERE PYRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PYRULESET LIKE 'Pega-%';
DELETE FROM RULES.pr4_rule WHERE PYRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PYRULESET LIKE 'Pega-%';
DELETE FROM RULES.pr4_rule_flow WHERE PYRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PYRULESET LIKE 'Pega-%';
It would be really helpful if some one share me the list of scripts in correct order of execution for Code base clean up after skimming?
***Updated by moderator: Lochan to move post from Applications to PSC***
Citicorp Services India Private Limited
IN
Hello Srinivas,
By default Pega build comes with the cleanup.bat / cleanup.sh scripts to remove the ruleset versions older than the current version you were upgrading from. Please refer the upgrade guide for pega 7.3 for more information. https://docs-previous.pega.com/pega-73-platform-upgrade-guide.
Here is the snippet from the upgrade guide:
In most cases, removing older rules decreases the overall upgrade time. Running the cleanup script permanently removes rules older than the current version from which you are upgrading. For example, if you are upgrading from PRPC 6.2 SP2 (06-02-20) to 7.3, cleanup removes rules of version 06-01-99 and older. Run the cleanup.bat or cleanup.sh script to generate an SQL script to clean up the rulebase. You can either have the cleanup.bat or cleanup.sh script automatically apply the SQL script, or have your database administrator make the changes.
Once the scripts get generated, pass in the appropriate version number to delete those corresponding ruleset. I hope you would not want to delete all the versions prior to 7.2.
Please let me know if this helps.
Thanks,
Gowrishankar.