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 958

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 7 years ago in Db2 for z/OS 1 Not under consideration

Implement a TRY_CAST specification or equivalent

Implement a TRY_CAST specification which is identical in syntax and semantics to a CAST specification, with the exception that it would return NULL and raise only an SQL warning, not an error, if the target data type is numeric, and the source typ...
almost 8 years ago in Db2 for z/OS 0 Not under consideration

Reset an invalidated statement level optimization hint

If a statement level optimization hint was invalidated for whatever reason one has to repeat the whole process to get the same hint again.
over 9 years ago in Db2 for z/OS 1 Not under consideration

Reduce locking on XML-auxiliary tables

Locking on XML auxiliary tables can be very CPU cost intensive and can lead to problems with the threshold LOCKS PER USER.Tune DB2s locking algorithms so that locking on XML-auxiliary tableswill be reduced.
about 10 years ago in Db2 for z/OS 2 Not under consideration

Allow all access paths in a cursor with FOR UPDATE

Due to the haloween-problem, some access paths are blocked for cursors with the FOR UPDATE-clause. Also for multi-row-fetch and FOR UPDATE there are restrictions if there is a IN-subquery
over 10 years ago in Db2 for z/OS 1 Not under consideration

Delay the insert into PLAN_TABLE, if EXPLAIN MODE is YES

We want to use SET CURRENT EXPLAIN MODE = YES in long running jobs like DSNTIAUL or DSNTEP2 to get more information, what was going on. If these jobs only ran select-statements a long running UOR is generated, because the insert of the access path...
over 10 years ago in Db2 for z/OS 0 Not under consideration

proactive messages of objects ??% full or 'follow-up objects free space' function inside Db2

Follow up TS and XS limits in Db2 z/OS is not an easy job. The last 6 months, we coped issues with partitioned indexes full. This were partitioned bases 'temporarily session' tables for applications, whereby the not active partition is cleaned up ...
about 1 year ago in Db2 for z/OS 0 Future consideration

RENAME function for tablespaces

the availability of the conversion of multi-table-tablespaces to UTS-PBG tablespaces is restricted to non-UTS tablespaces (source object). I would like to use this functionality to RENAME a tablespace (when the source is already a UTS-PBG TS) - bu...
over 3 years ago in Db2 for z/OS 0 Future consideration

Add a STOP DB2 mode that cancels connected threads, but not internal processes.

We have struggled with getting a "clean" shutdown of Db2 for years. If we try to use STOP DB2 MODE(QUIESCE), Db2 will not stop. Persistent threads from STCs such as CICS regions, WAS Z servants, and ARS CMOD servers do not "end", so they never al...
over 4 years ago in Db2 for z/OS 1 Not under consideration

extend MERGE syntax to allow Common Table Expressions (CTE)

The MERGE SQL statement is a new favourite SQL statement. But I also like to use Common Table Expressions (CTE). CTE can be used in other type of SQL (mostly SELECT) but CTE is not allowed with MERGE What is my idea? Allow MERGE to use CTE....
over 4 years ago in Db2 for z/OS 5 Not under consideration