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 (https://ideas.ibm.com).


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 (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


ADD A NEW IDEA

Db2 for z/OS

Showing 1002

Improved granularity for WITH clause

GGDB210017 Implement WITH clause syntax as a sub-clause for JOIN specification
over 12 years ago in Db2 for z/OS 1 Not under consideration

Introduce or Change Reorg for managing commits when generating Identity column values during the Reorg

When an identity column is added to an already existing and populated table, the table is put into a Reorg Pending status and thus unavailable to the applications. When the Reorg is run to resolve the status it generates the identity column values...
8 months ago in Db2 for z/OS 3 Future consideration

ALTER TABLESPACE DEFINE YES

Currently, if a tablespace or index is created with DEFINE NO, the underlying VSAM cluster is not created until the first row is inserted, or until LOAD RESUME NO REPLACE is executed. This is used a lot, for example, in SAP or PeopleSoft systems. ...
almost 7 years ago in Db2 for z/OS 0 Not under consideration

the SYSPACKAGE's column "lastused" needs to update more frequently

Hi IBM, As you see below in description of "lastused" column on SYSIBM.SYSPACKAGE, the updated must be done "whenever" the package is used but it's not true, so due to this doubt that we have when we saw that this column was not updated after pack...
almost 5 years ago in Db2 for z/OS 2 Not under consideration

RUNSTATS DIRECTORY (DSNDB01) TABLESPACES

Till now (DB2 12) it is not allowed to run RUNSTATS on the directory tablespaces.Because of features like LOB COMPRESSION or SPT01 COMPRESSION it is strongly recommended to have the possibility to run RUNSTATS on the directory tablespaces. We have...
about 8 years ago in Db2 for z/OS 1 Not under consideration

Remove a thread in DB2 which becomes COMMITTED-H or ABORTED with command -RESET INDOUBT IPADDR(*) FORCE without STOP DDF

Change the way to remove a thread which becomes COMMITTED-H or ABORTED-H after a RECOVER INDOUBT is to execute command -RESET INDOUBT IPADDR(*) FORCE without stopping the DDF
over 5 years ago in Db2 for z/OS 1 Not under consideration

Enhance the DISPLAY LOG COMMAND to show if a specific active log dataset belonging to one member of a data sharing group is allocated to 1 or more other members in the data sharing group.

This command would be useful to allow DB2 SYSPROGS/DBAs to see if a specific active log dataset belonging to one member of a data sharing group is allocated to 1 or more other members in the data sharing group. This would allow the REMOVAL PENDING...
almost 2 years ago in Db2 for z/OS 1 Not under consideration

DB2 V13 REMOVE LOG command - SET LOG REMOVE LOG

Hi, Please could the DB2 V13 command SET LOG REMOVELOG be updated as follows: 1. An option is provided so the the command either works or fails? We want the option to not have REMOVAL PENDING logs in our BSDS after a SET LOG REMOVELOG command is i...
almost 2 years ago in Db2 for z/OS 2 Future consideration

Allow the SQL ALTER statement to convert SYNONYMS into ALIASES.

We have over 800,000 synonyms across 100+ DB2 subsystems/data sharing groups to convert to aliases. In our production environments, the conversion of synonyms to aliases (DROP SYNONYM/CREATE ALIAS) is going to cause carnage because all of our prod...
almost 2 years ago in Db2 for z/OS 1 Not under consideration

Use Limitkeys as histogram-stats, if appropriate

Recently we had a Performance Problem where I was requested to collect histogram-stats for a column, which matches the partitioning column. Because this was a big table, running this runstats took about 9 hours to complete. If limitkeys could serv...
almost 9 years ago in Db2 for z/OS 2 Not under consideration