Stream: Virtual Room 5
Time: 10:00 - 10:45
In this presentation, I will share insights into DB2 performance measurements using data from SMF 72, 30, 100, and 101 records. DB2 is one of the key areas to monitor in mainframe environments, especially when focusing on CPU usage and the performance of each DB2 subsystem.
We will explore how DB2 plans and packages help provide visibility into the interactions between DB2 and various types of workloads, such as BATCH jobs, CICS transactions, and IMS transactions. Understanding these interactions is critical for identifying performance bottlenecks and optimizing resource usage.
Particularly the DB2 Distributed workloads, which are often among the highest consumers of CPU resources across many customer environments—a trend I’ve observed repeatedly. This session will outline practical performance metrics and guide how to analyze and act on them.
There is currently no attachment for Unlocking DB2 Performance: Key Metrics from SMF Data
Mary, a senior performance consultant at SMTData since 2018, who embarked on her journey as a mainframe capacity & performance analyst with IBM India back in 2012. Currently, she's dedicated to supporting multiple clients across the Nordic region, specializing in mainframe optimization projects and z/OS DISK & TAPE capacity reporting. Mary's expertise lies in conducting thorough health checks on various mainframe configurations, paving the way for optimized setups and reduced capacity/software licensing charges. She's a trusted advisor for large banks, assisting in the development of comprehensive capacity plans crucial for budgeting and forecasting. With extensive proficiency in SAS/MXG and SMT ITBI Tool, Mary is committed to driving efficiency and maximizing performance in the mainframe environment.
Click here to give some Feedback so we can make it even better next year!