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
In our environment, we have many queries with predicate: "expression op expression". As they don't use indexes they're performing a table scan. We would like DB2 to be able to use indexes to resolve this type of predicate. Examples: SELECT [id], [...
So I know there is a Mongo listener so that you can speak mongo to DB2. I also know DB2 understands the MySQL dialect; there should be a listener so that applications can connect to it, the app thinks its mysql, but the back end is db2.
External Stored Procedure sub modules to be loaded from same path as 'external name;
DB2 supports multiple (in our case development) databases within a db2 Instance and External Stored Procedures (in our case COBOL) can be developed in parallel by using different qualifiers in the external name e.g. alter procedure cxjjp.UIXN01 ex...
Default of for read only for all select statements
As you might have noticed, the "for read only" clause of the select statement in DB2 is not widely known nor used. Most standards select statements going through the DB2 engine have the risk of becoming an ambiguous cursor with sub-optimal perform...
SELECT * FROM FINAL TABLE (MERGE ...) - It would be very usefull to select records that were just merged. The same way like with DELETE / UPDATE and INSTERT: SELECT * FROM FINAL TABLE (DELETE / UPDATE / INSERT)
The application name in many environments is limited to db2jcc_application and db2bp, just because the development of the application did not take into account this.
However, it will be great to change the application via properties file and/or s...
Deploy new/unused packages without causing performace impacts
With current DB2(V11.1 FP2, FP4), Deploying a new or an unused packages causing variation and catalog locks impacting performance.
HOLDHDL WAITHDL HOLDER WAITER HOLDMODE OBJTYPE TABNAME SCHEMA SECS STMTTEXT
---------- ------- ---------- ----...
Do not place IBM confidential, company confidential, or personal information into any field.