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 89 of 14439

No Implicit Runstats when running Reorg that materializes pending DDL

When a REORG is run to materialize a pending DDL change, the REORG enforces an inline statistics (RUNSTATS) even though no statistics keywork is added to the REORG statement/card. it defaults to TABLE(ALL) INDEX(ALL). This obviously can impact acc...
almost 3 years ago in Db2 Utilities Suite for z/OS 1 Future consideration

REORG needs to be enhanced to separate processing for partitions having dictionaries and no dictionaries

Using LISTDEF there are 4 partitions selected to be reorged. Row length 2284 bytes KEEPDICTIONARY used PART 5 - CARDF 50M, dictionary PART 6 - CARDF 60M, dictionary PART 11 - CARDF 110M, dictionary PART 80 - CARDF 150,000, no dictionary Since PART...
over 2 years ago in Db2 Utilities Suite for z/OS 0 Future consideration

Load into util next to a reorg

As discussed in IDUG EMEA 2023 Praag, i gave a presentation about reorg a big table that took 8 days. If the table cant be accessed, a recover to that point would take 6 hours. So table created at front that can have the data already loaded until ...
5 months ago in Db2 Utilities Suite for z/OS 1 Not under consideration

Add "EXCEPTION" parameter to CHECK INDEX to discontinue processing after N disrepancies

Sometimes when you run CHECK INDEX you encounter a huge number of discrepancies so much so that the utility keeps running and running and producing an excessive amount of output -messages regarding the details of the discrepancies. In some cases y...
11 months ago in Db2 Utilities Suite for z/OS 0 Future consideration

Track REORGs with SHRLEVEL NONE

We do not want anyone to run a REORG with SHRLEVEL NONE. If they do we might end up with big problems, especially if it abends or we have to terminate it. We see no reason to use SHRLEVEL NONE with REORG any more unless it is a huge tables that ca...
6 months ago in Db2 Utilities Suite for z/OS 0 Future consideration

When LOAD Utility fails due to claimers, locks in the object, this should be reported as with REORG and switch phase

When LOAD Utility fails due to claimers, locks in the object, this should be reported as with REORG and switch phase
over 2 years ago in Db2 Utilities Suite for z/OS 0 Future consideration

allow the ability to generate REPLACE instead of RESUME YES

Sometimes you want to unload/load with REPLACE instead of RESUME YES. Need the unload utility able to generate LOAD REPLACE.
over 3 years ago in Db2 Utilities Suite for z/OS 0 Not under consideration

Allow TEMPLATE switching for more data sets in REORG and LOAD

Allow TEMPLATE switching in the REORG TABLESPACE, REORG INDEX and LOAD utilities for the necessary work files. For example, small objects may only require data sets with DSNTYPE BASIC and large objects may require data sets with DSNTYPE EXTREQ or ...
over 2 years ago in Db2 Utilities Suite for z/OS 1 Not under consideration

Provide capability for SLB Utility to timeout when HSM does not respond to backup request.

Currently the SLB utility sits in a wait state until ackowledgement of the backup request is returned from HSM. During this time a lock SYS_PITR is is held that prevents any DFDSS activity by Db2. This can lead to Db2 thread failures and data inco...
about 2 years ago in Db2 Utilities Suite for z/OS 1 Future consideration

QUIESCE utility: Add the functionality described in the REORG drain-spec to the QUIESCE utility

Currently the QUIESCE utility has no capability to mitigate its impact on end user application workloads like the REORG utility does via its drain-spec functionality.
almost 3 years ago in Db2 Utilities Suite for z/OS 0 Future consideration