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 187

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.
about 7 years ago in Db2 for z/OS 1 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...
almost 7 years ago in Db2 for z/OS 2 Delivered

SQLCODE -20528 SQLCODE20528N

CCB occasionally received SQLCODE -20528. As stated in DB2 CODES manual, this can occur while two transactions trying to update a row in system-period temporal table closely. A row being moved to history table can have sys_start higher than sys_en...
about 6 years ago in Db2 for z/OS 5 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...
over 7 years ago in Db2 for z/OS 1 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...
almost 6 years ago in Db2 for z/OS 2 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 ...
about 7 years ago in Db2 for z/OS 2 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 ALL_COLS ...
about 5 years ago in Db2 for z/OS 6 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...
over 4 years ago in Db2 for z/OS 1 Delivered

Provide compression capability for LOB tablespaces

As per IBM DB2 documentation, data in a LOB tablespace can not be compressed. The new feature we are requesting is that compression be available for LOB tablespaces.
almost 12 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 ...
about 3 years ago in Db2 for z/OS 9 Delivered