Terence Purcell

Speaker Details

Company: 
IBM
Bio

Terry Purcell is a Senior Technical Staff Member with the IBM Silicon Valley Lab, where he is lead designer for the DB2 for z/OS Optimizer. Terry has 25 years of experience with DB2 in SQL Performance and optimization as a customer, consultant and DB2 developer. Terry is an IBM Master Inventor with more than 20 U.S. patents for database search technology.

Past presentation
10 April 2017
13:30 - 14:45
SQLAdria Seminar – Ljubljana 2017 Real Time Analytics Query Performance with DB2 for z/OS

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.

  • What are the types of analytics workloads?
  • Why DB2 for z/OS for real-time analytics?
  • Query patterns and performance implications
  • DB2 configuration considerations for optimal query performance

10 April 2017
11:15 - 12:30
SQLAdria Seminar – Ljubljana 2017 Runstats Challenges for Optimal Query Performance

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.

  • What are the most common RUNSTATS collection mistakes and how to avoid them?
  • How do I identify the right default statistics?
  • How do I handle statistics on tables that fluctuate dramatically in data volume?

 

In this session, we'll answer these questions and more as we discuss various runstats challenges and misconceptions.


10 April 2017
09:45 - 11:00
SQLAdria Seminar – Ljubljana 2017 Getting the best performance in DB2 11 for z/OS

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:

  • High-level overview of enhancements
  • Enhancements requiring minimal intervention
  • Migration considerations
  • Configuration to exploit performance enhancements
  • what to look out for?

07 April 2017
14:45 - 16:15
SQLAdria Seminar – Belgrade 2017 Real Time Analytics Query Performance with DB2 for z/OS

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.

  • What are the types of analytics workloads?
  • Why DB2 for z/OS for real-time analytics?
  • Query patterns and performance implications
  • DB2 configuration considerations for optimal query performance

07 April 2017
13:00 - 14:30
SQLAdria Seminar – Belgrade 2017 Runstats Challenges for Optimal Query Performance

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.

  • What are the most common RUNSTATS collection mistakes and how to avoid them?
  • How do I identify the right default statistics?
  • How do I handle statistics on tables that fluctuate dramatically in data volume?

 

In this session, we'll answer these questions and more as we discuss various runstats challenges and misconceptions.


07 April 2017
10:30 - 12:00
SQLAdria Seminar – Belgrade 2017 Getting the best performance in DB2 11 for z/OS

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:

  • High-level overview of enhancements
  • Enhancements requiring minimal intervention
  • Migration considerations
  • Configuration to exploit performance enhancements
  • what to look out for?
     

 

sqladria

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.

Follow us

facebook
linkid
twitter

 

Events in 2018

Ljubljana - 9th & 10th April 2018
Belgrade - 12th April 2018
Šibenik - 10th - 14th June 2018
Zagreb - 18th September 2018
Opatija - 29th & 30th November 2018