Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253

    Unanswered: Information Integrator

    I'm researching different methods by which to replicate data from a DB2 database to a SQL Server database. One of the tools I found was DataJoiner, but it looks like that as of the end of this month, IBM will no longer support DJ.

    The next generation of DJ is Information Integrator. I tried to find a trial edition but no luck. The closest thing is a developer's edition, which runs around $2000.

    Is there anyway to at least "test drive" II?

    Thanks!
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    DB2 for LUW has the Datajoiner functionality built in to it starting in V7.2.
    Version 8.1 has a tool for easily setting up the replication.

    You should not need to buy anything else.

    Andy

  3. #3
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253
    I've been through the Replication stuff for v 8.1 and have seen nothing which would allow me to go to SQL Server. It seems to only support DB2 subscribers.

    If I'm looking in the wrong place, please let me know.

    When defining target servers, only DB2 servers / databases are displayed.
    Last edited by ansonee; 09-13-04 at 15:43.
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Read the Replication guide and the Redbook:
    http://publib-b.boulder.ibm.com/Redb...6828.html?Open

    Look for non-DB2 data sources.

    Andy

  5. #5
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61
    i had developed a multi-threaded data replicator based on unixODBC under linux that can copy/move data from any RDBMS (DB2/SQL/MySQL) and it works fine

    if u need to have a look email me

    hany.hegy@etelvaz.com
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

  6. #6
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253
    I'm working on getting federated support set up on my Wiondows box and am encountering an issue with creating wrappers.

    I try to create a wrapper via Control Center and get the following error:

    The GET_WRAP_CFG_C stored procedure returned an error. Return
    code 48, locale: en_US No properties files were found in
    directory.

    I've run the db2updv8 command, stopped and restyarted the instance, but no change.

    Anyone have any suggestions?

    Thanks!
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

Posting Permissions

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