IBM Data and AI Ideas Portal for Customers
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 updates on 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
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.
IBM Employees should enter Ideas at https://ideas.ibm.com
Thank you for the additional information, Brian. I notified our SME of your update.
To be clear. The two obvious missing statistics are :
INDEX_COMP_PAGESAVE – “percentage Reduction in Index Leaf Page Space”
INDEX_COMP_BP_UNUSED – “percentage of Bufferpool Space that is unused to ensure keys fit into compressed buffers”
These new column values will tell us the effectiveness for the compressed index for the current bufferpool.
As a bonus. You should consider adding SOME new cols that essentially give us the same ESTIMATED benefit value that we get from DSN1COMP. This would save us from having to run DSN1COMP. And I believe it is “easy” for you to do this calculation while doing REORG INDEX or REBUILD INDEX or LOAD REPLACE … etc.
I think this is low cost for you and it would make it obvious when we should compress some indexes!
Remember, some people in the world are still measured by how much space they allocate. I know index compression is all about space allocation reduction. Index compression is not really for performance… but still reducing space is a measure and I work toward measures
INDEX_COMP_EST_PAGESAV_BP4K
INDEX_COMP_EST_BP_UNUSED_BP4K
INDEX_COMP_EST_PAGESAV_BP8K
INDEX_COMP_EST_BP_UNUSED_BP8K
INDEX_COMP_EST_PAGESAV_BP32K
INDEX_COMP_EST_BP_UNUSED_BP32K
Thank you for your comment. We're checking with the development team and will provide an update here when we have more information.
Sincerely,
Db2 for z/OS Team
Any update or progress on this request?
I ran into situation today where I'm trying to implement index compression and have little insight into how it is performing. Only thing I can think to do is check the number of tracks consumed before and after. The tables I am working with eventually in PROD are 15 and 11.6 billion rows. Each table has 2 indexes and I estimate approximately 5,359 gigs. I'd really like to know the results before and after to ensure compression is worthwhile from a storage savings perspective.
Brian, Thank you for your inquiry. I've asked the SME for an update as to the plans for this idea, and will post the update here as soon as it is received.
Sincerely,
The Db2 for z/OS Team
The following has been under consideration for 18 months . The fact that it is STILL under consideration provides hope that it might be done. I cannot imagine the effort for IBM is huge. I think the benefit is something. One could argue that it is not worth the effort…. But I would like to see it done. It is the right thing to do.
Hello Brian, We are reconsidering this Aha idea and therefore placing it in Future Consideration state.
does IBM have any feedback on the status of this idea? I feel it is important and I would really like to see it implemented? It is a logical and obvious extension to index compression... why is it not done already?
What do you think?