Question

9
Replies
1783
Views
ANGLINA1 Member since 2005 10 posts
American Express
Posted: May 17, 2016
Last activity: October 4, 2018
Closed
Solved

How can I Migrate the entire PEGA data schema from DB2zOS to ORACLE 12c Database?

Hello Mesh I am tasked with the migration of all the data from the data schema in PRPC 7.1.7 from DB2zOS down to Oracle 12c database. I would like to find the best solution for this task that works. I am able to move the entire RULES schema and its contents from the mainframe to Oracle using the PEGA Migrate script utilizing the bulk mover process and that works fine. The problem is the Migrate script does not move the data schema.

Things I have tried.

Using DB2 utility to do a unload of the data from the tables the problem is the LOB the Unload utility places the LOBS in PDS as members and because of this we cannot create one file to FTP down.

Oracle is not recommending the use of Golden Gate for the initial move they are recommending to create a flat file send it from the mainframe first as the initial load and use SQLLOADER to populate the oracle database.

Idea I have.

If there was some way to be able to make a clone like how the migrate process does it for the RULES table and then unload the data the same way would be the ultimate solution.

Can the forum provide any way that they have done this migration process before that works so I may leverage it going forward?

Thanks

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

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