Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Moving UDB database to Db2 on z/OS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Moving UDB database to Db2 on z/OS
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Moving a COMP-3 Variable to a Numeric... ajayachander COBOL Programming 2 Thu Dec 14, 2017 5:46 pm
No new posts Moving a PS file as body of a mail! Vignesh Sid JCL & VSAM 4 Tue Nov 21, 2017 9:23 pm
No new posts Moving values to a variable of copybo... Vignesh Sid COBOL Programming 6 Wed Sep 06, 2017 1:04 pm
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Moving a PD to PD spoorni DFSORT/ICETOOL 8 Fri Oct 07, 2016 9:52 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us