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