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 Utilities Suite for z/OS

Showing 106 of 15641

DB2 utility should be protected in case of abend 878 - end of memory

Hello there, This is related to IBM case TS016981605. DB2 was not able to manage correctly 878 abend (end of virtual memory below 16M line). Because of that, we had troubles in our production environment. In this case, IBM suggested to require a "...
4 months ago in Db2 Utilities Suite for z/OS 1 Future consideration

UNLOAD SYSPUNCHONLY or UNLOAD NOSYSREC

We are having many developers that need only the SYSPUNCH produced by UNLOAD but not the SYSREC. Having this option available either via SYSPUNCHONLY or NOSYSREC parameter will allow them to get quickly what they need without unloading of data whi...
8 days ago in Db2 Utilities Suite for z/OS 1 Submitted

UTILITY wait for other Utility

Consider a Utility A executing on an Db2-object (example LOAD) and another incompatible Utility B trying to acquire drain on the same Db2-object (example QUIESCE). Db2 immediately rejects this Utility B, without waiting. We suggest a new Utility o...
10 months ago in Db2 Utilities Suite for z/OS 1 Not under consideration

There should be a Db2 utility to delete rows from SYSIBM.SYSOBJEVENTS and SYSIBM.SYSUTILITIES

Currently there is no to delete rows from SYSIBM.SYSOBJEVENTS and SYSIBM.SYSUTILITIES and these tables will keep growing. All sites with these tables enabled require this. The utility could be an extension of the functionality of "MODIFY RECOVERY"...
3 months ago in Db2 Utilities Suite for z/OS 1 Not under consideration

DISPLAY UTIL should show more detailed count for the displayed phases

We have a REBUILD IX job with a table which has 8.5 billion rows. During the rebuild DIS UTIL shows for the UNLOAD phase a higher count than 8.5 billion e.g 10 billion or more. Therefore I openend a case how could it be that this number is higher ...
5 months ago in Db2 Utilities Suite for z/OS 0 Future consideration

Support SCOPE PENDING on REORG INDEX

With Db2 13 FL506 LOAD partition clearing and NOKEYDELETE, NPIs are left in a pending state that needs to be resolved by a REQRG INDEX. Users will have to find there NPI indexes and submit the REORGs for them. With SCOPE PENDING support in REORG I...
27 days ago in Db2 Utilities Suite for z/OS 0 Submitted

Support SORTWK with EAV

We run a REORG on a tablepace (~5TB) with 3 IXs and need ~17TB sort space. One of the IX (an NPI) needs ~15TB. We had a pool with 30TB, but this does not help/count. Reason: As the allocation of the SORTWKs by DB2 is limited to 10TB (255 * the lim...
9 months ago in Db2 Utilities Suite for z/OS 0 Future consideration

Reorg Index materialization

For REORG INDEX pending alter materialization, the utility performs a DRAIN ALL on the target index before starting the SWITCH phase, and then relies on DDL/Dependency logic to invalidate all the affected plans/packages/DSC...etc in the middle of ...
about 2 months ago in Db2 Utilities Suite for z/OS 0 Submitted

ENHANCEMENT FOR REDIRECTED RECOVERY - CHECK SCHEMA ONLY

ENHANCEMENT FOR REDIRECTED RECOVERY - CHECK SCHEMA ONLY The DB2 redirected recovery functionality allows RECOVER utility to be used to redirect the recovery of an object (the source) to another object (the target). The source and target objec...
about 2 years ago in Db2 Utilities Suite for z/OS 5 Future consideration

Reorg Utility should leave objects in Status UTUT when victim of a Timeout of DBD01

We have the problem, that every now and then a reorg abends because of a timeout of DBD01 in the switch-phase. The reorged object remains in status UTUT and cannot be accessed by anyone, until the utility is terminated via command.After a long tim...
3 months ago in Db2 Utilities Suite for z/OS 1 Future consideration