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 1013 of 16109

High number of LOCK reqeusts against one LOCK1 structure need relief

We have a very high volume of lock requests against LOCK1 CF structure. This number increases month by month. Of course, the LOCK1 structure does not scale infinitely, therefore we need a relief here.
about 5 hours ago in Db2 for z/OS 0 Under review

Add metrics to distinguish between a real active DBAT and a "cached" DBAT if High Performance DBAT is used

If High Performance DBAT is activated there is no flag in -DIS THREAD or in IFCIDs to distinguish between a real active DBAT (processing work) or a "chached" DBAT waiting for work. In a high volume environment as in our shop, it is critical to ide...
about 5 hours ago in Db2 for z/OS 0 Under review

-DISPLAY PROCEDURE - Show All Stored Procedure Types

Show Native Stored Procedures in -DIS PROC regardless of DEBUG mode. The existing limitation becomes a monitoring showstopper as more and more Native SQL SPs are utilized in Production.
1 day ago in Db2 for z/OS 0 Under review

Improve auditing possibilities

As Db2 for z/OS users, we want to use the AUDIT POLICY functionality to support internal and external auditors and provide the proof of proper allowed access to Db2 z/OS objects, especially in the form of SQL queries using input host variables (“f...
10 days ago in Db2 for z/OS 0 Under review

Usage of Reoptimization for remote applications with DB2 Profiles

In many access path issues for applications with remote dynamic SQL statements reoptimization techniques (similar to the REOPT(ONCE/AUTO/ALWAYS) BIND Option for Db2 packages) controlled by Db2 profiles should be a performance benefit
10 days ago in Db2 for z/OS 0 Planned for future release

SQL Tuning Services - client plugin - default options dialog on "Database connection profiles"

We have installed the “Db2 tuning services” on the mainframe. As client software we use the corresponding plugin in IDZ and also VS Code. If we now want to visualize the access path of a selected SQL statement, we must first define the correspondi...
11 days ago in Db2 for z/OS 0 Under review

Need a Db2 option to return control (and not wait) if the maximum number of threads is already reached

We've seen cases in z/OS DFSMS OAM where the application invoking OAM can use up the available Db2 connections/threads so when OAM goes to process their request, there are no longer any threads available resulting in a deadly embrace. Typically th...
14 days ago in Db2 for z/OS 0 Under review

For online REORG, create parameter to set RC=4 when DRAIN fails

I am creating a scheduled job to perform regular REORGs of the Db2 Catalog. I am generating a list of catalog objects and feeding it to LISTDEF and then using ITEMERROR,SKIP I am using extremely gentle DRAIN settings...DRAIN_WAIT of 2 or 3 seconds...
14 days ago in Db2 for z/OS 0 Under review

REORG with a new keyword should transfer the page set work to DFDSS

Why is the above idea useful? Sometimes you need to move page sets around due to altering the HLQ, due to removing extents etc. These actions do not require an unload and reload of the data, because it is external stuff out of DB2 scope. For small...
16 days ago in Db2 for z/OS 0 Under review

ALTER STOGROUP can run in parallel to applications => Deferred ALTER

We need to move a lot of page sets and hence a lot of data from one z/OS catalog to another and also to other stogroups and volumes. For this task we nned to ALTER the hlq of the page sets and move them via DFDSS FASTREPLICATION. Unfortunately the...
16 days ago in Db2 for z/OS 0 Future consideration