Skip to Main Content
IBM Data and AI Ideas Portal for Customers
Hide about this portal


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 29

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 4 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 12 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...
3 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

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 ...
29 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

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

Db2 Developer Extension - Add support to execute external COBOL stored procedures from catalog list, save input parameters and reload saved values as well as generating DDL and dropping the stored procedure

Application Developers use Data Source Explorer in Data Studio to display external COBOL stored procedures from the db2 catalog. They right click and get options to run the stored procedure after inputting values, generate the DDL and can also dro...
about 2 months ago in Db2 for z/OS 4 Under review