Skip to Main Content
IBM Data Platform Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data Platform 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

Search results: Db2 for z/OS

Showing 129 of 1687

Granular grant-able authorization to allow explaining all statements stored in DSC

Currently there is a requirement to hold at least SQLADM authority to explain statements kept in DSC, and which were executed with a different SQLID. This is security exposure as for such basic action like statement explain it gives the user all t...
about 13 hours ago in Db2 for z/OS 0 Submitted

Complete PROFILE support for SQL tuning ZPARMS

While modelling a production system it was noticed that the PROFILE support is not 100% up to date and compatible with the actual ZPARMs that the Db2 Optimizer uses. I opened a case TS019778440 and they said "Yes, it is missing, please open an AHA...
3 months ago in Db2 for z/OS 0 Under review

Change Load Backout YES delete log process

During execution of LOAD RESUME YES BACKOUT YES SHRLEVEL NONE LOG NO DISCARDS 1, if 1 duplicate row is funded, all rows loaded will be backed out, regardless if there was just 1 duplicate. DB2 call Data Manager back out all the other rows writing ...
2 months ago in Db2 for z/OS 0 Under review

Support REORG for DEFINE NO

I have heard, in various IBM presentations (Haakon at IDUG Valencia, John Lyle at CCDB2) talking about Db2 Vnext, the statement "no migration to vnext if you have 6 byte RBA/LRSN or non-UTS tablespaces". This if fine unless you happen to have old ...
5 months ago in Db2 for z/OS 3 Under review

DISPLAY BUFFERPOOL issues a message, TOTAL SYNC I/O DELAY FOR BP?? = ?????????? MILLISECONDS.

We are currently are running a bufferpool simulation in production. When I issue the command: -DISPLAY BUFFERPOOL(BP40) DETAIL(INTERVAL) The following message is issued: DSNB432I -DPP2 SIMULATED BUFFER POOL ACTIVITY - AVOIDABLE READ PAGE MISSES - ...
3 months ago in Db2 for z/OS 0 Under review
119 VOTE

Resolve a restriction that CACHE DYN STABILITY function can not use with CONCENTRATE WITH LITERALS option.

Customer environment Db2 V12 <- DRDA -> Db2connect/JDBC(IBM Data Server Driver for JDBC and SQLJ type 2) Server side.(JDBC Type2 is used) Windows server: - WebSphere BASE 9.0.0 (Windows2016) - Db2client / IBM Data Server Runtime Client V11.1...
over 4 years ago in Db2 for z/OS 3 Future consideration

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...
over 3 years ago in Db2 for z/OS 5 Not under consideration

Enhance DSNJU008 LIST CDDS output to also list the number of tablespaces maintained in the CDDS

DSNJU008 LIST CDDS today lists the number of dictionaries contained in the CDDS. Example: “DICTIONARY RECORDS PRINTED 123”. This could be 1 dictionary of 123 tablespaces, or 41 tablespaces with 3 dictionaries for each (41 * 3 = 123). We would like...
about 2 months ago in Db2 for z/OS 0 Under review

Enhance DSN1COMP to provide more information on LOB's

There is a need to have a greater handle on LOB columns with regard to their size and storage. At the moment the only way to analyse the lengths of the LOBs is through using expensive SQL with BIF LENGTH and SUBSTR. It really only possible to do s...
12 months ago in Db2 for z/OS 3 Delivered

REORG with a new keyword should transfer the page set work to DFDSS

Why is the above idea useful? Sometimes you need to move page sets around due to altering the HLQ, due to removing extents etc. These actions do not require an unload and reload of the data, because it is external stuff out of DB2 scope. For small...
7 months ago in Db2 for z/OS 0 Under review