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 (

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 ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Data & AI Roadmaps ( - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at



Db2 for z/OS

Showing 920

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...
about 11 years ago in Db2 for z/OS 1 Not under consideration

DB2 z/OS - Message id - DSNJ110E - Additional alerts for active log monitoring and highlighted new message id when DB2 logging was suspended

We had a major incident due to suspended logging for one of the critical customer. One of the critical production DB2 subsystem logging was suspended , caused by stalled archive log offloading process due to insufficient storage space on archive...
over 1 year ago in Db2 for z/OS 0 Planned for future release


Currently when DRAIN fails during REORG, a DISPLAY CLAIMERS is issued. The draw back is there is no "age" information, so user does not know which thread is the blocker, because the claimer could also be waiter.
about 3 years ago in Db2 for z/OS 3 Not under consideration

Create INDEX and SKPT lock. DDL and continuous availability.

Working in a banking 24x7 environment without any maintenance window our concurrency issues with DDL changes are increasing more and more everyday as our workload increases. There are some concurrency problems that we think it should value the eff...
over 3 years ago in Db2 for z/OS 5 Not under consideration

DB2 Trusted Contexts do not allow ADDRESS wildcarding

To request that DB2 Trusted Context allow wildcarding of TCPID addresses in the ADDRESS attribute.
over 8 years ago in Db2 for z/OS 1 Planned for future release

DB2 Return Code Differentiate for Deadlock and Timeout via Subsys Normal Call Exit

DB2 presents IMS ( via Subsystem Normal Call Exit ) with the same return code (4) for: DB2 resource deadlocks DB2 resource unavailable conditions Example, lock timeouts on object locks, such as are taken by DB2 utilities and those caused b...
over 1 year ago in Db2 for z/OS 7 Not under consideration


Hello Db2 for Z/OS Development. Apar PM89016 was created several years ago to implement the lock avoidance for singleton SELECTs with ISO(CS) and CD(YES) when R-scan is used, or the index that is chosen has matching predicates on all columns of th...
almost 3 years ago in Db2 for z/OS 2 Not under consideration

Add Two Factor Authentication support for Data Studio

Our z/OS security infrastructure now requires two factor authentication for all z/OS IDs which have elevated privileges. These IDs are required to configure new connections or apply maintenance for bind activities in DS. Are there any plans to add...
over 4 years ago in Db2 for z/OS 1 Not under consideration

Pseudo IFCID 316

When using REOPT(ALWAYS) on a batch package to deliberately avoid filling the Dynamic Statement Cache (DSC) the SQL is, correctly, not inserted into the DSC and is not exrternalized by an IFCID 316. However this then "hides" the workload from moni...
over 7 years ago in Db2 for z/OS 1 Not under consideration

Convert PBR tablespace to PBG without an outage

Right now we have situations come up where applications and DBAs have created partition by range (PBR) tables, and there is a need later on to convert these to partition by growth (PBG). Currently there is no way to do this without dropping the ob...
about 9 years ago in Db2 for z/OS 0 Planned for future release