Seminar Program

December 6, 2017

Location: Four Points by Sheraton (Formerly Crowne Plaza) Hotel , Novi Michigan

8:15 am - 9:00 am Check In/Continental Breakfast
9:00 am - 10:20 am "It’s Not Your Daddy’s DB2 ”
Speaker: Craig Mullins (Mullins Consulting)
Download "It’s Not Your Daddy’s DB2 ”
10:20 am - 10:40 am Break
10:40 am - 12:00 pm "Understanding the Rolling Four Hour Average (R4HA) for DB2 Cost Reduction ”
Speaker: Craig Mullins (Mullins Consulting)
Download "Understanding the Rolling Four Hour Average (R4HA) for DB2 Cost Reduction ”
12:00 pm - 1:00 pm Lunch - included as part of the seminar
1:00 pm - 2:15 pm "Db2 for z/OS Lies, Damn Lies, and Statistics”
Speaker: Ulf Heinrich (Segus)
Download "Db2 for z/OS Lies, Damn Lies, and Statistics”
2:15 pm - 2:30 pm Break
2:30 pm - 3:45 pm "Db2 Catching, Tuning, Trending for SQL Workloads – a resource and cost saving approach "
Speaker: Ulf Heinrich (Segus)
Download "Db2 Catching, Tuning, Trending for SQL Workloads – a resource and cost saving approach"
3:45 pm - 4:00 pm "Closing Comments "


Presentation Abstracts

Presentation #1:

Speaker: Craig Mullins (Mullins Consulting) - "It’s Not Your Daddy’s DB2 ”

DB2 for z/OS is always changing, adding more features and functionality… and discarding old stuff, too. If you are still using DB2 the same way you did 20 years ago, or even 10 years ago, you are probably doing things wrong! This presentation takes a look at how things are changing, not just with DB2, but also with IT and the industry. It is delivered in two parts: first looking at industry and DBA trends, and then looking at some of the specific changes made in the past few versions of DB2 that should impact how you use DB2.

Presentation #2:

Speaker: Craig Mullins (Mullins Consulting) – "Understanding the Rolling Four Hour Average (R4HA) for DB2 Cost Reduction”

Variable workload licensing (VWLC and AWLC) can be a powerful mechanism to reduce your mainframe software costs. But are you taking full advantage of the opportunities that exist to lower your monthly software bill? Do you know how the rolling four hour (R4HA) average impacts your bill and what you can do to lower that average? This presentation will provide education on mainframe pricing, variable workload licensing, the R4HA, and soft capping… and then focus on ways to reduce the cost by tuning DB2 resources.

Presentation #3:

Speaker: Ulf Heinrich (Segus) – "Db2 z/OS Lies, Damn Lies, and Statistics"


..Lies, damn lies, and statistics… – Benjamin Disraeli, Prime Minister of England (1868, 1874-1880)

The above line may, or may not, have been spoken well over 100 years ago, but the need for statistics and, above all else, accurate statistics is more important than ever in the Db2 world of today. Bad statistics is the number one reason for bad access paths! How could that happen; well usually bad timing is the number one reason, followed by manually updated stats and then forgotten about. There are various features and enhancements for both static and dynamic SQL delivered with Db2, but unfortunately still no common way to fallback.

This presentation explains Db2s Optimizers behavior and discusses the pros and cons of Plan Stability and Stabilized Dynamic Queries. It additionally introduces your lifesaver when your critical access path goes ballistic, a simple and solid “RUNSTATS recovery”. The basis is a complete copy of all productive required statistical data in the DB2 catalog. This should be regularly executed and the data saved away. The best way to do this is to use a Generation Gengroup which automatically stores multiple “copies” of the data.

Presentation #4:

Speaker: Ulf Heinrich (Segus) – "Db2 Catching, Tuning, Trending for SQL Workloads – a resource and cost saving approach ”


Statement level statistics introduced with Db2 10 is specifically designed to aid the DBA and Developer to understand their SQL workload. Together with your classic Db2 EXPLAIN Tools, Access Path Comparison and Protection Tools this is the fast path to finding and remediating all SQL performance problems.

Take advantage of these enhancements within Db2 11 and 12, which enables very efficient capturing of ALL SQL statistics without the overhead of classic workload monitors. It even allows the capture of all flushed SQL from both the EDM and the DSC.

Once captured, this presentation illustrates ways to analyze and store the SQL and workload metrics, building a complete workload warehouse for further analysis, such as: detailed EXPLAINs, retrieval of RTS data, aggregation of Static and Dynamic SQL (single and mixed), aggregation of SQL without schema name, and updating of all KPI’s.


Speaker Biographies

Craig Mullins (Mullins Consulting)

Craig Mullins is president & principal consultant of Mullins Consulting, Inc. He has over three decades of experience in all facets of database systems development including developing and teaching DB2 and SQL classes, systems analysis and design, database and system administration, and data analysis and modeling. He has worked with DB2 on the mainframe since Version 1 and has experience working with other database technology including Microsoft SQL Server, Oracle, Sybase and IMS.

Ulf Heinrich (Segus)
Ulf Heinrich is the Director of Solutions Delivery at SEGUS Inc & SOFTWARE ENGINEERING GmbH. He specializes in Db2 recovery issues and database maintenance, focusing on the growing requirement for cost reduction and 24×7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under real-world recovery pressure. His activities cover EMEA, as well as North America through SE’ U.S. subsidiary, SEGUS Inc.