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 309

Instantiated temp tables with full functionality

The SAP data dictionary supports the creation of temp tables. This allows application developers to speed up the processing by temporarily storing result sets of queries in the database and later process them. The data is only kept until commit. T...
about 6 years ago in Db2 for z/OS 1 Future consideration

Package Invalidation avoidance

At the moment nearly all online definition changes to an object leads per default to package invalidation.So online schema evolution is very useful, but with regarding to the availability (7*24) the package invalidation isn't a great implementatio...
over 4 years ago in Db2 for z/OS 0 Future consideration

Change DCLGEN to generate S9(4) COMP-5 instead of S9(4) COMP for SMALLINT columns

DCLGEN generates SMALLINT fields as S9(4) COMP with acceptable values +32767 through -32768. A Cobol 'MOVE' makes truncation possible and renders any value over 9999 risky. IBM Case Number: TS003249935
over 1 year ago in Db2 for z/OS 1 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.
over 2 years ago in Db2 for z/OS 0 Future consideration

DSM Explain profile

Hello, Our idea is to use DSM so that users, authenticated in DSM with administrator profile, can do EXPLAIN without the need to have DB2 z/OS operation user credentials, as in the case of Data Collection Credentials. We have a generic user crea...
about 2 years ago in Db2 for z/OS 2 Future consideration

Alters to objects that require reorg to material should be put into advisory reorg, such as PCTFREE

If an alter is done to a TS to PCTFREE and a REORG is not run, then the catalog is updated but the change is not materialized. This results in the DBA thinking it was done, but it really wasn;t.
almost 2 years ago in Db2 for z/OS 0 Future consideration

Db2 To Provide A Way To Override Certain Implicit Table Space Parameters Default Values

TSYS has QMF applications running in 6 UAT and Production Db2 environments. There are approximately 2,600+ client users running QMF queries and procs for their applications in those Db2 environments. Many of the users are creating temporary tables...
almost 3 years ago in Db2 for z/OS 0 Future consideration

Be able to ALTER the partitioning key of a UTS PBR

Currently if the partitioning key needs to be changed this involves a UNLOAD/DROP/CREATE/LOAD which is disruptive. This needs to be changed to ALTER REORG.
9 months ago in Db2 for z/OS 0 Future consideration

Native Stored Procedure debugging for SQLPL

Hello! This is RFE(request for Enhancement) to deploy IBM DSM for our environment. My company Ford requires to add "Native Stored Procedure" debugging for SQLPL, which is required as high priority to support out business. the second requir...
over 2 years ago in Db2 for z/OS 1 Future consideration

need SQL tuning component

Now, we are using DSM to manage 235 sets of Db2 databases, of which SQL tuning is a more commonly used function for our system administrators and DBAs. We often use the SQL tuning function to optimize the SQL statements running in the production...
over 1 year ago in Db2 for z/OS 0 Future consideration