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 Data & AI Roadmaps (http://ibm.biz/Data-and-AI-Roadmaps) - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at https://hybridcloudunit-internal.ideas.aha.io/


ADD A NEW IDEA

FILTER BY CATEGORY

Db2 for z/OS

Showing 260

Improve performance in queries with IN predicate

Hello! We had problems with CPU in Production environment several months ago with a simple query with IN predicate. The CPU reached 100%! Particularly, this query has many literals within IN predicate and the IN predicate can't be matching. After ...
8 days ago in Db2 for z/OS 0 Future consideration

Provide ROWID addition for PBG to PBR conversion in V13 ALTER statement.

In V13m we get to convert PBG tablespace to PBR by a simple ALTER statement. However, we will be forced to look for a partitioning key by working with application team. In the mean time, in V12 we have a feature called "Hidden ROWID support for pa...
2 months ago in Db2 for z/OS 1 Future consideration

Increase messaging detail after STOP Db2 to provide shutdown status information.

As Db2 continues to allow more and more capacity in a single subsystem - larger bufferpools, more open datasets, etc - the time to shut down Db2 continues to increase. Operational staff has complained repeatedly that they cannot tell whether Db2 i...
4 months ago in Db2 for z/OS 0 Future consideration

Change OBDRX2AC Tracking From OBD Level To TS Partition Level

Currently after an ALTER ADD COLUMN has been executed on a partitioned TS , all subsequent reorgs go through the compression cycle until all partitions have been reorged within the same modify recovery range. For very large TSs with many partition...
4 months ago in Db2 for z/OS 0 Future consideration

Alter PBG to PBR should be possible for tables with LOBs

The statement ALTER PARTITIONING TO PARTITION BY RANGE should be applicable for tables with LOB's. One of the main drivers for us to convert from PBG's to PBR's is that our LOB tablespaces are growing very large. As the base tables usually only co...
5 months ago in Db2 for z/OS 0 Future consideration

SQL Data Insights should show outliers relative to all rows in the table

Currently the AI_SIMILARITY function only shows outliers with respect to a specific entity in the table. There should be a way to determine outliers taking into account all rows in the table. This would be benificial in the case of fraud detection...
5 months ago in Db2 for z/OS 0 Future consideration

Remove limitation on tables with XMl column

Today there is some limitations on tables with XML column. For example, we can't alter the table with ALTER PARTITION partotion-clause for LIMITKEYS. This limit cause us to drop and recreate the table with a lot of data(xml) and for downtime. We a...
6 months ago in Db2 for z/OS 0 Future consideration

Use permanent database for DSNTRVFY rather than implicit database

Each time we run DSNTIJRV, the DSNTRVFY program creates the DSNTRVFY.VALIDATION_TABLE in an implicitly-created database, which the process then leaves hanging around with no objects in it. Both empty databases and implicitly-created databases viol...
6 months ago in Db2 for z/OS 0 Future consideration

QUERY_HASH strangeness

Hi! I am starting to use the new column in SYSPACKSTMT called QUERY_HASH and I have noticed that for different SQL Statement texts I am getting the same hash. I am aware that there is no guarantee of uniqueness but what worries me is that my SQL i...
6 months ago in Db2 for z/OS 1 Future consideration

Error message improvement when failing to convert tablespace to UTS PBG

Recently we are converting our old segmented and simple tablespaces to UTS PBG. When converting one of these tablespaces we got an abend and a DUMP showing reason code 00C90101. We opended a case (TS009249828) and analyzing the DUMP DB2 lab conclu...
7 months ago in Db2 for z/OS 0 Future consideration