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

DB2 accounting SMF101 with reporting class

The absence of report class in DB2 SMF record 101 is cumbersome for capacity management. Report Class is used for workload reporting and accounting. To match SMF 72 (values by report class) with SMF 101 (values by thread, i.e. for userid and other...
almost 12 years ago in Db2 for z/OS 1 Not under consideration

Have new authority for REFRESH of MQT that does not require high privilege levels

We historically have an application batch userid that has DBADM authority. We are limiting all access to this ID to the minimally required authority it requires such as load, imagecopy and runstats at the DB level. When we started converting our t...
9 months ago in Db2 for z/OS 1 Not under consideration

More options for PROFILE tables for canceling long runing threads

There isn't any way by db2 to Automatically cancel thread that runing more than x seconds or used more than x cpu. Please add these option and other cancel options to MONITOR THREADS. It is similar to DB24ZOS-I-635 There are many options that toda...
almost 2 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

Enhancement to Display Utility Command - V12-CERT-2017

Would like the ability to further filter utilities by their status when using the display utility command.
about 7 years ago in Db2 for z/OS 1 Not under consideration

Simplify Alter

In Db2 z/OS version 10 Pending Alters/Deferred Alters were introduced. Deferred Alters are not compatible with most Immediate Alters. Deferred Alters need materializing REORG before immediate Alter, or the Immediate Alter has to be run before...
about 4 years ago in Db2 for z/OS 0 Not under consideration

Improving latch contention in Db2 z/OS

DB2 workloads run at a priority that is related to their origin (may it be batch, IMS, DDF, …) and according to WLM service class definitions. In high system utilization scenarios, or due to workloads running in a WLM service class with a resource...
about 3 years ago in Db2 for z/OS 1 Not under consideration

Allow column masking on system temporal tables

We have a few System Temporal tables that have sensitive data. We need to be able to create column masks on those columns. Currently we get a SQL20474N with Reason Code 17 when we try to run a CREATE MASK on system temporal tables.
over 3 years ago in Db2 for z/OS 1 Not under consideration

Lock escalation on HISTORY STATISTICS catalog tables for DROP statement

add the ability for lock escalation on the catalog tables which contains the HISTORICAL STATISTISCs data (SYSIBM.SYS...HIST)
about 12 years ago in Db2 for z/OS 1 Not under consideration

Changing partitioning key columns

Most of our tables that are created before DB2 V8 (and even some created later than that) uses the primary key as the partitioning key. The resulting partitioning key therefore consists of many columns, but the significant columns for partitioning...
over 11 years ago in Db2 for z/OS 1 Not under consideration