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 174

Improve implicit casting

Since V10 there is implicit casting, which is one hand a good feature, but on the other hand can lead to big performance problems. Improve the implicit casting so that the resulting datatype is indexable, e.g. make SELECT ... FROM T1 WHERE Integer...
over 9 years ago in Db2 for z/OS 1 Delivered

Enhancement for IRLM Global Deadlock Detection Process

Enhance the IRLM Global Deadlock Detection process so that a long list of waiters for a single resource does not impact entire datasharing group. Per pmr 24137 while performing the deadlock detection, the irlm main latch is held preventing other i...
over 5 years ago in Db2 for z/OS 1 Delivered

DB2/ZOS Use APREUSE(WARN) for all automatic rebinds

All package AUTOBINDs should be performed with the APREUSE(WARN) option. This mitigates the risk of a bad access change.
over 6 years ago in Db2 for z/OS 1 Delivered

allow SELECT with LISTAGG function to always allow ORDER BY

I am using DB2 Version 12. function level 501 I have a simple SQL example I show my co-workers to show the power of new DB2 SQL function of LISTAGG SELECT IXCREATOR, IXNAME ,LISTAGG(ALL COLNAME,',') WITHIN GROUP (ORDER BY COLSEQ) AS AL...
over 4 years ago in Db2 for z/OS 6 Delivered

Display profile command should have display system privilege

The -dis profile command is missing the DISPLAY system privilege authority. This is causing us security permission issues, as well as being inconsistent with how other display commands are set up (-dis ddf, -dis util(*) for example). Since we gran...
over 6 years ago in Db2 for z/OS 2 Delivered

DB2 Distributed Thread - hidden high CPU consumption

DB2 Distributed thread with long-running OPEN CURSOR is difficult to detect in DB2 monitors. The CPU consumption is not returned until the OPEN CURSOR completes . If the thread is cancelled while still in the OPEN CURSOR, the Accounting CPU consum...
over 5 years ago in Db2 for z/OS 2 Delivered

Improve DB2 DBD pool processing to prevent full and provide better diagnostics

Improve DB2 DBD pool processing by1) providing a dynamic increase process to help prevent full conditions (and therefore thread failures)2) providing better diagnostics to identify the DBD's consuming the most non-stealable space. Optionally - ide...
almost 7 years ago in Db2 for z/OS 1 Delivered

Client Application Name (QMDAAPPL from IFCID 0003) used in column RLFEUAN from SYSIBM.DSNRLMTxx tables to governor distributed applications

We would like to use table SYSIBM.DSNRLMTxx (SYSIBM.DSNRLMT01) in order to avoid that certain applications, coming from distributed environment and reaching Db2 for z/OS through DDF, can execute SQL statements. We’d like to completely block these ...
over 2 years ago in Db2 for z/OS 9 Delivered

Allow pending alter to convert multi table tablespaces to PBG

As with other conversions now supported, we are requesting the ability to convert multi table tablespaces (either simple or segmented) to UTS PBG tablespaces via a pending alter and an online reorg to materialize the pending changes. We have many ...
over 6 years ago in Db2 for z/OS 2 Delivered

need SQL tuning component

Now, we are using DSM to manage 235 sets of Db2 databases, of which SQL tuning is a more commonly used function for our system administrators and DBAs. We often use the SQL tuning function to optimize the SQL statements running in the production e...
about 4 years ago in Db2 for z/OS 1 Delivered

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.