Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Malay Thakkar
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 ]
 
Monty Ireland
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic