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 984 of 15522

Full EXPLAIN support for all types of trigger

With Triggers you cannot use the REBIND option OWNER on a rebind. Why not? Not even for EXPLAIN(ONLY). We must get the ability, like with "normal" packages, to EXPLAIN into another set of EXPLAIN tables. Further, if you are using Advanced Triggers...
over 2 years ago in Db2 for z/OS 2 Planned for future release

Allow to ALTER (and CREATE) a Db2 pageset with the max allowable size

The current maximum for PRIQTY is 64GB. If one wants to avoid extent processing in z/OS and has pagesets larger than 64GB, there is no option (besides user-defined pagesets) to achieve this. By using IAG2 we encountered the fact that IAG2 is somet...
12 months ago in Db2 for z/OS 0 Future consideration

z/OSMF workflow artifacts for Db2 UPDATE and ACTIVATE process

IBM z/OSMF workflows are being improved to be used for Db2 installation and migration. It would be nice if we have also the artifacts for the other CLIST processes: UPDATE and ACTIVATE. The UPDATE process is what we use the most.
about 2 years ago in Db2 for z/OS 0 Not under consideration

Allow reset of all High Water Mark Statistics values

Currently some statistics HWM values are not reset while Db2 is active - e.g. Q3STCTHW. Consequently a transient event can hide a long term situation. This idea would allow those statistics to be re-set to zero - allowing performance management to...
10 months ago in Db2 for z/OS 2 Not under consideration

Allow the ability to set the management, storage, and data classes the SPUFI panels.

We have a security policy requiring us to encrypt all possible 'Data at Rest'. We use the IBM solution called Pervasive Encryption (PE). Our storage team has defined SMS Data Classes that can be used to allocate encrypted datasets. In order ...
about 1 month ago in Db2 for z/OS 0 Under review

Allow REPLACE external SQL SP with Native

Currently, CREATE OR REPLACE PROCEDURE in DB2 13 has a limitation that " If a procedure exists with the specified name, the existing procedure must be a native SQL procedure". Migration from external SQL stored procedures to Native SQL stored proc...
about 1 month ago in Db2 for z/OS 0 Under review

Reference to the BSDS for example the full image copies of the CATALOG and DIRECTORY DB2 tablespaces which are not in SYSCOPY

There are several (4 in DB2 v12) catalog and directory tablespaces for which the full image copies are not referenced in the SYSCOPY.Thus, during a DB2 cat/dir recovery (recovery exercise or other...) these FICs are searched directly in the DB2 lo...
about 1 year ago in Db2 for z/OS 1 Not under consideration

JDBC connection property currentSchema should be externalised in an IFCID

We have jdbc applications which have set the jdbc property currentSchema to determine the collection of db2 objects like tables, views etc. When we want to trace the application with a performance trace, we're not able to analyse the correct colle...
about 2 years ago in Db2 for z/OS 2 Future consideration

Allow Encrypted Connection for IBM Debug Tool and Unified Debugger

Reviewing the connection with the Db2 Unified debugger, it was determined it was not using an encrypted port. All tools (mainframe or otherwise) should support full encryption over ATL-TLS.
about 1 month ago in Db2 for z/OS 0 Under review

Use profile tables for local applications

We use profile tables successfully for different scenarios. In addition to remote applications, our DB2 IT infrastructure also includes local applications for which we also have profile table usage scenarios. For example, we set the explain mode f...
12 months ago in Db2 for z/OS 7 Future consideration