• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • paul wheaton
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Tim Holloway
  • Carey Brown
  • salvin francis

Want to do data transfer from DB2 on OS390 to Oracle database on solaris

 
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have to do some data transfer from DB2 on OS390 to Oracle database on Sun Solaris.This is a more of a batch process where at some time this process will be triggered and data transfer will take place. I have a doubt here like which stratergy to follow for this like I perceive two options for this :
1. Write a Java class which will connect to DB2 database thru JDBC type 4 driver by IBM then connect to the DB2database and create a XML file and then parse tht XML file and then move to Oracle database.
2. From DB2 database get the data in XML format and then parse the XML file and pass to Oracle database.I want to know whether these option is feasible or if u can give some other solution which can be still easier.Also how to go about it.I want to know can there be a utility to convert the data in DB2 to XML files.

Thanks & Regards
Malay
[ May 16, 2002: Message edited by: Malay Thakkar ]
 
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Option #3
Port your data outside of java.
Try using the standard utilities provided by either vendor.
 
Malay Thakkar
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Monty,
Thanks for replying I will appretiate if u can elobrate your option 3 slightly,I mean can u tell me if you have implemented such option then by using the utilities.......I desperatley want some solution on this.
I will narrate my problem faced:
I have written a Java class which will access the DB2 database on OS390 using the JDBC type 4 driver but am unable to access DB2 system on OS390.I want do do data synchronization with DB2 on OS390 and Oracle on Solaris.
Kindly do let me know some solution immediately.!!!
Thanks & Regards
Malay
 
Good night. Drive safely. Here's a tiny ad for the road:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!