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 959 of 14552

Enhance Trusted Context d...

Actually it is not possible to use JOBNAME (local) and ADDRESS (remote) for option ATTRIBUTES (mutually exclusive) for Trusted Context definition.
about 7 years ago in Db2 for z/OS 0 Planned for future release

New message reporting tha...

RTS Temporal tables are defined as UTS/PBG/MAXPART 1. Please provide a message if e.g. 80% of available space is reached and a second message if e.g. 90% are reached. The message should be written once if the threshold is reached. It might be help...
about 7 years ago in Db2 for z/OS 0 Future consideration

V12-CERT-2017 Refresh VIEW / CREATE OR REPLACE VIEW / VIEW VERSIONING.

While tables can be altered online; views need to be dropped and recreated, resulting in business impact or planned downtimes (our environment is making extensive use of the ANSI SPARC three level architecture, with many views and views on views)....
about 7 years ago in Db2 for z/OS 1 Not under consideration

DB2 SQLCA feedback field indicating if this UOW is blocking others

On DB2 12 CERT (V12-CERT-2017) we discussed the possibility of increasing concurrency in DB2. In a typical batch environment we try to balance #of commits towards concurrency using a so-called commit-control-system that will have COMMIT on a numbe...
about 7 years ago in Db2 for z/OS 1 Not under consideration

PieceMeal Delete without coding application

During CERT (V12-CERT-2017) it was a desire amongst several customers to get a sort of imbedded COMMIT in the new piecemeal DELETE - when running from TSO attachment.-Alternatively to allow procedural language (SQL PL like) syntax in SPUFI/DSNTEP2...
about 7 years ago in Db2 for z/OS 1 Not under consideration

EXPLAIN Authority - Include Explain of Dynamic Stmt Cache

Include Explain of Dynamic Statement Cache with the EXPLAIN authority or create a new authority that has EXPLAIN plus EXPLAIN STMTCACHE but not all the authority of SQLADM (ie update of DB2 Catalog Tables)
about 9 years ago in Db2 for z/OS 1 Not under consideration

Increase (over current limit of 10000) the value for Zparm MAXARCH

Is it possible to increase (over current limit of 10000) the value for Zparm MAXARCH (archive log volumes that are to be recorded in the BSDS). Our Production System sometimes cuts over 5,000 Archive Logs in the business' standard Image Copy reten...
over 3 years ago in Db2 for z/OS 1 Not under consideration

A Sort-Merge Join should be considered when joining on a SUBSTR expression

When tuning the following query, I saw that changing the "INNER JOIN" to a "FULL JOIN" caused it to perform many times better (which changed the join from a NLJ to a SMJ): SELECT ARCHIVE_STRT.LOCAL_TS AS LOCAL_TS_STRT, TIMESTAMPDIFF(2, CAST(ARCHIV...
over 3 years ago in Db2 for z/OS 1 Not under consideration

DCLGEN ignores hidden columns

We have defined columns with "IMPLICITLY HIDDEN" and want to generate the host variable declarations with the DCLGEN command which is described with"The declarations generator (DCLGEN) produces an SQL DECLARE TABLE statement and a COBOL, PL/I, or ...
over 9 years ago in Db2 for z/OS 1 Not under consideration

keeping track of CFIGIN input in DSNTIJRT job.

You are keeping track of CFIGIN input manually now. One DB2 supplied stored procedure has been added during maintenance How can you migrate to a new version of DB2 and make sure you are current? clist developer already refrenced our request and he...
about 11 years ago in Db2 for z/OS 0 Planned for future release