In our internal discussions about the future direction of the DB2 EXPLAIN feature the question came, how actually customers so enable their developers to use DB2 Explain when there is a performance impact caused by a SQL statement. So we would like to ask our customers about the situation at their site:
Any input is welcome!
In our company the developers can use a special-tailored web-based EXPLAIN. This is usable on all environments (production as well).
Thanks for responding. We would be very interested in learning more about the special tailored explain that you mentioned. Does this explain option contain limited explain functionality? If so, what fields within the explain are of interest to you and your team?
Thanks again for your input Robert.
CA Mainframe Application Tuner Product Owner