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 957

Online change of indexes

We would like to be able to alter indexes as an online change, regardless of whether it is a duplicate index or a unique index (in the latter case it will often be the addition of include columns). We often have changes to indexes in connection wi...
about 9 hours ago in Db2 for z/OS 0 Under review

Allow to query and stop an object in one go to avoid STOPP

HSM allows to move DB2 page sets by stopping them and copying them and then starting the page sets again. HSM does this by DIS DB(...) SP(...) USE and a subsequent STO DB(...) SP(...). If in the small timing window between the DIS command and the ...
12 days ago in Db2 for z/OS 0 Under review

Improve installation CLIST

I have just suffered over two days of Db2 Install Clist and can heartily recommend no-one use it to do a clean Install. The problems are myriad but the absolute number one is when it dies/crashes/abends all input data, apart from two or three rand...
4 days ago in Db2 for z/OS 0 Under review

ALTER TABLE DROP multiple COLUMNs

If you want do delete multiple columns of a table using "ALTER TABLE tbname DROP COLUMN colname", you currently have to execute many ALTER TABLE statements. The execution time increases exponentially with the number of columns to be deleted. If th...
25 days ago in Db2 for z/OS 1 Not under consideration

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

When DSNL077I tells us IN-USE DBAT is exceeding 85% of MAXDBAT then ALSO issue DISPLAY THREAD

DB2 has recently introduced message DSNL077I which tells us when IN-USE DBATS begin to exceed 85% of system parameter MAXDBAT. And the corresponding message of DSNL078I tells us when IN-USE DBATS falls below 75% of MAXDBAT https://www.ibm.com/docs...
2 months ago in Db2 for z/OS 1 Not under consideration

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 ...
4 months ago in Db2 for z/OS 1 Future consideration

IRLM enhancement in case of global deadlock processing

We had a situation which was described in case TS015567644. The symptom was that IRLM could not fully process the complete deadlock stuff of all members of an 8-way DS system. Therefore we get DXR167E in some of the members. Additional workload wi...
about 2 months ago in Db2 for z/OS 0 Future consideration

Db2 native and RACF security consistency requirement

This is especially important for shops like ours where for years DB2 native security and migrate to RACF security to be complaint with security audit and policies, and also new mainframe applications standards. There is multiple areas where curren...
5 months ago in Db2 for z/OS 2 Not under consideration

Remove some of the restrictions related to SQLCODE -20555

There is currently a restriction on the use of archive-enabled tables and temporal tables in one statement: The execution of this statement leads to SQLCODE -20555: SELECT * FROM DB2.LZTB0586 WHERE VNR IN ( SELECT VNR FROM DB2.LZTB0520) SQLERROR O...
8 days ago in Db2 for z/OS 0 Under review