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 36

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

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

include num of Rows discarded in a REORG DISCARD utility execution

It can/will be VERY useful to Db2 zOS users if the Object level utilities history will record the number of rows discarded in a REORG DISCARD utility execution. As documented I understand that the object level information will be available in v13 ...
about 1 year ago in Db2 Utilities Suite for z/OS 1 Future consideration

SYSIBM.SYSUTILITIES should have a column containing the full text of the Db2 utility

SYSIBM.SYSUTILITIES should have a column containing the full text of the Db2 utility that was executed. This allows the DBAs or sysprogs to see exactly what was executed for problem and other analysis. For example if someone has run a utility that...
over 1 year ago in Db2 Utilities Suite for z/OS 1 Future consideration

Alter PBG to PBR should be possible for tables with LOBs

The statement ALTER PARTITIONING TO PARTITION BY RANGE should be applicable for tables with LOB's. One of the main drivers for us to convert from PBG's to PBR's is that our LOB tablespaces are growing very large. As the base tables usually only co...
over 2 years ago in Db2 Utilities Suite for z/OS 0 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

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 ...
11 months ago in Db2 Utilities Suite for z/OS 1 Future 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 ...
almost 2 years 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...
over 3 years ago in Db2 Utilities Suite for z/OS 1 Future 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
about 1 year ago in Db2 Utilities Suite for z/OS 0 Future consideration