Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties

Download PDF

Watch recording (logged in Tridex members only)

Session title: Desperate Measure – How to Relieve the Db2 Optimizer of Its Duties

Session abstract: Optimal query access plans are essential for good data server performance, and it is the query optimizer’s job to choose the best one. However, occasionally no amount of statistics or tuning is enough to get the access plan you want. Or your application is effectively down, due to a poorly performing query, and there isn’t time to implement best practices. When these situations arise, Db2 optimization profiles and guidelines can be used to correct the access plan and get your application performing well again, quickly. Optimization profiles can specify various aspects of an access plan, can control automatic query rewriting or can control the optimizer’s plan search space. Guidelines can be specified with or without modifying your application. This presentation will show you what options are available and how to use them effectively.

Speaker biography: John is a Senior Technical Staff Member responsible for relational database query optimization on IBM’s distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator (IDAA) and Db2 Big SQL. John also works closely with customers to help them fully realize the benefits of IBM’s relational DB technology products.

Monitoring Alerts at Mastercard

Download PDF

Watch recording (logged in Tridex members only)

Session title: Monitoring Alerts at Mastercard

Session abstract: Are you monitoring the right Db2 messages and codes?  Do you have automation setup to look at MSTR and page you if a critical issue arises? Are you looking at -904 (resource unavailable) conditions to see what needs to be fixed now, vs sometime later? Do you maintain a list of all Db2 messages and codes that are critical to the success of Db2 on z/OS?

Continue reading “Monitoring Alerts at Mastercard”

Ready Player One for Db2 13!

Download PDF

Watch recording (logged in Tridex members only)

Session title: Ready Player One for Db2 13!

Session abstract: Hopefully, you haven’t missed the news – Db2 13 for z/OS has been announced! Are you ready for Db2 13? Migration details are already available and you should definitely start asking! This presentation will help you answer your initial questions about the Db2 13 migration.

Continue reading “Ready Player One for Db2 13!”

The Next Stop(s) in Db2 Pacemaker HA Solution Journey

Download PDF
Watch recording (logged in Tridex members only)

Session title: The Next Stop(s) in Db2 Pacemaker HA Solution Journey

Session abstract: This presentation focuses on the latest advancements in automated HA with Pacemaker as newly-crowned integrated cluster manager for Db2. A recap of features in V11.5.5.0, V11.5.6.0, and a glimpse into V11.5.7.0 and beyond will be provided. 

Continue reading “The Next Stop(s) in Db2 Pacemaker HA Solution Journey”

Db2 Historical Monitoring

Download PDF
Watch recording (logged in Tridex members only)

Session title: Db2 Historical Monitoring

Session abstract: Introducing db2histmon, the newest addition to the family of problem determination tools. This lightweight technology allows you to collect historical data on your database, helping especially with performance or workload problem root cause analysis even for past occurrences, greatly reducing the need to recreate the problem with additional trace techniques enabled. 

Continue reading “Db2 Historical Monitoring”

Db2 – Ready for modernized deployments and workloads

Download PDF
Watch recording (logged in Tridex members only)

Session title: Db2 – Ready for modernized deployments and workloads

Session abstract: There are two major modernization dimensions.  Modern deployments and modern workloads.  Iin this session we will discuss what Db2 is doing to help our clients modernize their deployments and to ensure Db2 is ready to handle modern workloads.  This will include Db2’s investment in multi-model, NoSQL, mixed workloads, containerization and cloud. 

Continue reading “Db2 – Ready for modernized deployments and workloads”

New Frontiers in Leveraging z/OS Real Storage for Optimal Db2 Performance

Download PDF

Watch recording (logged in Tridex members only)

Session title: New Frontiers in Leveraging z/OS Real Storage for Optimal Db2 Performance

Session abstract: z/OS LPAR real storage resources are getting larger and larger, and Db2 keeps providing new ways to leverage that resource for enhanced application performance. In this session, I’ll talk about assessing a z/OS LPAR’s real storage resource, and then I’ll explain how to optimize a Db2 buffer pool configuration, utilize thread memory for CPU savings, effectively manage EDM pool space, and more.
Continue reading “New Frontiers in Leveraging z/OS Real Storage for Optimal Db2 Performance”