Question
RABO Bank
NL
Last activity: 8 Mar 2018 3:51 EST
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.
EPAM Systems, Inc.
ES
Hi @KrishnaPrakashC,
Thanks for posting on PSC.
I would suggest going with Optimization wizard rather deleting manually from the database.
Optimization wizard may not remove all your duplicate tables, but as of now, it's only and the best way to remove unused tables.
As you have privileges, so you would be able to have Optimization wizard available. Refer
Hope it helps in addressing your business use-case, kindly notify by marking this post as answered/helpful if it does for larger Pega audience and tracking purposes.
Regards,
Asif
RABO Bank
NL
Hi @Asif_Hasan,
Thanks for the response!
In order to get the optimization wizard we need to set the production level to 2 in PROD environment and then after finishing the process we need to reset it back to 5. These are manual steps which we want to avoid in PROD environments this is the reason I asked for any command line utility which does the same job.
Do you think doing these steps manually in PROD is preferred by PEGA?
EPAM Systems, Inc.
ES
I got your point. This process can be initiated from either IUA wizard or the command line using upgrade.bat or upgrade.sh script.
Refer it for complete detail on upgrading and cleaning up ruleset. Do refer, Clean up section and comments on this post as well.
Hope it helps, feels free to post your query.
RABO Bank
NL
@Asif_Hasan Thanks for the info but we already looked at this script it only provides cleaning for older rules from the rule tables in rule schema not deleting unused rule tables from data schema. For now we have to do the manual steps for PROD i guess. Thanks for your help.