Moving UDB database to Db2 on z/OS

Keith Hooley · Posted: Wed Sep 27, 2017 12:38 am

We have a requirement to move a UDB database to Db2 on z/OS. I've found numerous articles on going the other way (Db2 to UDB). I know there are products to move UDB to Db2 but I am interested in hearing from anyone who has done this, either by using a vendor product or an "in house" developed process.
Our customer first tried to move the UDB to Oracle but said the data conversion process was taking too long and now they want it on Db2.

farhad_evan · New User Joined: 30 Aug 2014 Posts: 24 Location: UK

Hi
How big is your database ? How many objects and rows you need to move ?
We have done it for a small database with 100 tables.
We defined the UDB database as remote db on Db2 z/OS and used load cursor to moved data between them.
Unfortunately we didn't any tools to move structure of database

so we did it by ourselves and used a small REXX to generate the load's jobs.

Keith Hooley · Posted: Wed Sep 27, 2017 8:12 pm

Thanks for your response. So far what they've told us is 2 or three tables with up to 10,000,000 rows on the largest table. However, I'm guessing that may change as we get more details from the customer.
We have the UDB location defined in our LOCATIONS table on z/OS. After you created your structures on Db2 z/OS, did you have any problems or challenges with data conversion between UDB and DB2?
We have the DB2 analytics accelerator and have the DB2 loader where we can load IMS, VSAM and sequential data to the Db2 accelerator. We have a call out to IBM/Rocket Software to see if there is a plugin for the Loader that will allow UDB data to be loaded to the accelerator. I will post any subsequent updates. I will leave this topic open until we get a final resolution.

farhad_evan · New User Joined: 30 Aug 2014 Posts: 24 Location: UK

we had same code page on both databases. The only problem was in communication between two systems and it solved with BIND some packages.
Anyway I think if average row length of your tables aren't too big you can do it very easily.
If I may ask, Why you need use of DB2 z/OS instead of DB2 UDB ? I mean is there any problem with DB2 UDB ?

Keith Hooley · Posted: Wed Sep 27, 2017 9:25 pm

They haven't told us why they need to move off UDB. I know that UDB is in containment. There is a planning meeting very soon to decide course of action and we want to be prepared to answer any of their questions. Db2 for z/OS is one of the targets they are considering.
I will leave this topic open for a while longer until I have more information. If Db2 is not selected, I will close this post. If Db2 is chosen, I will post our experience and then close it.