This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. 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 an idea.
Get feedback from the IBM team and other customers to refine your idea.
Follow the idea through the IBM Ideas process.
Specific links you will want to bookmark for future use
Visual explain is a vital tool to get the information about how a SQL statement is processed and to understand the nature of SQL queries. However, it can be quite complicated to oververview complicated queries and the graph can be quite chaotic.
More and more tooling is leaning towards the IBM i services to interact with the core API's and other nice features.
It will be appreciated if IBM would consider to provide a IBM i service to pull out the same info available in "Visual explain " as a IBM i service, so it can be incorporated in application analysis. ie ad hoc or in DevOps pipelines.
select * from table( qsys2.sql_explain ( sql_statement=> 'select * from qsys2.user_info' ) );
This will produce a result set that explains all the details what the query (in this case the view) really does. One row for each node in the "Visual explain graph"
Preferable with a "parent" node having the top level parent = NULL and you could do a recursive query from the top down to each leaves in the tree.
Do not place IBM confidential, company confidential, or personal information into any field.