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

Audit 145 records; always supply a (non-zero) QW0145SI value.

As per PH04538, under the current design, "we are afraid that zero QW0145SI can not be eliminated as it happens when the stmt is not cached nor static base on current design. "
over 3 years ago in Db2 for z/OS 1 Not under consideration

Drop STP SQL with dependency of other STP SQL type NATIVE

We have a general purpose StoredProcedure (STPX1) that is called by other native StoredProcedures (STPA1, STPA2, STPA3, etc) that have CALL statements to STPX1, If I need DROP the STP STPX1 (for recreate later) I receive the error -478 for depende...
over 3 years ago in Db2 for z/OS 0 Not under consideration

Option to dictate behaviour regarding deadlock victim selected on deadlocks involving DDL ALTERs

In true 24*7 production environments there is an increasing expectation that simple(on the face of it) DDL changes should be able to break-in concurrent with application workload. In the case of high-arrival rate transactions even at the quietest ...
over 3 years ago in Db2 for z/OS 0 Not under consideration

Timestamps in system generated messages in STDERR in a java WLM.

The STDERR in a java WLM does not include a timestamp of when the message was written. It's hard to cross check the system message produced with an application issue.
over 3 years ago in Db2 for z/OS 3 Not under consideration

UNLOAD Utility should have the ability to generate IGNOREFIELDS YES

This is a manual effort using INSYNCH to add this to the load cards
over 3 years ago in Db2 for z/OS 1 Not under consideration

Unload should generate the correct load cards to load Temporal Base Tables

Currently the unload utility generates load cards with Temporal Column Names having different names as the DB2 catalog. This causes the load to generate new values for ROW BEGIN, ROW END, TRANSACTION START ID which is incorrect. Having INSYNCH sof...
over 3 years ago in Db2 for z/OS 0 Not under consideration

Improve optimizers cost estimation when recursive table expression invloved

Please refer to case TS004038133. Application developer uses SQL EXPLAIN to compare the cost of different SQL statement and decides which one to use. In one case, they found EXPLAIN reported lower cost for one SQL than other but in actual executio...
over 3 years ago in Db2 for z/OS 1 Not under consideration

Improving Insert Performance for LOBs

As mentioned in Case TS004024647 there are some situations where inserts in lob structures do not provide the expected performance. Instead they cause massive CPU consumption in the Coupling Facility for the spacemap search. The problem is excessi...
over 3 years ago in Db2 for z/OS 0 Not under consideration

allow CREATE FUNCTION with RETURNS TABLE to use SQLPL

Today (in V12 <and maybe earlier>) it is possible CREATE FUNCTION using SQLPL and RETURN a value (of any data type). This is pretty cool.. and powerful. This is useful to perform complex SQLPL operations inside the UDF (LANGUAGE SQL). For ex...
over 3 years ago in Db2 for z/OS 1 Not under consideration

Add SORTNPSI_USED To SYSIBM.SYSINDEXSPACESTATS

Use case/business impact. All indexes reorged on Sunday. Run daily process to identify any index needing reorged by interrogating RTS. Since NPSI organization can rapidly deteriorate, on Monday, Tuesday, Wednesday, Thursday, and Fri...
over 3 years ago in Db2 for z/OS 1 Not under consideration