Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011

    Question Unanswered: Extract data from DB2 to Oracle

    Hi guys,

    I need to connect a DB2 server outside my firm to extract the data and import to my Oracle DB. This action has to be taken periodically. Efficient performance is necessary. How could I do that? I tried to use Access 2007 with ODBC to connect the DB2 and import to my Oracle DB (using ODBC). It worked but the performance is unacceptable. It took 40 minutes to extract the data from a view with 5 columns with 100,000 data amount. Any better suggestions? Please help. Thanks a lot!!.


  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    try to use the export command in command line..
    see with explain if the access-path to data is as expected..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts