What are the types of analytics workloads? And where should they reside? Analysing your DB2 for z/OS operational data in real-time had obvious appeal to your business, but what are the query optimization and design implications? Hear from DB2 development about what they have learned working with customers to ensure successful query performance with real time analytics on DB2 for z/OS.
In DB2 development, we see many customers that are NOT following RUNSTATS collection "Best Practices". But what are those best practices? The largest contributor to poor query performance is insufficient or misleading RUNSTATS. Improving the availability of pertinent and accurate statistics is a huge opportunity for customers to improve DB2 performance and reduce instability of access paths.
In this session, we'll answer these questions and more as we discuss various runstats challenges and misconceptions.
As more customers exploit DB2 11 for z/OS, we can share the lessons learned and focus on the most beneficial of the DB2 11 features and how best to exploit them for improved query performance. This presentation includes:
European SQLAdria Seminar – Vodice 2024
SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.
8 reasons to come Speakers Events Contact
VODICE - 10th - 13th June 2024