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 953 of 14486

INTERPRET Function for Packed-decimal Data

We have some old tables with a CHAR column where we store a record formatted by a Cobol Program. It contains a mix of display data and packed-decimal data. To use that data we have to read it in a Cobol program and interpret it using a Cobol copyb...
about 6 hours ago in Db2 for z/OS 0 Submitted

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...
about 13 hours ago in Db2 for z/OS 0 Submitted

RUNSTATS TABLESPACE INDEX (ALL) NPI NO

At the moment only a RUNSTATS TABLESPACE with INDEX (ALL) is possible. When using DSNACCOX suggestions for a RUNSTATS may be generated only for one or few partitions of a PBR-TS. I therefore suggest a additional parameter (e.g. NPI YES/NO) to cons...
1 day ago in Db2 for z/OS 0 Under review

Support SORTWK with EAV

We run a REORG on a tablepace (~5TB) with 3 IXs and need ~17TB sort space. One of the IX (an NPI) needs ~15TB. We had a pool with 30TB, but this does not help/count. Reason: As the allocation of the SORTWKs by DB2 is limited to 10TB (255 * the lim...
10 days ago in Db2 for z/OS 0 Under review

DSNJ114I should indicate the failed copy

We had an issue (see TS154521528) where we lost all archives due to an issue with the copy2 copies on tape but instead it was the copy1 that was indicated as failed due to a storage abend but without any external message.
21 days ago in Db2 for z/OS 1 Future consideration

EXPLAIN(ONLY) should create no locks

We did an rebind packages with EXPLAIN(ONLY) with an owner change and got into problems because rebind phase-in was not used. So there were a lot of locks which caused timeouts. The owner change for EXPLAIN(ONLY) is needed for a vendor tool. We th...
28 days ago in Db2 for z/OS 0 Under review

Include subsystem recognition character in DSNU000I message

Currently there is no deterministic way of knowing which subsystem DSNUTILB is connecting to. Especially true in a data sharing group when using a group attachment code. This would be useful for, for example, auditing purposes and, in some situati...
about 1 month ago in Db2 for z/OS 0 Under review

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.
about 1 month 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...
about 1 month 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...
about 1 month ago in Db2 for z/OS 0 Under review