This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
Shape the future of IBM!
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updateson them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
This IDEA it to request a more dynamic management of PREFETCHSIZE when it is set to AUTOMATIC. The documentation states: "The database updates the prefetch size automatically whenever the number of containers in a table space changes (following su...
We need an activity threshold to trigger an action whenever a specific activity consumes more than a given amount of transaction log space. I know that there is already some control mechanism by using DB CFG parameters MAX_LOG and NUM_LOG_SPAN , b...
Work identification based on number of subsections in a statement.
Work identification can currently be done based on Estimated cost, Estimated cardinality, Estimated data accessed. Ref: "Work identification by type, cost, or data accessed with work classes - IBM Documentation" This allows for identification of c...
Application connections storm slow downs the DB response
I've been assisting with an ecommerce site. During typical days, let's say non-peak/low volume of orders, the DB response is always good. However, the DB response time slows down for a few seconds, notably during peak season/high amount of orders....
new aggregated WLM threshold for LOCKLIST at workload/service class level
We have MAXLOCK db-cfg parameter which can be used to avoid a single connection (UOW) to consume the LOCKLIST space. But this parameter some times it not enough. I have seen LOCK escalation cases happening (which locked system tables, causing huge...
Mechanism to identify a workload and adjust memory values
Workloads can be different in a database, executed at different times. When the STMM is active, and a workload (let's say A) runs for several hours, then the memory will be fine adjuted for the workload at the end of the execution. However, for th...
Lowering the limit for ACTIVITYTOTALTIME and UOWTOTALTIME
We should be able to trap the transaction that spent more than 10 seconds with a threshold. Can we change the low limit of the parameter ACTIVITYTOTALTIME and UOWTOTALTIME to allow a magnitude of milli second.
Do not place IBM confidential, company confidential, or personal information into any field.