MDUG Seminar

Date: Thursday, March 11, 2010

Location: The Crowne Plaza Hotel, Novi Michigan

Seminar Program

Presentation Abstracts

This presentation takes a look at table and index design strategies we have practiced over the years and see how they are impacted by DB2 9. We also look at how we can move forward with current designs and also are able to take advantage of the new features.

In this presentation will look at ways reducing the number of calls you make to DB2 z/OS via exploitation of V8/V9 SQL features for SQL call reduction. The quantity of SQL calls made can sometimes be more detrimental to performance than poor quality SQL. Don’t be fooled by low response times per statement and high buffer pool hit ratios! So, here we’ll look at ways of using V8 and V9 SQL and application features to help reduce the number of trips we make across the address spaces in DB2 z/OS.

This presentation looks at design, optimization, and challenges faced in large scale data warehouses with complex batch schedules. It's aimed at both DBA and developers of batch jobs. This presentation will also give an overview the Infosphere SQL Warehousing tool.

Table partitioning simplifies the management and improves the performance of rolling in and rolling out data. This presentation digs deep into how range partitioning is implemented, design considerations, and gotchas. Improvements in 9.5 and 9.7 will also be analyzed along with reflections on existing projects currently on their way to implement this feature.

 

Speaker Biographies

Susan Lawson (Yevich, Lawson, & Associates)

Susan Lawson is an internationally recognized consultant and lecturer with a strong background in system and database administration. She currently works with several large clients to help development, implement and tune some of the world’s largest and most complex DB2 databases and applications. She also performs Performance Audits for many clients to help reduce costs through proper performance tuning. Her other activities have included authoring articles, presenting at user group meetings, and authoring white papers. She is an IBM GOLD Consultant for DB2 and z/Series, and has authored the IBM ‘DB2 for z/OS V8 DBA Certification Guide’, DB2 for z/OS V7 Application Programming Certification Guide’ and ‘DB2 9 for z/OS DBA Certification Guide’. She is also the co-author of several DB2 books including ‘DB2 High Performance Design and Tuning’ and ‘DB2 Answers’.

Rob Williams (Hubel Consulting)

Rob Williams is an Advanced Certified DB2 DBA who has been working with DB2 on LUW for the last 9 years. For the last year and a half he has been working as a primary production engineer for a large scale (42 Terabyte) data warehouse using data partitioning feature for one of the top 5 banks in Canada. He is also the webmaster of idug.org and currently nominated as an IBM Data Champion. Rob has presented at a number of DB2 local and international user group meetings and is very well-respected in the community. Rob works for One Point Solutions, a Michigan-based company focused on IBM database technology. He has worked for customers such as Metrosplash, Bekins, Pokerstars, State of Vermont, and Seabourne Cruises.