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 14437

Load Utility: Extension of field selection criterion option by AND conditions

The Db2 for z/OS LOAD utility offers a field selection criterion for the INTO TABLE option via WHEN( ... = ...). Since increasingly complex data structures are used application developers want to specify more complex conditions for selection of to...
almost 4 years ago in Db2 Utilities Suite for z/OS 1 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...
about 1 year ago in Db2 Utilities Suite for z/OS 1 Not under consideration

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

Replacing data in System Temporal Tables using LOAD

In most tables data can be replaced using LOAD RESUME NO REPLACE. In System Termporal Tables it cannot. We want to use LOAD REPLACE to replace the existing data instead of having to delete the current data and then load with RESUME YES. The old da...
over 5 years ago in Db2 Utilities Suite for z/OS 1 Planned for future release

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

Record all the options used on utility invocations

We have the idea to record online History to record all the options used on utility invocations.This feature would be very useful, to better control the execuctions and the history of utilities.
about 1 year ago in Db2 Utilities Suite for z/OS 0 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...
5 months ago in Db2 Utilities Suite for z/OS 1 Not under consideration

Rearchitect the colgroup processing to be more granular using multiple sorts as opposed to a single sort or more intelligently avoid the colgroup sort altogether (when possible)

Looking at the job output you sent in, we can see that there are 18 colgroups specified. Based on the current design, we have a single sort for colgroup(s). There are 184310123 rows unloaded The no. of the rows passed to the single dstats s...
about 2 years ago in Db2 Utilities Suite for z/OS 1 Not under 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...
over 4 years ago in Db2 Utilities Suite for z/OS 3 Not under consideration

Allow REORG TABLESPACE DROP_PART on PBG UTS with a DATA CAPTURE CHANGES table

We have a near 24x7x365 application with IBM InfoSphere Data Replication (IIDR) Multi-Uni Queue Replication configured between two Db2 subsystems. A Multi-Uni configuration is an IBM solution for bi-directional replication that is configured with ...
about 1 year ago in Db2 Utilities Suite for z/OS 1 Not under consideration