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 updateson 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,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
Modify redirected recovery to eliminate the need for repair catalog of target
Modify redirected recovery to eliminate the need for repair catalog of target The relatively new Db2 utility enhancement of redirected recovery is very useful When recovering a target tablespace from another tablespace, the IBM documentation is ve...
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...
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...
Enhance CHECK DATA utility: 1) to avoid SCANTAB and SORT when “SINGLE PARTITION IS SPECIFIED”; 2) to add PART range and parallelism option.
Currently Db2 does not provide either a parallelism option or PART range option for running CHECK DATA utility. Instead, as of Db2 V12, only ‘PART integer’ option is provided that repeating TABLESPACE database-name.table-space-name PART integer st...
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 ...
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 ...
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...
DSNZPARM to disable MODIFY option DELETEDS - compliance issue
It should be possible to disable the option for deleting physical datasets along with modifying recovery information for a tablespace, as in MODIFY RECOVERY TABLESPACE XXXXXX.XXXXXXXX
DSNUM ALL DELETE AGE(32) DELETEDS There is increasingly more ...
Do not place IBM confidential, company confidential, or personal information into any field.