Results 1 to 5 of 5
  1. #1
    Join Date
    May 2013
    Posts
    2

    Unanswered: Connecting Oracle From DB2

    Dear Friends,

    I want to connect Oracle database from DB2 Workgroup Server Edition, I am Oracle DBA, we reqired some of data selection from Oacle Database.

    How can we established link between DB2 to Oracle database.

    Thanks
    Sohil Kakadia

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this is only possible with federation feature installed (not for free)
    IBM DB2 9.7 for Linux, UNIX and Windows Information Center
    look for federation
    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 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    May 2013
    Posts
    2
    Thanks for Update

    We have DB2 10.1

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as it was not indicated, I just published the link for 9.7
    look in infocenter v10r1 - federation has not changed...
    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 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Mar 2006
    Location
    Bogota, Colombia
    Posts
    21

    Table function

    Hi,
    If you try to select just some data from Oracle, without taking care of the performance or things like that, and you only want to retrieve data, then you can create a table function in DB2 implemented in Java, for example. In the Implementation you create two connections, one from DB2 with the 5 steps for a table function, and the other is used to query Oracle.
    AngocA

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
  •