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

Allow creation of table with column definition WITH DEFAULT CURRENT DATE - x DAYS

We have a requirement to create some new tables, where we load a CSV file in every day. The CSV file contains information from the IMS Performance Analyzer Tool, and is always 2 days behind the current date. It would be nice to have the option to ...
3 months ago in Db2 Utilities Suite for z/OS 1 Under review

Non-Sorting, online way to encrypt Db2 Datasets

Currently to encrypt Db2 datasets in an online fashion we use the REORG SHRLEVEL CHANGE. For large tablespaces, or well-organized tablespaces, this incurs the cost of reorganizing (sorting mostly) that we would rather not have just to encrypt. We ...
12 months ago in Db2 Utilities Suite for z/OS 1 Not under consideration

zSort information in Utilities History

When running some utilities Db2 can choose to use zSort. In Utilities History (SYSIBM.SYSUTILITIES). there is a column SORTNAME where you can see if DSSORT or DB2SORT has been used. The information if zSort has been used or not is vital as it can ...
about 1 year ago in Db2 Utilities Suite for z/OS 0 Future 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...
almost 3 years ago in Db2 Utilities Suite for z/OS 1 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

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

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

SYSPUNCH - be able to suppress NUMRECS

Certain processes use load cards created from unload utility using LIMIT 0. This creates NUMRECS 0 that needs to be removed prior to the LOAD.
over 3 years ago in Db2 Utilities Suite for z/OS 0 Not under consideration

Reorg Rebalance for partitions with different DSSIZE

Reorg Rebalance tries to set new partition boundaries so that rows are evenly distributed across the reorganized partitions. It does not consider that the partitions can have different values for DSSIZE. So the functionality of Reorg Rebalance sho...
3 months ago in Db2 Utilities Suite for z/OS 1 Not under consideration

LOAD - Add ability to bypass REPORT phase when duplicates are present

Processing a TS with a lot of duplicates. We never look at the data from the REPORT phase. Also it takes a very long time to produce. Would like the ability to have a keyword to bypass this
4 months ago in Db2 Utilities Suite for z/OS 0 Future consideration