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 76 of 15639

CASE with EXISTS in UPDATE returns SQL0582N, which is inconsistent behavior with db2 z/OS

db2 "update test_tab set c1=case when exists (selectc2 from test_tab where c2=1) then 'A' else 'B' END" DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it retu...
almost 8 years ago in Db2 / Application Development 1 Not under consideration

PL/SQL compatibility - default values of procedure parameters

Currently DB2 does not fully support Oracle-style definition of default parameters in PL/SQL stored procedures (including those in functions). The following definition works in Oracle, but requires modification in DB2: CREATE OR REPLACE PACKAGE my...
about 8 years ago in Db2 / Application Development 0 Future consideration

DGTT ON COMMIT DROP OPTION

DB2 z/os supports that DGTT tabe can be drop on commit. My customer who is migrating to db2 luw want to drop table on commit as well.
over 8 years ago in Db2 / Application Development 0 Not under consideration

Need to develop one API to fetch DB2 Memory

As we know IBM has DB2 api to fetch the db2 Disk Storage size and usage, But we don't have any api to fetch db2 Memory size and usage. So please develop the same type api for memory also. For Authorization we can use Bearer token.
over 4 years ago in Db2 / Application Development 0 Not under consideration

DB2 to add support for Oracle functions after compatibility vector is set to ORA

1. DB2 does not support sys_guid() function even after oracle vector is being set. 2. DB2 does not support DBMS_SESSION 3. FROM_TZ function is not supported. 4. REGEXP_REPLACE is not supported
almost 10 years ago in Db2 / Application Development 3 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.
over 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.
over 5 years ago in Db2 / Application Development 0 Not under consideration

DENSE_RANK FIRST/LAST (Oracle function)

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

NCHR for db2 LUW (new scalar function)

Oracle supports NCHR function. To migrate oracle application, we need this scalar function. NCHR returns the character having the binary equivalent to number in the national character set. The value returned is always NVARCHAR2. This function is e...
almost 6 years ago in Db2 / Application Development 1 Not under consideration

Sharing locks between transaction branches also when setting INTRA_PARALLEL is set to YES

We are using DB2 11 for LUW and for an application server we have IBM WebSphere Application Server 9. We have a cluster environment containing several servers. Our applications are running on different application servers(cluster environment) and...
almost 6 years ago in Db2 / Application Development 1 Not under consideration