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
Preserve table creation timestamp after reorg-finsished using admin_move_table procedure (online table move)
Following Knowledge Center, https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.perf.doc/doc/c0024850.htmlwe perform table reorg using admin_move_table . The issue is, after run admin_move_table command, the original...
Adjust F2 criteria for AUTO_REORG on adaptive compressed tables
AUTO_REORG uses reorgchk output, like F2 criteria. The problem is that F2 does not take into account pagelevel dictionary. The size can be important, like 5K out of a 16K page, and therefore F2 criteria is always below the 70%... and tables will k...
Reduce size of LOAD COPY dataset for tables with LOBs and XML
A LOAD COPY where the table being acted on has one or more LOB columns is much larger than the original data / final table size / post load backup. From investigation it is based on the pagesize and extentsize of the underlying tablespace. This pr...
Allow DB2 to export data from a base table in normal state even if index tablespace is in Rollforward pending state
DB2 should allow exporting data from a base table (tablespace) in normal state even if the index tablespace is in Rollforward pending state (or other abnormal state). This would allow us to rebuilt the table without losing data.DB2 should also alt...
using db2move to load data in ab HADR enabled database breack the hadr cluster as this command don't support any option to force the use of COPY YES option during load operation., that without any warning or confirmation message.As a consequence, ...
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...
Db2 load ALLOW READ ACCESS support for column organized table
Currently, if a db2 load is happening on a column organized table, users are NOT able to read the data from same table until the load is finished. It's inconvenience for the customer and its users in their daily operation. Thus, the customer wants...
Improve performance of retrieving large result sets
Performance of Db2 client/server communications in a network environment needs to be significantly increased in cases where large amount of data (100s of MB or more) are being moved between Db2 server and remote client. This needs to be provided n...
Do not place IBM confidential, company confidential, or personal information into any field.