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
externalize generic runstats information for XML columns in SYSCAT.COLUMNS
Currently RUNSTATS does not store generic statistical results for XML columns in SYSCAT.COLUMNS - as it does for other data types -, like numnulls etc.This information in SYSCAT.COLUMNS is used for administrative, automated tasks worldwide, but ca...
ADMIN_MOVE_TABLES needs to support INDEXES on EXPRESSION
ADMIN_MOVE_TABLE (AMT) procedure fails in SWAP phase, if the table to be moved has an expression based index defined. This issue has been lifted partially, as the RENAME of the table is now supported with INDEX on EXPRESSION (IoE). But in our case...
Hi, With postreSQL, it is possible to have execution plans of slow statements automatically, without having to run EXPLAIN by hand. Wtih differents formats : text, xml, json, yaml. These plans are generated when a query exceeds a duration, the val...
Reorg blocking applications when using "allow write access"
While an "allow write acces" online reorg is running lock-wait contention can happen based on the number of rows being updated by an application. The locks for the application can escalate to lock an x lock. If this situation happens, the reorg sh...
We use a VTL for our Tape Environment. For a VTL it is recommended by IBM to use UNIT=(TAPE,,DEFER) in all Jobs. DB2 uses templates to generate JCL. In this templates it is not possible to code a DEFER parameter. Is there a way to solve this dilemma?
Currently, automatic reorgs can only be performed offline. The additional functionality we are looking for would be the ability to perform automatic in-place/online reorgs. The benefit of that is users still have full table access during the proce...
With DB2 Connect you can easily execute DDL from a remote workstation to create/modify existing z/OS DB Objects. However, when you need to delete and recreate tables while keeping the data (and ALTER ist not an option) it is necessary to open a TS...
ADMIN_MOVE_TABLE should immediately fail or at least warn when source table is ineligible for SWAP
Even after upgrading the database to Db2 V11.5 and beyond, older tables with check constraints and/or generated columns that were created before V9.7 will still cause the SWAP phase of ADMIN_MOVE_TABLE to fail with SQL0668N reason code 10. The und...
Use package collection other than NULLID for CLP and Db2 Utilities
Db2/zOS colleagues want to get rid of lock issues with rebind of packages in schema NULLID, thus the decided to have Db2/zOS release specific package collections to provide actual and rebound packages for every Db2 release to the distributed (Db2/...
Do not place IBM confidential, company confidential, or personal information into any field.