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
A DB cfg parameter to set the default tablespace to prevent objects ending up in the wrong TS
When not explicitly set in the CREATE TABLE statement, a newly created table will end up in the last created tablespace. A lot of customers have problems with this for several reasons. They have no control over table placement when using a framewo...
DB2_FMP_FODC variable needs to be extended to application traps
Failures in DB2 may result in Trap files, by default written to the directory where DIAGPATH is set, usually $HOME. To avoid disk-full conditions, this can be redirected with db2set variables DB2_FODC and DB2_FMP_FODC for most of the FODC traps. H...
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...
Enable DATABASE_MEMORY change on WRITE SUSPEND database
We are using db2relocatedb to deploy test, dev, preprod environments from production images (disc snapshots). This happens multiple times a week (talking about multiple hundred databases). Most databases have DATABASE_MEMORY set to AUTOMATIC. Relo...
Change behaviour of default Fast Communications Manager (FCM) port
Change behaviour of default Fast Communications Manager (FCM) port https://www.ibm.com/support/pages/db2-db2-server-tcpip-port-numbers For Db2 Version 11.5.5 or older, the ports used are 60000 and higher. For example, ports 60006 - 60011 would be ...
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...
Provide pre and post upgrade dbm and db checks of Db2 parameters and highlight any deltas
It is currently a best practice that we recommend customers do pre and post upgrade dbm and db checks manually. The request is that this should be performed automatically as part of the Db2 upgrade script itself.
Comparing before and after parame...
Do not place IBM confidential, company confidential, or personal information into any field.