Skip to Main Content
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 839

Add REMARKS column to SYSIBM.SYSDATABASE and COMMENT support for database object

We would like to ask you, to add the REMARKS column in SYSIBM.SYSDATABASE and support for COMMENT statement for databases. There is no possibility currently to store some form of a description for databases in DB2 catalog. In big sites where thous...
11 months ago in Db2 for z/OS 0 Future consideration

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.
about 1 year ago in Db2 for z/OS 2 Future consideration

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

Table1 has 4 level foreign key Table1 to Table2 --> FK_01 Table2 to Table3 -->FK_01, FK_02 Table3 to Table4-->FK_01, FK_02 Table4 to Table5 --> FK_01 If I delete row in Table1, I get the message: DSNT408I SQLCODE = -532, ERROR: THE REL...
over 1 year ago in Db2 for z/OS 5 Future consideration

Avoid Reorg Abends by improving estimation of average row length

Today, for estimating the average row length being passed to sort, REORG gets that from catalog statistics with either AVGROWLEN or COMPRESSRATIO. The reason RTS stats is not used, is because RTS only contains the compressed data size.
about 3 years ago in Db2 for z/OS 0 Future consideration

I would like to force the use of the "DEFER" option on the creation of an index (using Zparm to make it optional).

We have DBAs that at times (accidently) run a "CREATE INDEX" and fail to include the "DEFER" option. This is rather easy to do because the reverse engineering tools fail to create syntax with the "DEFER" option. The creation of indexes can be very...
over 3 years ago in Db2 for z/OS 0 Future consideration

Enhancement to Display Utility Command - V12-CERT-2017

Would like the ability to further filter utilities by their status when using the display utility command.
over 5 years ago in Db2 for z/OS 1 Not under consideration

Show DB2 Recovery progress status in the db2 master log

Improve the messaging in the db2 log in order to be able to have a better idea of the progress of a recovery and how long it might take. For instance, currently message DSNR048I is issued every 2 minutes during abort recovery. It would be very hel...
about 6 years ago in Db2 for z/OS 0 Future consideration

Rename Foreign Key

Up to now a RENAME FOREIGN KEY is only possible by dropping and re-creating it, thus asking for a CHECK UTILITY to be run.The enhancement of the ALTER to a RENAME would make those actions superfluous and would be much faster.
over 8 years ago in Db2 for z/OS 1 Not under consideration

possibility to add a column at the partition clause without dropping the table

We would like to have the possibility to modify the PARTITIONING clause without DROPPING the table, with an ALTER COMMAND
over 8 years ago in Db2 for z/OS 0 Future consideration

IFCID 172/196 (Deadlock/Timeout) – Add STCK for Held Locks

At IFCID 172/196 (Deadlock/Timestamp) please add a STCK for the held lock (blocker) when the lock was granted. In case of a lockout with this STCK the sequence of the locks, and so the sequence of the blocker-SQLs, can be reconstructed ‘post mor...
almost 9 years ago in Db2 for z/OS 1 Not under consideration