Objectives:
The presentation describes how Datenzentrale uses a powerful, comprehensive DB2 for z/OS application performance analysis tool to optimize static and dynamic SQL.
Outline:
Monitor every SQL statement that is processed by our DB2 system(s), 24 hours a day
Collect static and dynamic SQL
Identifyresource-intensive application programs and SQL statements
Evaluate application performance at multiple levels of granularity
Show SQL exceptions and error conditions
Provide real-time and historical performance data
Minimize development costs by identifying poorly performing SQL during the application development cycle
Full Abstract:
n/a