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 1007 of 16019

Need a Db2 option to return control (and not wait) if the maximum number of threads is already reached

We've seen cases in z/OS DFSMS OAM where the application invoking OAM can use up the available Db2 connections/threads so when OAM goes to process their request, there are no longer any threads available resulting in a deadly embrace. Typically th...
about 9 hours ago in Db2 for z/OS 0 Under review

For online REORG, create parameter to set RC=4 when DRAIN fails

I am creating a scheduled job to perform regular REORGs of the Db2 Catalog. I am generating a list of catalog objects and feeding it to LISTDEF and then using ITEMERROR,SKIP I am using extremely gentle DRAIN settings...DRAIN_WAIT of 2 or 3 seconds...
about 16 hours ago in Db2 for z/OS 0 Under review

REORG with a new keyword should transfer the page set work to DFDSS

Why is the above idea useful? Sometimes you need to move page sets around due to altering the HLQ, due to removing extents etc. These actions do not require an unload and reload of the data, because it is external stuff out of DB2 scope. For small...
3 days ago in Db2 for z/OS 0 Under review

ALTER STOGROUP can run in parallel to applications => Deferred ALTER

We need to move a lot of page sets and hence a lot of data from one z/OS catalog to another and also to other stogroups and volumes. For this task we nned to ALTER the hlq of the page sets and move them via DFDSS FASTREPLICATION. Unfortunately the...
3 days ago in Db2 for z/OS 0 Under review

REORG PREFORMAT of 1 TB page set should be interruptable

With PH64760 one can create 1TB page sets in one step. If one runs a REORG PREFORMAT on such large objects, the Media Manager Preformat task is not interruptable. Such a size of 1TB needs ~1.5hours to preformat the page set. In the meanwhile neith...
4 days ago in Db2 for z/OS 0 Under review

UDF INTERPRET should accept any CCSID

The built-in function INTERPRET added with FL505 should also support CCSIDs other than the CCSID of the Db2. For example, it should be possible to convert data in a Db2 with CCSID 1141 to CCSID 1141, provided the source data is defined with FOR BI...
5 days ago in Db2 for z/OS 0 Under review

Db2: V13 Access Path regression: Tablespace scan regresses to nonmatching index scan. After turning this in as a problem, we were told that it was working as designed. Our suggestion is that the design is flawed.

We feel the design is flawed and strongly feel this is a bug. The only time a non-matching index scan should be considered versus the tablespace scan is when it can at least filter the result somewhat. There are ZERO columns in the index that matc...
8 days ago in Db2 for z/OS 1 Not under consideration

COPY NO Indexes to be recorded in SYSLGRNX

It would be very helpful if ALL indexes are recorded in SYSLGRNX which will then open the possibility for a BACKOUT YES recovery for all TS+IX and avoid a potentially costly and long REBUILD INDEX for some very large tables and when backing out a ...
9 days ago in Db2 for z/OS 0 Under review

Reorg Shrlevel CHANGE for Tables with Index on Expression Index

Currently a REORG shrlevel CHANGE is not possible on UTS tablespaces which have an expression Index (Index on Expression) defined to them. the message below gets issued: DSNU076I DSNURFIT - KEYWORD=SHRLEVEL CHANGE INVALID FOR EXPRESSION-BASED INDE...
11 days ago in Db2 for z/OS 2 Under review

Eliminate x-locks on CREATE INDEX DEFER YES to improve concurrency

This is similar to DB24ZOS-I-1114 and DB24ZOS-I-1689. When attempting to create an index with CREATE INDEX DEFER YES, there should be no need to lock packages that are dependent on the table. Requiring an x-lock doesn't seem necessary. With phase-...
12 days ago in Db2 for z/OS 1 Not under consideration