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 of 15428

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

VARCHAR_FORMAT/TO_CHAR function does not support timestamp formatting using brackets(RIMS)

PMR 28054,020,649 Customer is moving from Oracle to DB2 and under their Oracle applications they are using the TO_CHAR function. That function works in DB2 under the name of VARCHAR_FORMAT or TO_CHAR. The following TO_CHAR function is not working ...
over 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

new optimizer guideline to break CSE for a specific query or as a global guideline(RIMS)

Customer encountered scenario where use of CSE resulted in degradation in query performance (details below). This requirement is to implement a new optimizer guideline that will allow customer to break CSE for a specific query or as a global guide...
over 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration