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

Application Development

Showing 59

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 11.1.4.4 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...
over 4 years ago in Db2 / Application Development 1 Not under consideration

Update APPLNAME from properties and other ways

The application name in many environments is limited to db2jcc_application and db2bp, just because the development of the application did not take into account this. However, it will be great to change the application via properties file and/or s...
over 4 years ago in Db2 / Application Development 0 Not under consideration

Deploy new/unused packages without causing performace impacts

With current DB2(V11.1 FP2, FP4), Deploying a new or an unused packages causing variation and catalog locks impacting performance. HOLDHDL WAITHDL HOLDER WAITER HOLDMODE OBJTYPE TABNAME SCHEMA SECS STMTTEXT ---------- ------- ---------- ----...
over 4 years ago in Db2 / Application Development 0 Not under consideration

Support of TO_SINGLE_BYTE (oracle function) in 1363 code page database

Needs for higher Oracle compatibility.
almost 5 years ago in Db2 / Application Development 0 Not under consideration

Depth First By /Breadth First By support in Recursive CTE

Oracle user can order of the rows by the SEARCH clause of Recursive Common Table Expression. There are two methods, BFS and DFS. For easy application migration, this feature should be enabled.
almost 5 years ago in Db2 / Application Development 0 Not under consideration

EXIT, GOTO, CONTINUE in a Exception block (PLSQL)

Oracle PLSQL supports EXIT, GOTO and CONTINUE in a exception block, but Db2 doesn't. For higher migration convenience, Please support them.
almost 5 years ago in Db2 / Application Development 0 Not under consideration

Save exceptions in FORALL statement (PLSQL)

Oracle PL/SQL supports save exceptions in FORALL statement, but Db2 PL/SQL doesn't. For smooth oracle migration, the feature is required .
almost 5 years ago in Db2 / Application Development 0 Not under consideration

Enhance SYSIBM.SQLFUNCTIONS to deliver meta data required by JCC (JDBC V4)

This is a quite old story. Back in 2015 this had already been addresses by COGNOS team IBM internally, but due to the possible impact to existing applications, it was refused to open an APAR for this issue. But RFE or DCR has not been opened by CO...
almost 5 years ago in Db2 / Application Development 0 Not under consideration

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...
about 5 years ago in Db2 / Application Development 1 Not under consideration

DENSE_RANK FIRST/LAST (Oracle function)

It is required for higher oracle sql compatibility,
about 5 years ago in Db2 / Application Development 0 Not under consideration