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
page_age_trgt_mcr is a kind of successor of SOFTMAX and provides the possibility to control the flushing of modified buffer pool pages to table spaces based on time. Unfortunately page_age_trgt_mcr is just configurable, not configurable ONLINE. Th...
Enhance automatic SORTHEAP management by fixing the defined base value as the minimum for STMM
As we had an issue with STMM reducing the SORTHEAP too much during lower load on the database, we would like to see the defined base value for the sortheap treated as the minimum value, that STMM would not reduce the sortheap below that value if t...
Expand db2 autoconfig to identify configuration settings less than default value
Db2 autoconfig is one way to identify configuration settings that are less than the current default of the current release. Since in-place upgrades preserve the configuration settings from the previous release, DBAs must manually find and determin...
Make SYSMON group configurable online. Currently an outage is required to set or change SYSMON. While some DBAs set this whenever they build a system, others do not, and it is frustrating to request this fairly common level of permissions and to h...
NUM_LOG_SPAN species a number of log files. If the number of log files changes (LOGPRIMARY, LOGSECONDARY, LOGFILSIZ) the absolute number of NUM_LOG_SPAN should be adjusted as well. If NUM_LOG would be a percent value of the primary log files there...
Allow fixed MAXLOCKS value even if LOCKLIST is AUTOMATIC
When LOCKLIST is set to AUTOMATIC, the MAXLOCKS setting cannot be set. https://www.ibm.com/support/pages/locklist-and-maxlocks-database-configuration-parameters-and-lock-escalations In general this follows the concept of LOCKLIST AUTOMATIC, but th...
MAX_QUERYDEGREE allows to specify the maximum degree of parallelism for a query. The setting of ANY is usually to aggressive for typical Db2 SAP systems. Specifying an absolute value has the disadvantage of having to adjust the parameter for every...
Make DB2_USE_ALTERNATE_PAGE_CLEANING=ON the default
DB2_USE_ALTERNATE_PAGE_CLEANING is of great benefit for performance and scalability since it was introduced in v8. It's now the default in pureScale and BLU environments, so why can't we make it the default all around?
Do not place IBM confidential, company confidential, or personal information into any field.