Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Data Replication with DB2 SaaS

    Posted Mon September 23, 2024 10:45 AM

    Hello,

    How have you been working with data replication from a DB2 SaaS (IBM Cloud) database to an on-premise DB2 Community database, for example? Does anyone have any suggestions on how to do this?

    Best regards,



    ------------------------------
    Márcio Dantas
    dantas@cxpbrasil.com.br
    ------------------------------


  • 2.  RE: Data Replication with DB2 SaaS

    Posted Tue September 24, 2024 11:14 AM
    Edited by Gerhard Paulus Tue September 24, 2024 11:17 AM

    Hello Márcio,

    I am not really sure if it works or is supported right now because there are only Cloud databases listed in the Features and capabilities of IBM Data Replication (Cloud).

    The very first requirement to access on-prem databases from the IBM Cloud is to

    1. provision the cloud product Satellite and 
    2. configure a Satellite connector and
    3. starting the Satellite agent for the location and
    4. add a Satellite endpoint to the on-prem db2.

    https://cloud.ibm.com/docs/satellite?topic=satellite-understand-connectors

    When the Satellite connector, agent and endpoints are configured then the db2 on-prem database is accessable from IBM Cloud services like IBM DataStage (tested) and I assume also IBM Data Replication (but not tested yet).

    Best regards,
    Gerhard



    ------------------------------
    Gerhard Paulus
    Senior Consultant
    mip GmbH
    München
    ------------------------------



  • 3.  RE: Data Replication with DB2 SaaS

    Posted Thu September 26, 2024 03:51 PM

    I would recommend you to try 'remote capture'. You can run capture program on anther VM, remotely connecting to Db2 SaaS. 
    I have not tried this option before, but I use the same approach for RDS Db2 which is AWS version of managed Db2 service.  



    ------------------------------
    Feng Cai
    Database Consultant
    Amazon Web Services
    Vernon Hills IL
    224-504-7677
    ------------------------------