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 978 of 15426

Improve messaging surrounding the +20272 SQL warning in cases of a -904

A DBA was running an ALTER NOT CLUSTER. The ALTER should have converted the tablespace to table-controlled partitioning, but it encountered a -904. I have copied the output to "additional details". In the SPUFI output, after the -904, the ALTER di...
over 3 years ago in Db2 for z/OS 3 Not under consideration

FR583: Enhance IFCID 316 to capture stats of UDFs as well

When the following dynamic SQL query is issued, processing the query involves processing a UDF. This works fine. However, when looking at SQL dynamic statements stats in a DB2 monitor, which retrieves IFCID 316 data from DB2, the data provided is ...
about 10 years ago in Db2 for z/OS 0 Not under consideration

FR581: Enable pushdown and transitive closure for LIKE with parameter markers to table expressions

As part of SAP Core Data Services (CDS), SAP supports 'type as you search' capability when entering values in panels. As part of this processing, they issue the following query on a view which includes a UNION clause. The access path with DB2 is n...
about 10 years ago in Db2 for z/OS 2 Not under consideration

DSNHDECP usage

The DSNHDECP modules is currently used in our shop and needs to be created for every DB2 subsystem, or data sharing group. This means that we need to create individual SDSNEXIT libraries for each subsystem. We used to have one SDSNEXIT which held ...
almost 7 years ago in Db2 for z/OS 1 Not under consideration

Table Values functionality

Is it possible to add following functionality to DB2 zos 10, 11 and IDAA 4.1 and above. Apparently it is supported in DB2 LUW. SELECT S.Year, Q.Quarter, Q.ResultsFROM SalesAgg AS S, TABLE (VALUES(1, S.q1), (2, S.q2), (3, S.q3), (4, S.q4)) AS Q(Qua...
over 10 years ago in Db2 for z/OS 1 Not under consideration

PARTITION BY clause should be available to create DPSI of Index on expression

IOE (Index on expression) can be DPSI, but when we specify PARTITION BY clause in the DDL to create partitioned IOE, it is failed by SQLCODE -628 in DB2 V11. We can create DPSI of IOE by the following DDL. CREATE INDEX TEMP.INDEX2 ON TEMP.TABLE2 (...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Create Accounting Data Lite record type

The standard DB2 Accounting record has become increasingly bloated over the years. All of the information contained in each record is useful, but much of it is not necessary for basic Accounting purposes. Because the record is so big, and so expen...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Selective Suppression of DB2 maintained System History

There are times when it is not desirable to create a new DB2 maintained system history row if the values in the columns of the base table have actually not changed. DB2 already suppresses the actual update of a non-temproal table if none of the co...
over 10 years ago in Db2 for z/OS 1 Not under consideration

DB2 V11/V12 Modify Recovery Change

Change Modify Recovery to display the dataset name from ICTYPE='i' (lower case i - BMC cumulative incremental image copies) entries when the row is deleted from SYSIBM.SYSCOPY.
about 7 years ago in Db2 for z/OS 1 Not under consideration

Implement a method for monitoring and automatically cancel connections and free locks if the time is exceded

We have CICS Transactions that access to DB2 and get some locks on the resources they need. Then they call webservices outside the mainframe. When the R/T of these webservices are high, it causes contentions with other transactions and requests on...
over 3 years ago in Db2 for z/OS 1 Not under consideration