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 176

Ensure data consistency in even the biggest LOBs without compromising availability

The only way to ensure data consistency in Db2 LOBs, is by regularly checking – and by always to ensure that we have at least one full and consistent image copy of all LOBs. Not to compromise availability, all CHECK LOB utilities must use SHRLEVE...
over 4 years ago in Db2 for z/OS 11 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 V12 function level instead of simply saying (New Function Activated)

When a Database Connection has been made, Data Studio displays the DB2 version of the data server and the fact if it is in New Function Mode or not. This type of information is sufficient for DB2 for z/OS V11 or earlier which really only had m...
over 4 years ago in Db2 for z/OS 1 Delivered

Enhance IFCID 389 for number of FTB traversals

When analyzing our company's benefits using FTB for Indexes I did not find a proper way to get the number of index getpages we saved using FTB. IFCID 199 does contain the number of getpages per pageset but the documentation of IFCID 199 also says...
over 4 years ago in Db2 for z/OS 2 Delivered

Change IRLM hashing algorithm to offer a better and more efficient distribution of P-locks across LTEs

As per PMR 76883,999,866/TS002531202, when increasing DSMAX and PCLOSET/N parms to reduce TCB DBM1 CPU time owing to less open/close operations, we noticed a significant increase in IRLM CPU time, strongly correlated with higher number of currentl...
almost 5 years ago in Db2 for z/OS 2 Delivered

Would like means of collecting Maxdbat information by AUTHID

We are in the process of providing max thread limits via the Db2 Profile tables AUTHID entries for our applications. We would like to use a AUTHID=* entry to provide a default thread limit and use AUTHID=xxx values for applications which may need ...
almost 5 years ago in Db2 for z/OS 1 Delivered

Make parent business temporal table updatable

Business temporal tables that are parent table in referential integrity relationship cannot be updated in a way that reflects the time dimension of the data. As described in the attached document there is no way to change any column value from a s...
almost 5 years ago in Db2 for z/OS 2 Delivered

Db2 trace data should provide metrics related to usage of SysplexWLB (Workload Balancing) option

On our approach to change all remote connections to Db2 for z/OS into using SysplexWLB (workload balancing) option, we are missing a way to measure our progress here. (i. e. Java applications with property setting enableSysplexWLB=true) We would ...
almost 5 years ago in Db2 for z/OS 1 Delivered

Db2 trace data should provide metrics related to secured connections (SSL, AT-TLS)

On our approach to convert all tcp/ip based connections to Db2 for z/OS to secured/protected ones (SSL,AT-TLS), we are missing a way to measure our progress here. The only way to get information about the portion of secured connections is (as far...
almost 5 years ago in Db2 for z/OS 1 Delivered

Enable DSN1COMP to work on compressed tablespace data

We want DSN1COMP to be able to work with compressed table data. These days we've got an usecase, where we needed to check, if a new compression dictionary will saves us some MB/GB in a nearly completly full tablespace. Because of his size, we were...
almost 5 years ago in Db2 for z/OS 4 Delivered