Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005

    Question Unanswered: database replication tools for iSeries & UDB V8.2 for

    We have two systems: iSeries V5R1 and UDB V8.2 for AIX. We are looking for replication tools for these two databases. We are newbie to do database replication and have no knowledge on this issue. We searched for the information on web and found "IBM DataPropagator for iSeries" and "Websphere Information Integrator" may get in use. However, it is stated that the DataPropagator is for iSeries V5R2 or above and the Integrator is for z/OS.

    Does anyone having experience on replicate database between iSeries and AIX? And any other tools/methods can help to do replication? or any other suggestions?

    Many thanks.

  2. #2
    Join Date
    Mar 2009

    Iseries Replication to Mysql, Oracle, Iseries or whatever

    I have set up a replication between AS/400 and Mysql with Hibernate.

    I hang a trigger on a table which sends the primary key in a dataqueue.
    I have written a dataqueue ressource adapter(JCA) which converts the
    dataqueue message into a JMS Message and stores it in a JMS queue.
    The ressource adapter will be open source soon.

    Here i fetch the message, load the entity with hibernate and persist
    the entity on mysql.

    The complete scenario is handled with about 20 lines of code and
    exclusive with open source tools.

  3. #3
    Join Date
    Apr 2006
    Provided Answers: 11
    data replication is supported on i series and aix
    capture should be started at as400 and apply can run on any location, as long as it can connect to source and target
    wesp. ii is not needed in this scenario
    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

Posting Permissions

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