Question

4
Replies
186
Views
Close popover
Krishnaprakash Chandrasekaran (KrishnaPrakashC)
RABO Bank

RABO Bank
NL
KrishnaPrakashC Member since 2015 5 posts
RABO Bank
Posted: March 6, 2018
Last activity: March 8, 2018
Closed

Cleanup unused tables from Data schema after upgrade in Production

We did upgrade from 6.2 to 7.2.1 from single schema to split schema and cleaned up the unused rule tables from Data schema using Optimize schema wizard. This is in Development environment hence our production level is 2 and we had all the privileges to see optimize schema wizard.

Now, we are writing down steps for Production upgrade and we found out there are two ways to do this,

1. Change production level to 2 in PROD environment and execute optimize schema wizard to cleanup OR

2. Collect all the cleanup queries from Lower environment and run it manually on the DB side for PROD.

But, apart from these steps is there any PEGA command line utility to do this job in Production?

If not which option(1 OR 2) mentioned above will be a best fit in production environment?

Looking forward for a quick answers from experts who performed the upgrade in Prod.

System Administration Upgrades
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.