DB2 for z/OS is a solid, a mature, and a state of the art database management system.
But despite more than 30 years of development, DB2 continues to add SQL Optimization features that help to get the most of DB2 for applications with every release. These are great news, but you have to make sure that you can get the best advantage of this for your environment.
This session describes changes in the DB2 Optimizer that provide new query access path and query optimization enhancements with query rewrite and predicate evaluation.
We will see how recent changes can help to reduce CPU and Elapsed time of complex queries in a dramatic way. We will review how the DB2 Optimizer interfaces with a DB2 Analytics Accelerator and the controls that you can use at your advantage.
We will discuss about the improved zIIP query offload and how it can help to reduce total cost of ownership and, in some cases, to improve performance.
This session is an update on what is new, what is great, and what is not so great in DB2 10 and DB2 11 in DB2 for z/OS SQL Optimization. We will discuss things that you have to know, and we will demystify the DB2 Optimizer to help you to get the most of DB2.