IBM Data and AI

Welcome to the IBM Data and AI Ideas Portal for Clients!

We welcome and appreciate your feedback on IBM Data and AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal. If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
Clients:
  • Our team welcomes any feedback and suggestions you have for improving our offerings / products! This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

  • If you have not registered on this portal please click on the following link and register. To complete registration you will need to open the email you will receive from Aha to confirm your identity. http://ibm.biz/IBM-Data-and-AI-Portal-Register

Additional Information:
  • The shorter URL for this site is: https://ibm.biz/IBM-Data-and-AI-Ideas

  • To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

  • Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

 

Merged idea

This idea has been merged into another idea. The merged idea is not visible in this portal.

Increase the number of auxiliary standby DB2 11 LUW database instances Merged

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.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Dec 8 2019
  • Future consideration
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).

Idea Priority Medium
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.
Customer Name
Submitting Organization
Submitter Tags

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 "anonymous@euprivacy.out" 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