IDUG EMEA 2024

In today's modern applications, workload is increasingly shifting from traditional CICS or IMS transactions to Java workload. As a result, analyzing dynamic queries has become more important than ever before. 
In this presentation, I will demonstrate how to systematically analyze dynamic queries using the Global Dynamic Statement Cache, and how to identify queries that require immediate attention. We will develop a tool that allows SQL developers to analyze dynamic queries in their shop from day one after the conference. This tool is designed to be easily accessible and user-friendly, without requiring access to the mainframe. With it, developers can answer typical questions such as "Which queries performed better or worse within the last 30 days?", "Which of my queries were running at a given time and how did they perform?", and "Which of my queries are getting slower over time?" in a self-service mode. Additionally, we will explore how to translate query tuning results to cash savings, demonstrating the financial benefits of query optimization. By the end of this presentation, you will have a clear understanding of how to uncover and monetize hidden insights by analyzing the Global Dynamic Statement Cache.