CA Mainframe Application Tuner

Expand all | Collapse all

CA MAT: How do customers enable developers to use DB2 EXPLAIN ?

  • 1.  CA MAT: How do customers enable developers to use DB2 EXPLAIN ?

    Posted 04-16-2015 06:03 AM

    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:

     

    • Can developers execute EXPLAINs by themselves in any enviroment?
    • Can developers execute EXPLAINS by themselves only in specific enviroments - e.g. on development and/or test systems?
    • Do developers need to request that an EXPLAIN for a certain statement is executed by someone else?
    • Or is there any other way of doing this?

     

    Any input is welcome!

     

    Best regards

    Wolfram Muehlboeck



  • 2.  Re: CA MAT: How do customers enable developers to use DB2 EXPLAIN ?

    Posted 04-27-2015 03:36 AM

    In our company the developers can use a special-tailored web-based EXPLAIN. This is usable on all environments (production as well).



  • 3.  Re: CA MAT: How do customers enable developers to use DB2 EXPLAIN ?

    Posted 06-02-2015 08:16 AM

    Hi Robert,

     

    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.

     

    Frank Schuler

    CA Mainframe Application Tuner  Product Owner