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

My subscriptions: Db2 Utilities Suite for z/OS

Showing 104 of 15496

Be able to ALTER the partitioning key of a UTS PBR

Currently if the partitioning key needs to be changed this involves a UNLOAD/DROP/CREATE/LOAD which is disruptive. This needs to be changed to ALTER REORG.
almost 4 years ago in Db2 Utilities Suite for z/OS 0 Planned for future release

Idea For Limited Partition Locking for RI Related Objects

Lock just the partitions of related objects using a cascaded key structure when utilities are used to write to the database. Allows Db2 RI use to coexist with utility operation when it is impractical to lock all partitions of parents and children.
about 3 years ago in Db2 Utilities Suite for z/OS 3 Not under consideration

Materialize changes through partition rotation

We have some large tables that need to be updated from time to time. Each time a partition is rotated it is reset, so I think that could allow the table/tablespace change to be materialize. This would allow use to save the time and processing cost...
about 1 year ago in Db2 Utilities Suite for z/OS 1 Not under consideration

Enhance DSNACCOX for Index Page Splits

We use DSNACCOX to trigger reorgs för tablespaces and indexes regularly. In Db2 13 new columns are added to SYSINDEXSPACESTATS to track index page splits. If a certain number of index page splits has occured since the last reorg of the index the i...
over 1 year ago in Db2 Utilities Suite for z/OS 0 Future consideration

Eliminate Reorgs failing with S513 & IEC146I 513-04 when reorging LOBs

The cause of the S513 error is due to the DB2 reorg utility trying to write two image copies in parallel (one for BASE and one for LOB) when a BASE UTS with LOB TS is being REORG’d and the specified template for image copy datasets has the STACK Y...
about 5 years ago in Db2 Utilities Suite for z/OS 3 Not under consideration

REORG Option to set Return Code for drain failure or deadline

At present we have to manually intervene every time a REORG fails with a DRAIN FAIL or DEADLINE hit, because the job finishes with RC8. However, these scenarios are both common and expected BAU situations - so we would like to handle them automati...
almost 2 years ago in Db2 Utilities Suite for z/OS 1 Not under consideration

Parallel Unload of Partitioned Table including Lob columns is not possible

We try to unload a partioned Tablespace with a Lob column into Datasetswith spanned format.But is unload into one Datset and i do not see the following messageDSNU1201I 326 13:35:11.03 DSNUUNLD - PARTITIONS WILL BE UNLOADED IN PARALLEL We have lar...
12 months ago in Db2 Utilities Suite for z/OS 1 Not under consideration

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...
over 3 years ago in Db2 Utilities Suite for z/OS 1 Future consideration

Parameter for RECOVER utility to avoid invalidation of RTS-information

We would like a parameter (e.g. KEEP_RTS) for the RECOVER utility to indicate that real-time statistics should not be set to NULL. After a RECOVER we need to run a REBUILD of any indexes that have not been recovered, and the REBUILD utility uses R...
about 1 year ago in Db2 Utilities Suite for z/OS 1 Not under 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...
about 3 years ago in Db2 Utilities Suite for z/OS 0 Future consideration