IBM Data and AI Ideas Portal for Customers

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:

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

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps:

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is:



Db2 for z/OS

Showing 796 of 12665

RUNSTATS with exception consideration

All DB2 customers use RUNSTATS. The RUNSTATS results are used by the DB2 optimizer to determine optimal access plans. In 99.999 percent of all cases this is not a problem. However, there are some objects (tablespaces / indices) for which a RUNSTAT...
3 months ago in Db2 for z/OS 1 Under review

control size of UOW after an alter to rotate partition

requesting that DB2 generate reasonably sized URs when performing a mass delete action against a table with DATA CAPTURE set to CHANGES. in a specific case, we were rotating partitions on a base source table which was being replicated with data ca...
10 days ago in Db2 for z/OS 0 Under review

New Authorization for SELECT all tables (DataSelect)

We use the DataAccess Auth to let Select. Insert, Update & Delete on all tables.But we'll appreciate also a new Auth for letting only Select on all tables. That's why we thought about the name DataSelect.
6 months ago in Db2 for z/OS 2 Future consideration

Allow for "OPTIMIZE FOR n ROWS" to be added to DELETE, UPDATE Statements

OPTIMIZE FOR 1 ROW can be added to SELECT SQL. One reason may be to influence the optimizer to chose one index over another, or to not perform a SORT with List Prefetch Adding OPTIMIZE FOR 1 ROW to a DELETE statement results in an error: EXPLA...
4 months ago in Db2 for z/OS 1 Not under consideration

Standardize and allow LISTDEF PARTEVEL syntax for MODIFY STATISTICS utility

Currently MODIFY STATISTICS utility does not support LISTDEF with PARTLEVEL and throws an error like in example:LISTDEF DB2RK INCLUDE TABLESPACE DS0HUZX.S0HU37P PARTLEVEL(20) TEMPLATE COPYIC DSN(&SS..ICR.&DB..&TS..P&PA..&UQ.) T...
11 months ago in Db2 for z/OS 0 Future consideration


Hello Db2 for Z/OS Development.Apar PM89016 was created several years ago to implement the lock avoidance for singleton SELECTs with ISO(CS) and CD(YES) when R-scan is used, or the index that is chosen has matching predicates on all columns of th...
11 months ago in Db2 for z/OS 1 Future consideration


The new Db2 v12 feature Fast Index Traversal advice at MSTR every 2 minutes about Memory used and indexes applied.This is quite uncomfortable when studing or trying to find something inside MSTR.Example: during 23 days, one Member of a Db2-Product...
over 1 year ago in Db2 for z/OS 2 Planned for future release

API to write dictionary to log

A number of our common customers run DB2 utilities from third party vendors and IBM replication solutions. They are requesting that our LOAD and REORG utilities write the old dictionary pages to the log for later retrieval by a replication produc...
almost 2 years ago in Db2 for z/OS 3 Future consideration

Stop package invalidation after ALTER MAXPARTITIONS

These days in an agile world we have to ALTER PBG spaces on-the-fly to raise the MAXPARTITIONS value. Sadly this ALTER, even though it is an immediate ALTER, sets all dependent packages to VALID = 'N' which is, of course, a disaster.
almost 2 years ago in Db2 for z/OS 8 Future consideration

Improving Insert Performance for LOBs

As mentioned in Case TS004024647 there are some situations where inserts in lob structures do not provide the expected performance. Instead they cause massive CPU consumption in the Coupling Facility for the spacemap search.The problem is excessi...
about 1 year ago in Db2 for z/OS 0 Future consideration