IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Moving UDB database to Db2 on z/OS


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Keith Hooley

New User


Joined: 25 Sep 2017
Posts: 3
Location: United States

PostPosted: Wed Sep 27, 2017 12:38 am
Reply with quote

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.
Back to top
View user's profile Send private message
farhad_evan

New User


Joined: 30 Aug 2014
Posts: 24
Location: UK

PostPosted: Wed Sep 27, 2017 7:40 pm
Reply with quote

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 icon_confused.gif so we did it by ourselves and used a small REXX to generate the load's jobs.
Back to top
View user's profile Send private message
Keith Hooley

New User


Joined: 25 Sep 2017
Posts: 3
Location: United States

PostPosted: Wed Sep 27, 2017 8:12 pm
Reply with quote

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.
Back to top
View user's profile Send private message
farhad_evan

New User


Joined: 30 Aug 2014
Posts: 24
Location: UK

PostPosted: Wed Sep 27, 2017 9:10 pm
Reply with quote

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 ?
Back to top
View user's profile Send private message
Keith Hooley

New User


Joined: 25 Sep 2017
Posts: 3
Location: United States

PostPosted: Wed Sep 27, 2017 9:25 pm
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts What database does Jobtrac use CA Products 4
No new posts Moving Or setting POINTER to another ... COBOL Programming 2
No new posts Capturing COBOL job and program names... All Other Mainframe Topics 2
No new posts Products/Tools to Optimize Adabas Dat... Compuware & Other Tools 2
No new posts AUTHORIZED database error in HALDB IMS DB/DC 2
Search our Forums:

Back to Top