Performance Management Assistant Enhancements › Adoption of SQL Declare Statement Information

Adoption of SQL Declare Statement Information

This enhancement increases the usability of Performance Management Assistant in DB2 in two ways:

• Performance Management Assistant collects DB2 performance information from CA Mainframe Application Tuner measurement results. This information includes consumption details like cpu time of executed SQL statements, with the SQL statement text coming from the SQL STATEMENTS sections of the measurement list.
• Performance Management Assistant now extracts the SQL DECLARE text delivered from CA Mainframe Application Tuner and includes the text in the SQL information areas, thus giving you a more complete set of SQL information. This increases your productivity when analyzing and tuning your application.