IDUG EMEA

Just because SQL provides the right data back to a program for processing does not mean it’s “Good SQL.”  Also, SQL can change from bad to good as your systems mature and tables grow from small to huge, but there are ways to monitor production SQL to identify those programs that would benefit the most from tuning. Join us as we explore ways to manage SQL quality and performance. Learn how to shift left quality and performance SQL issues with BMC AMI SQL Performance for Db2. Quickly identify and tune your most resource-intensive SQL statements at each stage of development to reduce CPU consumption while improving performance and availability. Also learn about best practices for developing SQL, using graphical representation of explain data to estimate cost of the query, and testing SQL in a high-volume environment to understand performance optimization opportunities, and how to enforce SQL coding standards to adhere to custom site rules leveraging a modern mainframe DevOps process.