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
Lock access plan for a query. Prevent the optimizer from changing a plan, once a "good" plan has been determined.
We see cases where a large query runs fine, and something changes the stats, which causes the optimizer to choose a really bad plan. We would like to be able to lock an individual query, and tell the optimizer: "Just use this plan".
Enhance IBM My Notifications with Affected DB2 Version Information
Currently we subscribe to the IBM 'My Notifications' email (see: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.trb.doc/doc/t0060379.html or https://www-01.ibm.com/support/docview.wss?uid=swg21686621) so we rece...
Ubuntu 16.04 LTS has End of life as April 2021. We use IBM DB2 11.1.4 Enterprise Edition on Ubuntu 16.04 LTS for our MDM instances which is not compatible with the higher versions of Ubuntu -18.04 LTS and above. Same is true for the updated versio...
Optimizer should ignore RTRIM when calculation filter factor
When the optimizer calculates the filter factor for a predicate which uses RTRIM, it just returns the default value. (0.04)It should ignore the RTRIM and use the COLCARD of the column stats instead. Refer to Case: TS001114316
When issuing a sentence like:
db2 drop audit policy SELECT_ALL_TABLES
The returned error message does not include the schema of the problematic object:
SQL0478N The statement failed because one or more dependencies exist on thetarget object....
IBM Data Studion needs extport/Extract from a select statement
Many people use IBM Data Studio to manage DB2 database. You can currently right click on a table and extract/export a tables contents. You cananot do the same using a select statement to say filter records or join tables for the export. Today peop...
Do not place IBM confidential, company confidential, or personal information into any field.