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 17 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 24 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

RUNSTATS TABLESPACE on one TS partition scans all partitions of partitioned indexes

We encountered that the RUNSTATS on one TABLESPACE partition via RUNSTATS TABLESPACE ... PART or via LISTDEF INCLUDE TABLESPACE ... PARTLEVEL scans all partitions of a partitioned index. Therefore the runtime and the zIIP time of the jobs are extr...
25 days ago in Db2 for z/OS 0 Under review

Blocking Db2 connections to reduce the DSNL030I message flooding.

PTF delivery by IDEA DB24ZOS-I-1342 has already included the reduction of the DSNL030I message, it is working well for messages with REASON=00F3008* but the PTF does not include messages with REASON=00D30113 (invalid RACF ID), so these messages st...
24 days ago in Db2 for z/OS 0 Future consideration

Reduce messages for 00F30086 and others

Reduce messages for 00F30086 and others We have corporate policy affecting security on usage from a userID. ID are SUSPENDED for inactivity after 100 days, and DELETED after 500 days. Since applications may be stable and not used in all ...
30 days ago in Db2 for z/OS 0 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

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