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

Db2

Showing 215

Add "IF EXISTS" syntax to all DROP statements

More and more SQL is stored in repositories and needs to be applied in odd places and orders. One syntax element that supports this is the "IF EXISTS" on a drop statement. This causes a statement to not count as a failure if it finds no object to ...
over 2 years ago in Db2 / Statements (DDL and DML) 0 Future consideration

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 (https://www.ibm.com/support/pages/qsys2displayjo...
over 2 years ago in Db2 / Statements (DDL and DML) 0 Future consideration

ISO/IEC 9075:2016-2, T612: Add ability to declare window frame that can be shared between window functions

When you need to use the same window frame for several window functions, T612 can simplify the query. Example from code of advent, day 1: select id, case when count(1) over w = 3 then sum(depth) over w end depth from day1.input window w as (order ...
over 2 years ago in Db2 / Analytical Functions 0 Future consideration
110 VOTE

NONBLOCKED option for event monitors to prevent them from blocking user services

Db2 locking event monitor may block deadlocked applications from proceeding for a purpose of making event monitors work under some circumstances. (Reported on case TS007885986) Since it could damage user's business services severely, user should b...
over 2 years ago in Db2 / Serviceability 1 Future consideration

Add possibility to create dashboards over several databases

I would really to be able to create a dashboard, containing the activity response time of my top-10 databases. Or to be able to look at the graphs of some databases in 1 glance.
over 2 years ago in Db2 / Data Management Console 0 Future consideration

Decreasing CF memory is slow

While working with PureScale, there may be a need to create room for new DB in the system. Once this happens we need to reconfigure CF memory, while keeping system up and running. We are concerned regarding CF_MEM_SZ , CF_GBP_SZ and CF_DB_MEM_SZ, ...
over 2 years ago in Db2 / pureScale 0 Future consideration

dmctop for ppcle

While exploring dmctop I did not find a version for power machine. So IBM engieneering requested me to submit a request for the same.
over 2 years ago in Db2 / Application Development 1 Future consideration

Please add a built-in function to reverse a string

Currently to reverse a string, we have to create a udf. The syntax for a simple one was easily available on the SQLTips4Db2 blog .... which IBM has removed. I think Db2 on z has this, and some other variants of SQL out there include it. This is th...
over 2 years ago in Db2 / Other/Unknown 0 Future consideration

Please add a built-in function for pi

Currently there is no built-in function for pi. It can be calculated using math on trigonometric functions, but this is mildly annoying. Pi is frequently used when working with different random variate distributions and other functions that are in...
over 2 years ago in Db2 / Other/Unknown 0 Future consideration

Table Partition creation auto extension Functionality

Today DB2 doesn’t provide the auto table partition extension Functionality. We would like to have the Functionality available, could you please let us know if this is feasible and if yes how soon it would be available. This is Functionality is ava...
over 2 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Future consideration