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 305

OPTIMIZER IGNORE INDEX indexcreator.indexname

Looking to replace NPI with DPSI. DSPI is created, and would like to verify that all SQLs that were using NPI, when Rebound/executed dynamically would either a) use either newly created DPSI or another index on the table and b) have run time ...
about 2 months ago in Db2 for z/OS 0 Future 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...
9 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...
10 months ago in Db2 for z/OS 1 Future consideration

Expand error message -532 and and output parent table name and child table name

Table1 has 4 level foreign keyTable1 to Table2 --> FK_01Table2 to Table3 -->FK_01, FK_02Table3 to Table4-->FK_01, FK_02Table4 to Table5 --> FK_01If I delete row in Table1, I get the message:DSNT408I SQLCODE = -532, ERROR: THE RELATION...
8 months ago in Db2 for z/OS 5 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...
11 months ago in Db2 for z/OS 0 Future consideration

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

DB2 Z/OS Sync Logical and Physical Parts after full Reorg

ADD PART was used to insert a new physical partition in the middle of a tablespace. Now the Logical and Physical partitions are mismatch.If a Full Reorg on the full tablespace is performed, the utility can include an option to resync the logi...
5 months ago in Db2 for z/OS 1 Future consideration

Profile Table Enhancement for local applications

Profile Tables today support only remote connections and no support for local/batch applications. When PT is used to set certain registers, it only works for remote applications and local apps needs to be changed to add certain SET commands.
12 months ago in Db2 for z/OS 0 Future consideration

DSNT376I message don't supply total information to solve the problem analisys

I found that as soon as the DB2 Lock Escalation message occurred (DSNI031I), DB2 seems to begin rejecting the ESS SQL calls against this tablespace, *immediately* without waiting the DB2 lock timeout interval. This probably explains w...
over 2 years ago in Db2 for z/OS 9 Future consideration