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

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:

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

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps:

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is:



Statements (DDL and DML)

Showing 80

Allow complete acces path in optimization hint (like db2 for ZOS)

We have the same cobol application that on both z/os and luw.We are using static sql in packages. We run 12 schemas using the same sets of tables in each for manual application parallelism.Occasionally a package for a given schema will flip access...
over 5 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

SQL0437W warning should be eliminated(RIMS)

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

Parallel index rebuild.

Allow to send the commands create index in parallel on the same table (or any other operation which could be parallelized).
over 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Create a storage group in a specific database partition group.

After discussing with Pavel Sustr & Quentin Presley there is current no plans to for this hence the request. I'm copied the initial e-mail request. Is there any plan to allow storage group definition, in DPF, to apply to a particular dbpart gr...
over 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Improve poor query compilation performance due to long lock list traversal in DB2 10.1 and later

Beginning with DB2 LUW 10.1 DGTT-referencing DML started to take catalog locks and therefore we have to free them and potentially traverse long lock chain if the DML is a part of a long-running transaction potentially holding millions of locks. Th...
over 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

DB2 LUW to have option to ignore QUERYNO clause of SQL on DB2 z/OS

The client has many SQL for z/DB2 production environment with QUERYNO clause like the following sample.    SELECT /* Comment */           A_ID,           A_NAME       FROM           A_MASTER       WHERE           ...
over 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

More heavy use of fetch first n rows to optimize the statement

see attachments (error of the server when submitting the RFE)
over 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Automated Re-creation of Select-Star Views

If a view is created by using a 'SELECT *' statement, the view is not updated when a new column is added to the base table. An example: create table dm_tab(N integer, M integer) organize by row; insert into dm_tab(N, M) values (1, 2); create view ...
about 2 months ago in Db2 / Statements (DDL and DML) 0 Under review

Add ability to detect changes in data (similar to QSYS2.DISPLAY_JOURNAL)

When supporting a production environment, one needs to detect the sequence of updates, including before and after image. On IBMi, we use extensively the functionality to consult the journal entries (
5 months ago in Db2 / Statements (DDL and DML) 0 Future consideration

Functions for converting Unix Epoch Time and Dealing with RHEL 8 Native Posix MQ

SQL scalar functions for Converting between human-readable date/time and Unix Epoch Time. For example: db2 "values ept2date(123456789,0)" is equivalent to Linux GNU date command date -d "1970-01-01 1234567890 sec UTC db2 "values "date2ept('now')" ...
6 months ago in Db2 / Statements (DDL and DML) 1 Future consideration