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 31

CREATE TABLE LIKE "table-controlled partitioning" should create the table with same partitioning scheme and rules

When a table that uses table-controlled partitioning is identified in the LIKE clause, the new table should automatic inherit the partitioning scheme of that table and create an uts PBR.
15 days ago in Db2 for z/OS 0 Under review

UTILITY wait for other Utility

Consider a Utility A executing on an Db2-object (example LOAD) and another incompatible Utility B trying to acquire drain on the same Db2-object (example QUIESCE). Db2 immediately rejects this Utility B, without waiting. We suggest a new Utility o...
17 days ago in Db2 for z/OS 0 Under review

Allow alter column to drop NOT NULL constraint

Currently the only way to remove the NOT NULL constraint from a column is to unload the table, drop-recreate table (or drop-add column) and reload table. Such a small change needs so much effort, and causes unnecessary outage and service disruptio...
22 days ago in Db2 for z/OS 0 Under review

In a UTS world shouldn't DSNUCH01 include DSNUM as 3rd column for this SYSCOPY's index?

In a UTS world shouldn't DSNUCH01 include DSNUM as 3rd column for the SYSCOPY's index?, since DB2 v12 all tablespaces should be defined as Universal Table Space, PBR or PBG. Segmented and Simple tablespaces are deprecated.
30 days ago in Db2 for z/OS 0 Under review

Allow a Db2 z/OS Server to request clients set other JDBC Data Server Driver parameters, such as minTransportObjects or maxTransportObjects

In FL502 of Db2 13, IBM offers MODIFY DDF with the "RQSTWLB" option which allows the Db2 server to tell clients to enable Sysplex Workload Balancing (enableSysplexWLB=true) as long as the client doesn't explicitly set WLB to "false". It would be b...
about 1 month ago in Db2 for z/OS 2 Under review

Db2: Recovery of Mainframe Db2 databases without applying changes.

When the DB2 is performing a recover it uses log and copy files, it may be some sitations where the log contains changes that we dont want to restore. For exemple we may have inserts made by an authorized program and also updates performed by an u...
about 1 month ago in Db2 for z/OS 0 Under review

LOAD Replace improvement for RI tables

We had a Db2 DDL change where a new table "b" was created with a RI constraint to a parent table "a" which was also modified (DROP/CREATE). Table "a" had several rows which were unloaded before the change and loaded back after the DDL changes (LOA...
about 1 month ago in Db2 for z/OS 0 Under review

Create a new BiF to do a real TIMESTAMPDIFF

The current scalar function TIMESTAMPDIFF is great if the difference is not over one month, then it starts guessing at how many days are involved. If you want to know the number of seconds between two timestamps it gives variously bad degrees of e...
about 1 month ago in Db2 for z/OS 0 Under review

Improvement in Db2 LOAD UTILITY processes associate with data replication via Qrep

-Need: Meet the growing demand for data replication from Banco do Brasil -Scenario: Banco do Brasil is a large user of data replication using Qrep (IIDR) + DB2 v13 for zOS, there are thousands of tables replicated from production environments for ...
about 2 months ago in Db2 for z/OS 1 Under review

Allow reset of all High Water Mark Statistics values

Currently some statistics HWM values are not reset while Db2 is active - e.g. Q3STCTHW. Consequently a transient event can hide a long term situation. This idea would allow those statistics to be re-set to zero - allowing performance management to...
about 2 months ago in Db2 for z/OS 1 Under review