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:
Sent: Wed April 23, 2025 11:02 AM
From: Guy Przytula
Subject: hadr to the cloud
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:
Sent: Wed April 23, 2025 08:32 AM
From: Philip Nelson
Subject: hadr to the cloud
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
Original Message:
Sent: 4/23/2025 6:47:00 AM
From: Guy Przytula
Subject: hadr to the cloud
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
------------------------------