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 db2 luw with the dpf feature enabled, we're facing with 2 problems when using some statements or calling procedures in triggers : calling a sql compiled procedure (containing DDL statements) doesn't work ; executing DDL statements inside the tr...
There exists a fundamental issue whereby if a query predicate is > HIGH2KEY then the optimiser always estimates cardinality of 1.For date/time related columns this is an issue as there may always be data beyond HIGH2KEY even immediately after r...
Tech Note describes how to use INGEST via ADMIN_CMD:http://www-01.ibm.com/support/docview.wss?uid=swg22006386 but using INGEST via ADMIN_CMD is not supported by IBM (see TS000004839 and TS000004925). In addition to support INGEST also INGEST SET c...
Your DB2 Entity Framework Core driver does not support value convertors. https://docs.microsoft.com/en-us/ef/core/modeling/value-conversions Value convertors are really useful with databases to do things like: Translate Y/N fields to proper boolea...
Union all View (or common table expression of a UNION ALL) lead to HSJOIN
Case #0000086 Worked with developer and provided following explanation:When there is a join between a UNION ALL view (or a common table expression of a UNION ALL) to another input (let's named it Z), to be able to utilize index access on the table...
Enhance functionality of WITH clause to operate with DELETE and UPDATE in DB2 SQL statements like others flavours of SQL
Our team uses IBM DB2 184.108.40.206 Database Server for development activities. We see limitations of DB2 SQL WITH clause to work with only SELECT unlike other flavors of SQL like T-SQL which operates other DML operations.
Just like how WITH simplif...
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.
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...
Do not place IBM confidential, company confidential, or personal information into any field.