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
Support for parallel execution of complex DML statements
Intra-query parallelism does not provide any benefits for the "INSERT ... SELECT..." statements, even when insert is performed into a temporary table. While preparing a PoC for the customer planning to use DB2 for LUW in 1C:Enterprise application ...
Real-time statistics with statistics profile can lead to deadlocks and lock timeouts
DB2 real-time statistics facility honors RUNSTATS options specified in the statistics profile, while performing synchronous statistics collection during statement compilation. If the statistics profile contains ALLOW READ ACCESS option, this can l...
Urgent need for committing more frequently when using merge sql statement
Need a way a way to ensure that commits can be done more frequently during merge operations - > The MERGE statement updates a target (a table or view, or the underlying tables or views of a fullselect) using data from a source (result of a tabl...
DB2 does not identify the tables as collocated even though they exist on the same set of db partitions because they reside in different database partition groups. The optimizer doesn't always make a good choice when comparing plans in DPF. With th...
This customer is receiving the SQL0437W warning when the DB2 optimizer changes strategies, this warning makes applications and scripts fail. He is one of many customers complaining that it makes application and script fail. This warning should not...
Why isn't CLIENT_USERID special register populated correctly by default(RIMS)
The customer was looking to create a table trigger using the CLIENT_USERID special register in order to populate a column that would indicate the actual OS user that last updated or inserted a row in a table. He later found out that this special r...
MQTs with REFRESH IMMEDIATE need to allow more flexible definitions(RIMS)
1. MQTs with REFRESH IMMEDIATE need to allow more flexible definitions. To make MQTs feasible for an environment where quick ingest and low data latency is a priority, they cant be REFRESH DEFERRED because of the excessive locking that occurs dur...
Do not place IBM confidential, company confidential, or personal information into any field.