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

Dynamic Plan Stability - Option to restabilize an invalidated query missing

We've got several SQL queries stabilized with dynamic plan stability. Reason is to prevent them from getting a bad accesspath. After operations like "ALTER TABLE ... ROTATE PARTITION..." the query is flagged to valid N in SYSIBM.SYSDYNQRY. Than we...
about 4 years ago in Db2 for z/OS 0 Not under consideration

Support more granular system parameter settings

Support the ability to set system parameters at the application level.For example, allow parameters to be specified based on specific:- plan- package (specify collection, package)- authid or role- client info properties DB2 should have the ability...
about 9 years ago in Db2 for z/OS 0 Future consideration

FL LEVEL support

In Db2 12 the Functional Level is currently *not* externalized in various places where it most definitely should be. Notably the PLAN_TABLE, IFCID 316 and IFCID 401. If you are attempting tuning you *must* know under which FL level the SQL in ques...
over 6 years ago in Db2 for z/OS 0 Not under consideration

DB2 Z/OS Sync Logical and Physical Parts after full Reorg

ADD PART was used to insert a new physical partition in the middle of a tablespace. Now the Logical and Physical partitions are mismatch. If a Full Reorg on the full tablespace is performed, the utility can include an option to resync the logical ...
about 3 years ago in Db2 for z/OS 1 Not under consideration

Restart Time of DB2 should not be dependent on SCA size

During restart of DB2, the time difference between DSNR003I and DSNR004I is a function of the SCA size. Case TS009645595 was opened and has all the details. But in summary: this large time differenece of 30 seconds (in our case) is a function of t...
about 1 year ago in Db2 for z/OS 1 Not under consideration

DGTT - declare and use in one SQL statement (basically, this RFE is extension to syntax and functionality of DGTT)

Sometimes we use DGTT to hold complex result sets with many columns. We must DECLARE the DGTT first… and then second, INSERT into the DGTT The DECLARE requires us to think about each column name and type if we list them explicitly.OR. We can DEC...
about 5 years ago in Db2 for z/OS 3 Not under consideration

Reduce message flooding on system console using Db2 System Profile Monitoring for security profiles when detecting non-secure connections and WARNING_DIAGLEVEL3

This Aha idea is being opened on behalf of Commerzbank (Ute Kleyensteuber). Security profiles are used with System Profile Monitoring filter LOCATION=*, ATTR1=WARNING_ DIAGLEVEL3, ATTR3=1 (TLS required) to discover all incoming non-secure connecti...
7 months ago in Db2 for z/OS 1 Not under consideration

Command to display the DB2 early code

Customer wants to apply new early code with REFRESH DB2, EARLY by automation software. To be sure that they apply new code, they want to display the early code before the REFRESH DB2 command. Unfortunately this command is not yet implemented, and ...
about 12 years ago in Db2 for z/OS 1 Not under consideration

DB2 REST Services support HTTP OPTIONS call

DB2 support HTTP OPTIONS request. At present DB2 does not recognize the OPTIONS request type. Software stacks now are using security feature that for cross domain HTTP requests they issue the HTTP OPTIONS request first.
almost 6 years ago in Db2 for z/OS 0

Control of Locksize and Maxpartitions for implicitly defined tablespaces.

We must be able to control parameters like locksize and maxpartitions on implicitly defined tablespaces.In DB2 V12R1M504 multi table tablespaces are deprecated, so we need to use implicitly defined tablespaces for QMF useres. Today we use segmente...
almost 5 years ago in Db2 for z/OS 2 Future consideration