Skip to Main Content
IBM Data and AI Ideas Portal for Customers
Hide about this portal


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 993

Allow FOR SYSTEM TIME ALL

If you have system-period temporal table you can query the table (and it's history table) with a period-specification: FOR SYSTEM TIME AS OF timestamp FOR SYSTEM TIME BETWEEN timestamp AND timestamp FOR SYSTEM TIME FROM timestamp TO timestamp ...
19 days ago in Db2 for z/OS 0 Under review

Allow us to use the profile tables to set the ACCUMACC zparm more granular

At the present time we have ACCUMACC set to 20. We have had to set this to 1 for problem determination purposes. In our active system it causes issues with our SMF jobs when we have done this for even a short time. We would like the ability to use...
almost 3 years ago in Db2 for z/OS 5 Not under consideration

When DSNL077I tells us IN-USE DBAT is exceeding 85% of MAXDBAT then ALSO issue DISPLAY THREAD

DB2 has recently introduced message DSNL077I which tells us when IN-USE DBATS begin to exceed 85% of system parameter MAXDBAT. And the corresponding message of DSNL078I tells us when IN-USE DBATS falls below 75% of MAXDBAT https://www.ibm.com/docs...
10 months ago in Db2 for z/OS 1 Not under consideration

Allow WITH UR for SET assignment-statement with row-subselect

Allow The WITH isolation level clause for SET assignment-statement with row-subselect. We need to be able to select data into a global array without imposing a share (or any other) lock.
21 days ago in Db2 for z/OS 0 Under review

Allow to query and stop an object in one go to avoid STOPP

HSM allows to move DB2 page sets by stopping them and copying them and then starting the page sets again. HSM does this by DIS DB(...) SP(...) USE and a subsequent STO DB(...) SP(...). If in the small timing window between the DIS command and the ...
8 months ago in Db2 for z/OS 0 Future consideration

Way to tell if a Db2 view is not being used any longer

We are looking for a solution to tell if a Db2 view is still used or not.A request came to our team to rename a column in several tables. One of the tables have multiple view on it, and one of the view includes the column to be renamed. We cannot ...
about 1 year ago in Db2 for z/OS 4 Future consideration

Indicate whether the fallback SPE for Db2 13 migration is installed

As a user planning to migrate to Db2 13 I already activated V12R1M510 on my Db2 12 subsystem. However, I also want to make sure that I have the fallback SPE PH37108 https://www.ibm.com/support/pages/apar/PH37108 installed. Could this information b...
over 2 years ago in Db2 for z/OS 5 Planned for future release

REBIND allocated plan

Before going to Db2 13 we have to rebind some plans that were last bound in Db2 10. We have also previously got the recommendation to rebind all plans when we have migrated to a new Db2 version. We have a problem with plans that are always allocat...
almost 2 years ago in Db2 for z/OS 1 Future consideration

Reduce shutdown time - allow for reduction of Db2 footprint before STOP DB2

As the Db2 footprint on our mainframe systems has increased (larger bufferpools, larger GBPs, more open datasets), one of the challenges we have faced is that Db2 takes longer to shut down. Our shop has recently focused on reducing down-time and i...
4 months ago in Db2 for z/OS 1 Not under consideration

Prevent VPSIZE(0) Bufferpool

The idea would be to have a permission or rule in place to prevent an alter bufferpool to VPSIZE(0). As it can cause major problems.
4 months ago in Db2 for z/OS 0 Under review