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
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...
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...
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...
Enhance Db2 WLM to enable it to prioritize access to physical I/O
We have a Db2 AESE 11.1 fp4a mixed use (but no column tables) data warehouse on an AIX 7.2 LPAR that is limited to 75K IOPS by NetApp. When the threshold is met, high priority OLTP queries submitted by our 1000 retail store POS systems can hang in...
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...
Do not place IBM confidential, company confidential, or personal information into any field.