Db2 11.5 is here and with it comes a bunch of new features and changed behaviors in the area of Availability & Recovery that should make your every day tasks easier. Check out the list that includes items like Advanced Log Space Management, Reduced Logging and better HADR Reads on Standby.
Thinking about your availability and recovery strategy shouldn't give you sleepless nights. Db2 understands the importance of keeping your database online 24x7 and with Db2 11.1 / 11.5 and its continuous delivery of new features and enhancements, you are on the right path of achieving such goals.
When the DB2 HADR feature is enabled, the primary database's transaction logs are replicated to one or more standby databases in real time. The replication provides HA and DR protection, at a cost. The replication adds overhead to the primary's log writing.
This article sheds a little light on the inner workings of dynamic workload balancing of distributed connections, and how this can benefit the performance, scalability and availability of your DB2 for z/OS solutions.
When the term high availability is brought up, most DBAs reflexively think of technical solutions to help keep a system or database available for users – However, there is so much more to availability than simply ensuring that a database is available for a user to connect to.