Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Vishal Jawahar M (VishalJ2)
Amex

Amex
IN
VishalJ2 Member since 2013 6 posts
Amex
Posted: May 30, 2018
Last activity: Jun 27, 2018
Posted: 30 May 2018 23:10 EDT
Last activity: 27 Jun 2018 11:57 EDT
Closed

Migration to Oracle 12C from DB2 during upgrade

Hi

We are planning to upgrade our application from Pega v6.2 SP2 to Pega 7.3.1. However, our current Pega DB is IBM DB2 LUW and we have a proposal to migrate Pega DB to Oracle 12C along with the upgrade. Is this feasible?

Thanks,

Vishal

***Edited by Moderator Marissa to update categories***

To see attachments, please log in.
Installation and Deployment
Data Integration
Updates
Support Case Exists

  • Rajit Kumar Nookala
Posted: 6 years ago
Posted: 31 May 2018 4:48 EDT
Laurence Brannigan (LaurenceB_GCS)
PEGA
Senior Software Solutions Engineer
PEG
GB

Others may disagree, but I'm not sure whether it would be advisable to perform the change of DB flavour at the same time as the upgrade. If you run into problems, it may be difficult to determine which of these factors caused or led to the problem. Although this decision may also depend on your timelines.

Please note, I don't have any direct experience of migrating from DB2 to Oracle. But off the top of my head, as a pre-upgrade check I'd suggest you: -

1. Check DB2 table/column limits to ensure they are 30 chars or less (this is the Oracle limit)

2. Have you defined any custom Connect-SQL rules that need to be reworked for Oracle

3. Have you defined any Function Aliases that would need to be reworked for Oracle

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice