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 777

Enrich DSNT772I with scope details

Below is the current DSNT772I message. It would be helpful if the actual scope details are provided in the message rather than a generic "IPADDR" or "AUTHID". We would prefer to see the actual IP address or AUTHID. DSNT772I -D851 DSNLILNR A MONITO...
about 5 years ago in Db2 for z/OS 0 Not under consideration

Allow RUNSTATS SHRLEVEL CHANGE to operate as the name says

This RFE is a result of the PMRs (31614,112,848) we have opened where the root cause was identified as invalid values in RTS tables. Current design allows to re-initialize certain fields in RTS (eg. TOTALROWS) only by executing RUNSTATS SHRLEVEL R...
about 5 years ago in Db2 for z/OS 2 Not under consideration

Allow BIND EXPLAIN(ONLY) use virtual indexes

It would be very helpful if Db2 allowed (optionally) to use virtual indexes when BIND with EXPLAIN(ONLY) is performed. This can be an additional BIND parameter on whether or not use virtual indexes. This option will eliminate/reduce a need in thir...
over 5 years ago in Db2 for z/OS 6 Not under consideration

Make Select Into Global Variables dynamically preparable

DB2 for z/OS v12 currently only allows SELECT ... INTO in app. programs and stored procedures. It would be extremely useful if users could perform SELECT INTO global variables in dynamic queries.
over 5 years ago in Db2 for z/OS 0 Not under consideration

Use CURRENT SCHEMA for EXPLAIN table SCHEMA

Currently the CURRENT SQLID is the only SCHEMA used by EXPLAIN processing. This is a real pain as changing the CURRENT SQLID is an auditable event. The use of SET CURRENT SCHEMA works for *all* other cases - Only EXPLAIN fails here. So the request...
over 5 years ago in Db2 for z/OS 0 Not under consideration

DB2 z/OS LOAD utility fail in utilinit holds UTUT status

LOAD REPLACE LOG(YES) fails due to share locks/claims being held on tablespace but leaves tables in UTUT status which makes in inaccessible. Suggest that the UTUT is removed or changed to UTRW and can attempt UTUT again upon restart of the utility...
over 5 years ago in Db2 for z/OS 0 Not under consideration

Add SYSDISC DSNTIAUL format to REORG utility

Sometimes there's a need to repopulate DB2 tables concatenating outputs from REORG SYSDISC and DSNTIAUL in a single LOAD SYSREC file. So the idea is to have a parameter like REORG ... SYSDISC FORMAT INTERNAL|DSNTIAUL. Basically the difference betw...
over 5 years ago in Db2 for z/OS 0 Not under consideration

Db2 FCIC should provide option to avoid taking long time with IGD17291I message

Please refer to the existing RFE ID 126885, "FCIC JOB takes long time with msg IGD17291I", opened from z/OS (DFSMS DSS) side, also. The data amount will be extremely increasing in our customer. To minimize data unavailability, they are trying to...
over 5 years ago in Db2 for z/OS 0 Not under consideration

Allow multiple ALTER PART nnn VALUES clauses in one ALTER TABLE stmt instead of SQLcode -637 error

Requirement to alter many partition limit key values for a PBR tablespace. New values come from external source so REORG REBALANCE is not suitable. With index-based partitioning it is possible to alter multiple partition limit keys in a single AL...
over 5 years ago in Db2 for z/OS 0 Not under consideration

DSC comment support

Currently the DSC only supports /* */ style starting comments. The "normal" -- style causes the SQL to never be cached! This is naturally very bad as loads of JAVA coders start their SQL with a -- comment to internally document the SQL code. This ...
over 5 years ago in Db2 for z/OS 0 Not under consideration