CA Mainframe Application Tuner

CA Mainframe Application Tuner enhancement available - DB2 Explain on-demand

By Petr.Klomfar posted 08-13-2018 12:08 PM

  

On behalf of the CA Mainframe Application Tuner development team, for CA MAT V12  you can now obtain DB2 Explain on-demand via our maintenance stream.  Please use following link: SO04801.

 

What is this feature:

  • DB2 Explain on-demand feature brings users most relevant and accurate DB2 Explain data for explainable SQL statements during time of an analysis of a measurement, allowing better tuning opportunity identification.
  • This feature also improves on security of existing EXPLAIN process in CA Mainframe Application Tuner, utilizing DB2 EXPLAIN Authority available from DB2 V10 onward.

 

NOTE: Security enhancement requires users to provide USERID (DB2EXPID parameter) with sufficient privileges in order to utilize this functionality. 

 _____________________________________________________________________      

 

For more information about CA Mainframe Application Tuner V12, see the release notes in CA MAT V12 documentation or use following link to feature relevant technical content: DB2 EXPLAIN and DB2 EXPLAIN IMMEDIATE Functions

_____________________________________________________________________      

 

Thank you for choosing CA Mainframe Application Tuner to improve your application performance. Together with Product Manager Ekaterina Tumanova (Ekaterina.Tumanova@ca.com  ), we are always interested in your thoughts and feedback . Feel free to contact us directly.

 

Petr Klomfar (Petr.Klomfar@ca.com  )

Product Owner of CA MAT

   

0 comments
0 views