Skip to Main Content
IBM Data and AI Ideas Portal for Customers


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 updates on 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,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


ADD A NEW IDEA

Statements (DDL and DML)

Showing 94

DB object version control

Idea of versioning objects: UDFs, views, mqts and procedures. When we are replacing mentioned above objects with new statements we have to save old statements in notepad (or sth similar) in case if we want to return to previous version.
over 8 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

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 ...
over 8 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

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...
over 8 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

optimizer choice when comparing plans in DPF

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...
almost 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Allow blu and row tables to be mixed when using shadow tables

Allow blu and row tables to be mixed when using shadow tables.
about 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Remove restriction on not logged initially

Add a new clause to the option NOT LOGGED INITIALLY to avoid to drop in case of failure in the UNIT OF WORK
over 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

alter package explain no / yes

Allow to change the explain option of a package using alter package or rebind package
over 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Intermediate commit in singleton delete / insert / update

Add a new WITH clause to store the commit interval which will triggers intermediate commits in the mass delete / insert / update.
over 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

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...
about 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

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...
about 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration