KrishnaPrakashC Member since 2015 5 posts
Posted: 2 years ago
Last activity: 2 years 6 months ago

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.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn