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

My votes: Db2 for z/OS

Showing 957 of 14505

Improve Space Search Performance for Nearly Full PBR

Currently, when there are many concurrent inserts on a PBR which is nearly full, CPU and elapsed time for inserts increases by many orders of magnitude, to the point where it can completely monopolize the CPU on an LPAR. In past discussions, I was...
about 1 hour ago in Db2 for z/OS 0 Submitted

Write Failed Lock Escalation Attempts to Master

Currently, when Lock Escalation succeeds, a message is written to the Master Log with details. However, when a Lock Escalation attempt fails (due to a timeout or deadlock), nothing is written. This sort of timeout or deadlock can be difficult to d...
about 2 hours ago in Db2 for z/OS 0 Submitted

Extend Db2 Message monitoring IFCID 197 to include information about message tokens

Our shop is using ITM Situation management to heavily automate processing/notification for our customers and thus minimize the use of custom logic to be maintained (specific REXX programs etc.) . One feature that we leverage is the OMEGAMON for Db...
about 2 hours ago in Db2 for z/OS 0 Submitted

SQLJ Add support for use of Java Array in IN predicate

We would like to see support of Java type ARRAY for IN-LISTs. The use case would look like: SqljCtx sqljCtx = getSqljCtx(); Array fkpzOfflKtoIdsArray = sqljCtx.getConnection().createArrayOf("TIMESTAMP", fkpzOfflKtoIds); FremdkontoOfflineIterator i...
about 3 hours ago in Db2 for z/OS 0 Submitted

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...
1 day 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...
1 day 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...
2 days 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...
11 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.
22 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...
29 days ago in Db2 for z/OS 0 Under review