Question

9
Replies
1797
Views
Audlian Anglin (ANGLINA1)
American Express
Senior Engineer
American Express
US
ANGLINA1 Member since 2005 11 posts
American Express
Posted: May 17, 2016
Last activity: October 4, 2018
Posted: 17 May 2016 20:49 EDT
Last activity: 4 Oct 2018 13:54 EDT
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


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 System Administration Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.