Question

Pega application - running in different DB versions will it have any SQL generation issues

we have database version Oracle 12c in Dev/ SIT /UAT /OAT in prod alone we have Oracle11g

both the version is compatible as per the platform guide. not sure what are the impacts when we try to promote code which is designed in latest db version to the production which old version

I know pega will dynamic do SQL generation based on rule change or run time scenarios

please advise on the impact which we can expect and would like to prepare for it

Correct Answer
September 20, 2019 - 7:05am

I don't think anyone can predict the impact. However, from Pega's perspective, SQL generation should work on either DB versions. I would expect your Pre-Prod should be in line with Prod env, otherwise, there is no way of testing before moving the code to Prod - any reason what that is case? The biggest impact I can possibly think of is the performance. Oracle 12c is a newer version and supposed to be better - so you could have the situation where everything works fine in lower env and not so well in Prod env. I am also aware of special cases Oracle 12c optimizer performs worse.

Comments

Keep up to date on this post and subscribe to comments

September 20, 2019 - 7:05am

I don't think anyone can predict the impact. However, from Pega's perspective, SQL generation should work on either DB versions. I would expect your Pre-Prod should be in line with Prod env, otherwise, there is no way of testing before moving the code to Prod - any reason what that is case? The biggest impact I can possibly think of is the performance. Oracle 12c is a newer version and supposed to be better - so you could have the situation where everything works fine in lower env and not so well in Prod env. I am also aware of special cases Oracle 12c optimizer performs worse.