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 for z/OS

Showing 784

Need JSON UDFs (JSON_TABLE, etc.) to perform similar to XMLTABLE

Need to performance (elapsed time, cpu time) for JSON UDFs to match or exceed XMLTABLE function.We will be using HTTPGETCLOB to invoke RESTful APIs for Web Services on non-mainframe platforms.Our DB2/Legacy applications will need to invoke these, ...
over 7 years ago in Db2 for z/OS 0 Not under consideration

Bi-Temporal support for DB2 AUTH tables

I am asking for bi-temporal AUTH tables, and while I think the plan is to add System Temporal with Cypress on many catalog tables, I'm asking also for Business Temporal. There are a couple reasons for this request, first from a Business Temporal p...
over 8 years ago in Db2 for z/OS 0 Not under consideration

RECOVER utility option to include inflights

There should be an option in RECOVER utility which allows to include during recovery all the inflight threads which started before the point of time to which we are recovering the object. Currently all inflights are being rolled back
almost 9 years ago in Db2 for z/OS 1 Not under consideration

DSNACCOX RRTDataSpaceRatio & TSQTY ZPARM

Our DBAs would like to use the RRTDataSpaceRatio attribute via DSNACCOX stored procedure to facilitate triggering REORGs for over allocated tablespaces. This is not currently possible due to the fact that REORGs are triggered erroneously for small...
almost 9 years ago in Db2 for z/OS 4 Not under consideration

Online Constraint name renaming capability

MR0803067232 DBDB2D/S05008 Expand the ALTER-TABLE–Statement with an RENAME-Clause or add a RENAME-CONSTRAINT-Statement which renames the constraint name online.
over 11 years ago in Db2 for z/OS 1 Not under consideration

DB2 message showing a trace was started

Today we have situations where people authorized to start DB2 traces sometimes issue START TRACE commands with little qualifications with lead to traces being collected for lots of DB2 threads which ends having impact on general performance of the...
almost 2 years ago in Db2 for z/OS 0 Not under consideration

Full Column Match and I1 Access on SQL with Correlated Sub-Queries Containing Column Expressions and Supporting IoE

Some queries with column expressions - DATE(A1.EFCTV_TS) <= DATE('04/05/2020') for example, and an Index on Expression to support the expression are achieving I1 access while others are not. It appears this is because of how the query is curren...
almost 4 years ago in Db2 for z/OS 2 Not under consideration

Dynamic Plan Stability - Option to restabilize an invalidated query missing

We've got several SQL queries stabilized with dynamic plan stability. Reason is to prevent them from getting a bad accesspath. After operations like "ALTER TABLE ... ROTATE PARTITION..." the query is flagged to valid N in SYSIBM.SYSDYNQRY. Than we...
about 4 years ago in Db2 for z/OS 0 Not under consideration

Alters to objects that require reorg to material should be put into advisory reorg, such as PCTFREE

If an alter is done to a TS to PCTFREE and a REORG is not run, then the catalog is updated but the change is not materialized. This results in the DBA thinking it was done, but it really wasn;t.
over 4 years ago in Db2 for z/OS 0 Not under consideration

IFCID 366/376: include SQL text in the trace records

The analysis of IFCID 366/376 is done via SMF records. When these records are available (one day delay), it is nearly impossible to match the statement ID to a statement in dynamic statement cache, because the statement might be already discarded....
over 5 years ago in Db2 for z/OS 1 Not under consideration