Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  hadr to the cloud

    Posted 04/23/25 06:47 AM

    the customer has a db2 hadr setup between 2 datacenters

    they requested if it is supported, to have a second standby, with delay option, super asynch mode to a database in the cloud

    I could not find a doc talking about this or specifying requirements/restrictions

    any idea if it is supported and if any requirements ?



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------


  • 2.  RE: hadr to the cloud

    Posted 04/23/25 08:32 AM
    Guy,

    It depends on what you mean by "in the cloud".

    If you are talking about DBaaS (e.g. the managed Db2 on Cloud or Db2 Warehouse on Cloud) then you wouldn't be able to use these since the whole environment is managed by IBM and the cloud provider.

    But if you mean IaaS, where you essentially install and manage your own Db2 on an operating system instance provided by one of the hyperscalers then this is not a problem, since you have complete control over the environment.  Essentially it is just another server in somebody else's data center.  

    You'll need to sort out the two-way network connectivity between the server in the cloud and your existing servers.  There are a bunch of ports you'll need to expose - not just the ones you specify in the HADR config.

    You will also need to ensure that the backups / load copies on the current servers become available to the cloud environment.   These are needed to keep the standby up to date when you (for example) run a LOAD ... LOG NO.   Exactly how you do this will depend on how you manage these internally.  If you are using TSM then you'll need to look at potentially changing things around.  If you are using some sort of shared file system such as NFS then you should be able to extend that sharing into the cloud environment (or perhaps change to using a cloud based file sharing such as S3 buckets).  But beware that this may expose you to egress charges if you then read this back to your on premise servers.

    I've got a document on setting up Db2 on AWS.  If you want this reach out to me privately.   

    HTH

    Phil






  • 3.  RE: hadr to the cloud

    Posted 04/23/25 11:02 AM

    thanks for the update. as you mention "I've got a document on setting up Db2 on AWS" - any doc is welcome as all of this, is all new to me



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    Original Message


  • 4.  RE: hadr to the cloud

    Posted 04/24/25 03:49 AM

    Hi Guy,

    In addition to everything Phil already said, you may also need to deal with NAT (Network Address Translation) when you go hybrid (i.e. include on-prem and cloud nodes in your HADR cluster).
    I recently wrote an article on configuring HADR clusters in such environments, which must be done slightly differently than a standard HADR setup:

        https://www.triton.co.uk/db2-hybrid-hadr-clusters/

     HTH!

    Regards, Damir



    ------------------------------
    Damir Wilder
    Senior Consultant
    Triton Consulting
    London
    ------------------------------

    Original Message


  • 5.  RE: hadr to the cloud

    Posted 04/24/25 04:09 AM

    many thanks for answer and doc



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    Original Message


Related Content