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
Reorg Utility Progress data is missing in db2 list utilities and db2 list utilities show detail command
The db2 list utilties and db2 list utilities show detail command will not display the Reorg utility progress. 1) The command will display the Runstats progress details for the table 2) The command will display the Load progress details for the tab...
Reduce Time Required for Online(Inplace) Reorg for huge tables
1) Inplace reorg will take time more for the tables with huge data say for example 1 TB 2) To Reduce the time for this we want to avoid full table scan hence we need to look in portions of the data in a table where it is getting fragmented 3) Henc...
Introduce a new parameter to the export utility to be able to export data from a table that is in a backup image.This functionality is especially useful for data extraction without touching/impacting the source system
NONBLOCKED option for event monitors to prevent them from blocking user services
Db2 locking event monitor may block deadlocked applications from proceeding for a purpose of making event monitors work under some circumstances. (Reported on case TS007885986) Since it could damage user's business services severely, user should b...
Turn on reclaimable storage without dropping/recreating the tablespaces
After a migration from db2 9.5 to 10.1, several days passed, and we reached the maximum size of a DMS tablespace of 4K. We moved one table to a different tablespace, but still noticed that the free pages were equal to 0. We tried to execute the al...
Getting the Accessplans at the Routine level for the Database LUW
Db2 performance issues in one of the major area to look for, Whenever there is performance issue in the database, one of the major point we look is for the queries how they are behaving in the database.
Db2 LUW provides lot of options to get the ...
Many customers want to REORG their tables quickly and efficiently. The classic REORG is by far the fastest option but puts the table in read only mode. Inplace reorg allows write access but is much slower and not suitable for tables that have a hi...
Column-organized tables are currently not supported for table partitioning (e.g. PARTITION BY RANGE)..At the same time, table partitioning is used by many data warehouse customers to speed up ETL activities - e.g.:(a) load new data into a separate...
Do not place IBM confidential, company confidential, or personal information into any field.