DB2 z/OS

Understanding Query Transformation in DB2 for z/OS

There is always a lot of talk about the DB2 optimizer and what is the best access path for a particular query. While this is of course important it is also important to know that the optimizer is only part of the story. When a query is submitted one of the first thing that happens is that it goes through query transformation. In this part of the process DB2 interprets the submitted SQL, and rewrites it. Views and UDFs are merged with the query, subqueries possibly transformed to joins, table expressions merged, and much more.

Time Travel Queries and Temporal Data Storage - What you need to know!

Temporal tables and time travel queries are a very popular feature of DB2 10 and z/OS and DB2 10 for LUW. They are one of the most powerful automated database features to come out in some time. This session will go into depth about the things you need to understand and prepare for before using temporal tables. This will include proper table, index, and table space design and configuration, as well as the ongoing management of these objects.

"Explain Yourself and Improve DB2 Performance "

Are you getting the most out of EXPLAIN, and are you doing everything you can to help the DB2 optimizer do its job?  This presentation helps you answer these questions.
IBM has made many enhancements to the EXPLAIN command and parts of DB2 around it, in DB2 10 and 11.  This presentation goes into some of these changes and how you can take advantage of them to help the DB2 optimizer and get the best performance out of your DB2 applications.

Stop Wasting Time with Utilities

What is the ideal frequency of execution for most utilities?  We will start by discussing the answer to that question, and then move on to how to implement a strategy to achieve it.  The focus will be on Reorg, Copy, and Runstats, but we will glance at Unload and Load also.  Hint: the answer is automation.

DB2 for zOS Optimizer

DB2 Data Sharing Deep Dive

Subscribe to RSS - DB2 z/OS