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
Option to override LOAD utility maintaining MAXASSIGNEDVAL for identity columns in Db2 V12
Our existing process to move data from one region to another using the LOAD utility stopped working on tables with generated by default as identity key column after we upgraded to Db2 12. The new LOAD enhancement to maintain MAXASSIGNEDVAL is caus...
Allow for UNLOAD SHRLEVEL CHANGE and REORG SHRLEVEL CHANGE to be compatible wen executing on the same partition
We are running very busy environmenet with IDAA being frequently refreshed by loader with increamnts of inserted records. In addition, we are using the DB2 automated housekeeping approach with the DSNACCOX stored proc implmentation to manage and t...
Improve DSNACCOX procedure and DISPLAY command to provide correct information
This idea is a result of case TS002735466 and is being opened as recommended by IBM Support.
Currently, there is an undocumented limit of the internal buffers which are managed by DB2 and which are used when processing DISPLAY DB command. When it...
IMAGECOPY support: LOAD PART to support STACK YES like REORG PART
For the subject image copy behavior in the LOAD utility, it is as the customer describes: COPYDDN can be specified at the job / table space level but requires the RESUME or REPLACE keywords at the table space level, so this would effectively resul...
We are currently depending on vendor software that has the capability of cancelling DB2 threads when entering the switch phase of a load. This capability has saved the application team hundreds of incident tickets nightly as they perform loads daily.
"Reorg force all" should kill all existing (active or inactive) threads which belong to the object which would be reorganized
we have many tables which are changed and selected 24 hours a day - 7 days a week. So this tables need more reorgs than other not so much changed tables but it is not possible to make a reorg (force all) because there are Spufi User with autocommi...
Keyword to include all partitions in redirected recovery
It should be possible to use a keyword (e.g. PARTLEVEL ALL) on the recover statement for redirected recover. Currently the only way to do partition level recover is to ennumerate all the partitions in the recover statement. If your environment has...
Limit the number of tape drives allocated when using a TEMPLATE with STACK NO specified
In our reorg utilities against lobs using inline image copy it is required to use STACK NO, however, since we image copy to tape it causes the DB2 utility to acquire multiple tape drive units all at once for each partition of a UTS. This is an iss...
Do not place IBM confidential, company confidential, or personal information into any field.