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 104 of 15492

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...
9 months ago in Db2 Utilities Suite for z/OS 1 Not under 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 ...
24 days ago in Db2 Utilities Suite for z/OS 0 Submitted

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"...
2 months ago in Db2 Utilities Suite for z/OS 1 Not under consideration

Reorg discards with PARTITION range for PBR

we are using PBR with multiple partitions per month. We perform reorg discards with PARTITION range like 1: 4. But discarded data is going to a single file when do the discards with range partition. example: We would like to get the first-part dat...
17 days ago in Db2 Utilities Suite for z/OS 0 Submitted

Modify Recovery for COPY YES indexes

at the moment any SYSCOPY (and SYSLGRNX) entries for COPY YES indexes are deleted based on the corresponding action taken on the Tablespace (or partition). The strategy to keep the image copies and SYSCOPY related information for tablespace can be...
20 days ago in Db2 Utilities Suite for z/OS 0 Submitted

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...
2 months ago in Db2 Utilities Suite for z/OS 1 Future 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 ...
4 months ago in Db2 Utilities Suite for z/OS 0 Future consideration

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

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...
8 months ago in Db2 Utilities Suite for z/OS 0 Future consideration

Help for complex utilities

For complex utilities (I primarily mean REORG here but copy and runstats are getting there!) an addition to the OPTIONS with a new keyword SHOW or EXPLAIN or HELP. This would change the utility to be PREVIEW in all cases! And it will just output t...
about 1 year ago in Db2 Utilities Suite for z/OS 1 Future consideration