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 964

Provide incremental progress messages through a DB2 group restart

During a recent DR activity our Db2 had issues during group recovery and it was challenging to determine at what point Db2 had gone as far as it could before requiring the other member to be restarted to resolve any locks RC00C200EB . The MSTR log...
over 1 year ago in Db2 for z/OS 1 Future consideration

Implement a TRY_CAST specification or equivalent

Implement a TRY_CAST specification which is identical in syntax and semantics to a CAST specification, with the exception that it would return NULL and raise only an SQL warning, not an error, if the target data type is numeric, and the source typ...
about 8 years ago in Db2 for z/OS 0 Not under consideration

Ability to stop AOT and other db2 tables on IDAA

When we STOP or start for UT ,spaces of tables that are loaded to IDAA or spaces that relate to AOT's, these spaces are still available for the IDAA. We can SELECT data from the IDAA for these tables and for AOT's' we can also update them. We need...
over 1 year ago in Db2 for z/OS 1 Not under consideration

Better filter factors - use RI for this

The Db2/LUW optimizer has some algorithms that affect the optimization of queries on that platform based on the fact that RI is involved. But, Db2 for Z can calculate very incorrect filter factors that can be much more correct if Db2 enforced RI w...
about 5 years ago in Db2 for z/OS 1 Not under consideration

sqlcode -803 INSERT precheck

Looking at DB2 log when a SQLCODE -803 duplicate key condition occurs in an INSERT often leads to a rollback of the change already made to the tablespace and/or in the non unique indexes defined against the affected table. Would it be possible to ...
almost 2 years ago in Db2 for z/OS 1 Not under consideration

Provide a default PLAN_TABLE and DSN_STATEMENT_CACHE_TABLE

If we use the CURRENT EXPLAIN MODE special register more widely, we have to create either a PLAN_TABLE and a DSN_STATEMENT_CACHE_TABLE or an ALIAS for each user. If we forget it, it doesn't work. So if there would be a default table for both, all ...
almost 11 years ago in Db2 for z/OS 0 Not under consideration

Timestamps in system generated messages in STDERR in a java WLM.

The STDERR in a java WLM does not include a timestamp of when the message was written. It's hard to cross check the system message produced with an application issue.
almost 4 years ago in Db2 for z/OS 3 Not under consideration

UNLOAD Utility should have the ability to generate IGNOREFIELDS YES

This is a manual effort using INSYNCH to add this to the load cards
almost 4 years ago in Db2 for z/OS 1 Not under consideration

Unload should generate the correct load cards to load Temporal Base Tables

Currently the unload utility generates load cards with Temporal Column Names having different names as the DB2 catalog. This causes the load to generate new values for ROW BEGIN, ROW END, TRANSACTION START ID which is incorrect. Having INSYNCH sof...
almost 4 years ago in Db2 for z/OS 0 Not under consideration

allow CREATE FUNCTION with RETURNS TABLE to use SQLPL

Today (in V12 <and maybe earlier>) it is possible CREATE FUNCTION using SQLPL and RETURN a value (of any data type). This is pretty cool.. and powerful. This is useful to perform complex SQLPL operations inside the UDF (LANGUAGE SQL). For ex...
almost 4 years ago in Db2 for z/OS 1 Not under consideration