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
There is a need for various reasons for this utility to be standardized with other utilities to operate on partition level. Firstly, as per example above, it is impossible to execute standardized housekeeping syntax to run all required utilities for given partition in one execution. Combined as above is rendering an error.
Most important is fact, that vast majority and the biggest of the statistics history collection tables have and recognize partition of the object. There is a lot of applications that use the partitions over time and then switch to next partition per business period for example, business unit, time etc. As result, it is very common situation when some partitions are stable and do not need stats collection, while other parts needs to get runstats running every day as data changes, grows in it etc. With current design and lack of functionality, those stats only ever grow as it is not possible to trim old stats, for example month old for only currently used partition, not impacting historical stats collected for other partitions. Even though as mentioned, majority of biggest (column related) stats history tables are partion aware. Among others, for this reason those tables grow like crazy while they do not need to.
Do not place IBM confidential, company confidential, or personal information into any field.