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...
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...
WLM monitor and control total private sortheap usage
Concurrent private sortheap heavy queries run out of system memory and cause systems reboot. ISAS 7700 environment with DB2 v10.1 FP4 on AIX. There are 16 physical nodes running 122 database partitions. The catalog node and coordinator are on one ...
Do not place IBM confidential, company confidential, or personal information into any field.