This idea has been merged into another idea. The merged idea is not visible in this portal.
During times of high traffic, our client experiences major concurrent access issues on their DB2 platform for an extremely critical and highly-visible client-facing application. They have the maximum number of instances available: 1 primary, 1 primary standby and 2 auxiliary standbys.
In order to avoid some of the access contention issues, the 2 auxiliary standbys are taking some of the read-only requests (which is the lion's share of the traffic) freeing up the primary to serve the read/write traffic more efficiently.
While the solution is working as planned, we would like to increase the number of auxiliary standbys available to maximize the ability shape traffic appropriately based on the function being called (read/write vs read-only).
As this is one of the most critical application databases at our large enterprise client, many of their end customers are affected during a contention event. We've seen connections above 6,000 per second and it can easily spike high above that during the highest-traffic times.
Why is it useful?
|Who would benefit from this IDEA?||As an architect, I would like the ability to increase database availability and concurrent access by horizontally scaling standby instances. As an executive, I would like to ensure that my database platform can burst to manage traffic spikes at my busiest times.|
How should it work?
I don't know the inner workings or potential inherent limitations of the HADR implementation with regards to auxiliary standbys so I have no guidance regarding potential solutions.
The measurable benefits would be to allow for a greater availability commitment for some of our clients with the largest and most frequently-accessed workloads. As our clients gain experience with some of the popular open source database solutions, they're coming to expect more from traditional RDBMS products. We're working diligently to ensure that DB2 remains a strategic platform option for our client.
At the moment, there is no work-around. We are running with maximum 4 instances: the primary, the primary standby (both R/W) and the two auxiliary standbys (R/O).
|Priority Justification||We would like to have a solution in place by the middle of next year in order to have it in place for the most critical databases before the 2020 holiday season. I'm sure that other clients will benefit from the added flexibility that this solution would provide.|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "email@example.com" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions