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 1010

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...
1 day ago in Db2 for z/OS 0 Submitted

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
1 day ago in Db2 for z/OS 0 Submitted

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...
2 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...
7 days ago in Db2 for z/OS 0 Under review

REORG PREFORMAT of 1 TB page set should be interruptable

With PH64760 one can create 1TB page sets in one step. If one runs a REORG PREFORMAT on such large objects, the Media Manager Preformat task is not interruptable. Such a size of 1TB needs ~1.5hours to preformat the page set. In the meanwhile neith...
8 days ago in Db2 for z/OS 0 Under review

RUNSTATS TABLESPACE on one TS partition scans all partitions of partitioned indexes

We encountered that the RUNSTATS on one TABLESPACE partition via RUNSTATS TABLESPACE ... PART or via LISTDEF INCLUDE TABLESPACE ... PARTLEVEL scans all partitions of a partitioned index. Therefore the runtime and the zIIP time of the jobs are extr...
29 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...
7 days ago in Db2 for z/OS 0 Under review

Blocking Db2 connections to reduce the DSNL030I message flooding.

PTF delivery by IDEA DB24ZOS-I-1342 has already included the reduction of the DSNL030I message, it is working well for messages with REASON=00F3008* but the PTF does not include messages with REASON=00D30113 (invalid RACF ID), so these messages st...
28 days ago in Db2 for z/OS 0 Future consideration

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...
5 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...
5 days ago in Db2 for z/OS 0 Under review