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 (

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 ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Data & AI Roadmaps ( - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at



Db2 for z/OS

Showing 838

Altering the default value of a global variable

Global Variables: A global variable can be created with a default value. Each session that uses it will then instantiate a version of that global variable, with the default value and any change in the value is limited in scope to its unit-of-work....
about 2 years ago in Db2 for z/OS 1 Not under consideration

Allow RUNSTATS SHRLEVEL CHANGE to operate as the name says

This RFE is a result of the PMRs (31614,112,848) we have opened where the root cause was identified as invalid values in RTS tables. Current design allows to re-initialize certain fields in RTS (eg. TOTALROWS) only by executing RUNSTATS SHRLEVEL R...
over 3 years ago in Db2 for z/OS 2 Not under consideration

Log offload task needs to be manually cancelled restarted after outage to tape

We are seeing situations when tape processing is down and a DB2 request to offload logs to tape is initiated using dynamic allocation, that offload task will hang and never be satisfied until the offload task is cancelled and re-driven manually. T...
over 6 years ago in Db2 for z/OS 4 Not under consideration

Allow 3 different options for statement concentration.

We would like 3 options for statement concentration. It is importantthat all three options are available. 1. No concentration. (already exists) 2. Concentrate queries that have no parameter markers (Current DB2 concentration) 3. Concentrate querie...
about 9 years ago in Db2 for z/OS 0 Future consideration

support list partitioning - Range-Partitioning allows only to define the upper limit for a partitioned Tablespace.

Full Support for LIST-Partitioning required! With classical Partitioning or UTS Partion-by-Range you can only define the upper limits (key-Ranges) for a partitioned Tablespace. The lower partition-range ist defined by the highest value of the next...
almost 10 years ago in Db2 for z/OS 1 Not under consideration

Add MERGE-functionality on LOAD-utility

MR0112077423 GGDB207006
almost 10 years ago in Db2 for z/OS 1 Not under consideration


Recovery to PIT or to current, and non-standard recovery methods such as DSN1COPY or DF/SMS dataset DUMP/RESTORE from flashcopy backups can leave TOTALROWS set to 0, NULL or invalid values. Trying to run something like a REBUILD index relies on TO...
over 2 years ago in Db2 for z/OS 0 Future consideration

Improve persistent thread concurrency

With the implementation of transactions with persistent threads (like pseudo wait-for-input on IMS) we have been facing some concurrency issues in our site, specially with HPU and batch programs that perform lock escalation. This happens because t...
about 3 years ago in Db2 for z/OS 5 Not under consideration

Convert PBR tablespace to PBG without an outage

Right now we have situations come up where applications and DBAs have created partition by range (PBR) tables, and there is a need later on to convert these to partition by growth (PBG). Currently there is no way to do this without dropping the ob...
about 8 years ago in Db2 for z/OS 0 Future consideration

Materialize a reorg pending change through part-level reorgs

At the moment an AREOR exception state can only be solved by reorganizing the whole (partitioned) tablespace in one go. We want to do the materialization in several sequential steps on a part-level base.
over 8 years ago in Db2 for z/OS 1 Not under consideration