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
Hello Edward, After a second review by Db2 for z/OS Development, they have stated the original requirement is about 'WHAT IF' index. The new requirement is about 'WHAT IF NOT' index, which is a different feature. IBM catalog table such as SYSPACKDEP can be used to identify impacted packages. It sounds like the submitter is looking for better tools support instead of additional Db2 feature.
Please let me know if anything further. Thank you Edward
Hello Edward, I've asked our SME to re-evaluate this Aha! Idea and will keep you posted. Thank you.
Can you please re-evaluate this idea? This would be very beneficial when trying to evaluate if an index was dropped. Most tools are not very good at finding all SQL statements dependent upon an index, displaying the current and new access path in a readable format, then listing any performance metrics for those statements.
Thank you for your response. Db2 development has reviewed it but unfortunately, determined this idea will not be implemented.
We appreciate your input to the Db2 for z/OS development team. We also hope that you will continue to submit ideas for improvements as customer feedback is a key component to shaping the future direction of Db2 for z/OS.
Sincerely,
Db2 for z/OS Team
This is mainly needed to evaluate the new/alter index impact before the index change is actually made. Individual explains don't even cover package level scope and the customers need DS group scope - overall perceived performance benefit of the change.
Thank you for submitting this Aha Idea.
To properly evaluate this request, Db2 development would like to understand why the approach of using a stand-alone explain is not sufficient for tooling solutions to exploit virtual indexes. There are other tools that extract the SQL from packages and issue standalone explains. And many customers prefer not to use BIND EXPLAIN(ONLY) because it has the same locking implications as a traditional BIND. Also, given that an accurate representation of statistics would be required for the optimizer to effectively compete a virtual index - and RUNSTATS does not collect statistics on a virtual index, it would be valuable to understand how accurate are the statistics that are represented by tools with a virtual index. The reason for these observations is to ensure that a further investment by Db2 in virtual indexes will result in a successful evaluation by the customer.
Thank you.
Db2 for z/OS Team