Unanswered: Extracting DB2 data from MVS to Oracle on unix
We have DB2 Database (ver:7.1) on Mainframe and Oracle on Unix box.We are trying to extract data from DB2 and populate Oracle tables. Also we need to update the changes from Db2 to Oracle at regular intervals of time.
We have Db2 connect installed.
What are different ways to achieve this tast and which is best.
Any help in this regard would be appreciated.
One method is the Oracle Transparent Gateway for DB2 (TG4DB2). I think Oracle sells it for $10K per server, but checkout www.oracle.com to be sure.
After installing the Oracle Client software on MVS, you can then use TG4DB2 to access the DB2 database as if it were another ORacle database. For example, in your Oracle database you create an Oracle dblink pointing to the DB2 database, but the link will think it's an Oracle-to-Oracle connection. You can even run Oracle Replication to push data to DB2, or use views or MViews to pull data. If you want to pull data on a frequency, then in your ORacle database you can use a dbms_job that periodically executes an Oracle stored procedure, which in turn queries data from the remote database into your Oracle database. MViews do the same thing, but in a more complex way (and you know that's a good thing as well as a bad thing, if you've ever used MViews before.)