IDUG Meeting featuring Robert Catterall, Chris Eaton, Mary Beth Jeffords and Paul Turpin

SIRDUG Meeting March 3rd, 2011

SIRDUG is very pleased to announce that the first 2011 SIRDUG meeting on March 3rd, will feature Chris Eaton and Robert Catterall from IBM. Robert Catterall will give us a preview of his 2011 North American IDUG conference presentation, "DB2 for z/OS Stored Procedures - Trends and Technology". Robert will also present "SQL enhancements in DB2 9 and 10 for z/OS".

Chris Eaton will be presenting Administrative Views and High Availability topics, including HADR and pureScale.

Chris Eaton and Robert Catterall have both won multiple IDUG Best Speaker awards.

Mary Beth Jeffords will be presenting "Cost Control Methods for DB2 for z/OS workloads". Paul Turpin will be presenting "Index Friend or Foe?"

The IDUG North America Conference 2011 will be in Anaheim, California, May 2nd through 6th. If you are not able to attend this year's IDUG North America Conference, this is your opportunity to catch a piece of the action.

Meeting Details

WHEN? Thursday, March 3, 2011

WHERE? Lowes Corporate Office (Mooresville, NC) See directions below

COST? $20 cash or check, in advance or at the door.
We do not accept credit cards. We are working on a way to accept Paypal and credit cards, so stay tuned for upcoming announcements.

Tentative Meeting Agenda

Meeting Agenda 

 8:00 -  8:50 - Registration - Coffee, Danish, and Networking
 8:50 -  9:00 - SIRDUG announcements and speaker introductions 
 9:00 - 10:15 - Mary Beth Jeffords -  (z/OS focus) - Cost Control Methods for DB2 for Z/OS workloads
 9:00 - 10:15 - Paul Turpin        -  (LUW focus) - Index Friend or Foe
10:15 - 10:30 - Mid-Morning Break
10:30 - 12:00 - Chris Eaton - Admin views  (DB2 for LUW)
10:30 - 12:00 - Robert Catterall - TBD  (DB2 for z/OS)
12:00 - 1:15  - Lunch
 1:15 - 3:00  - Speaker TBD - SQL improvements in V9 and V9 ie OLAP ranking   (DB2 for z/OS)
 1:15 - 3:00  - Chris Eaton - technical review of HADR best practices  (DB2 LUW (including zLinux))
                how does pureScale compare with Oracle technically
 2:00 - 2:15  - Mid-Afternoon Break
 3:30 -  3:45 - SIRDUG business , Adjourn

We are still working on the exact agenda, so what you see may change 
a bit.


Pre-registration must be completed by Midnight, Monday, February 28th. We need to provide a list of attendees to Lowes security, so we need everyone to pre-register. Please feel free to invite others from your company (just make sure they pre-register as well). If you know others in your company who are interested in attending future SIRDUG events, please encourage them to become members of our distribution list (we just need their names, email addresses and phone numbers).

Registration Note
SIRDUG will be calling or emailing a confirmation for each person who pre-registers by the deadline. If you have pre-registered and have not received a confirmation by the day after the deadline, please notify us as your registration may not have been received.

If you have not pre-registered by the deadline, you may pre-register after the deadline or register at the door, but the availability of presentation handouts and lunch can not be guaranteed and confirmations will not be sent.

Directions to Lowes facility:

Get off at Exit 31 on I-77, which is Mooresville, NC> Go to 1000 Lowes Blvd

From a security and guest registration standpoint, all SIRDUG attendees should enter the campus via the entrance from I-77 Exit 31.

The address for GPS should be 1000 Lowe's Blvd., Mooresville, NC 27117.

Directions from Charlotte
Go north on I-77 to Exit 31 Langtree Road.
Take a right at the top of the exit and go about 3/10 mile and make a slight left turn onto T Lane. Follow T Lane to the security guard building. Give them your name and that you are here for SIRDUG, and the security guard will direct you from there to the NB parking lot.

Directions from Statesville
Go south on I-77 to Exit 31 Langtree Road.
Take a left at the top of the exit and go about 6/10 mile and make a slight left turn onto T Lane. Follow T Lane to the security guard building. Give them your name and that you are here for SIRDUG, and the security guard will direct you from there to the NB parking lot.

After parking in the NB parking lot, go to the ground floor lobby entrance of the NB office building. The registration tables for SIRDUG will located on the left side of the NB lobby. We will escort groups of SIRDUG attendees to the NB1210 meeting, as they check in.

Presentations for Download

To download Robert Catterall's "DB2 V9 and V10 SQL Enhancements"
click here

To download Robert Catterall's "NA2011 Stored Procs" click here

To download Chris Eaton's "HADR and PureScale" click here

To download Chris Eaton's "Admin Views" click here

To download Paul Turpin's "Index Friend or Foe" click here

To download Mary Beth Jefford's "Cost Control Methods for DB2 for Z/OS workloads" click here

Chris Eaton's Biography

Chris Eaton is Technical Evangelist for DB2 primarily focused on planning and strategy for DB2. Chris has been working with DB2 on the Linux, UNIX, Windows platform for over 18 years. From customer support to development manager, to Externals Architect and as Product Manager for DB2, Chris has spent his career listening to customers and working to make DB2 a better product. Chris is the author of IBM DB2 9 New Features, DB2 9.7 New Features, and The High Availability Guide for DB2 and has one of the most popular blogs about DB2 on IT Toolbox at

Title: ""

Robert Catterall's Biography

Robert Catterall is an IBM DB2 specialist. He started his IT career with IBM in 1982, and worked throughout the 1990s with the Company's DB2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist at CheckFree Corporation (now part of FiServ). After working for three years as an independent DB2 consultant, he rejoined IBM in 2010. Robert is a past President of the International DB2 Users Group, a member of the IDUG Speakers Hall of Fame, and was one of IBM's inaugural Information Champions. He writes the "Data Architect" column that appears in each issue of IBM Data Management Magazine.

Paul Turpin's Biography

Paul Turpin is a senior database administrator for a software development company specializing in financial applications. He specializes in DB2 for LUW on large systems. He enjoys exploring new features and functionality in DB2. He has spoken at IDUG North America, IDUG Europe, SHARE, IBM’s Information on Demand conference, and several RUGs. Paul currently serves as past chairperson on the IDUG North America Conference Planning Committee. He was one of IBM's inaugural Information Champions.

Title: "Index Friend or Foe"

Indexes are touted as one of the best performance inventions ever. Many times they are your friend, but they can also be your enemy. This presentation looks at how you can check the health of your indexes with reorgchk and catalog queries. For those of you on pre-DB2 9.7 release, we will look at how to use db2pd tcbstats plus catalog queries to collect index usage into a DB2 table. We will also look at how this information can be connected to explain information. For those of you on DB2 9.7, we will look at some new index information in the catalog including index usage and index statistics.
Objective 1: Why indexes are good / why indexes are bad
Objective 2: How to use reorgchk and catalog queries to examine index health
Objective 3: How to use db2pd to collect index usage information and put it into a DB2 table
Objective 4: Connect index usage information with explain information
Objective 5: DB2 9.7 index catalog information examined

Mary Beth Jeffords' Biography

Mary Beth Jeffords is currently the systems DBA for the State of South Carolina Budget and Control Board, Division of Information Technology. This is a central state government agency that provides computing services to other state agencies. She has 12 years of experience working with DB2 for z/OS and prior to that worked with a network DBMS (CA-IDMS) as a programmer analyst, DBA, and systems DBA for over 14 years and has previously been a presenter at CA-World. .During the past ten years, she has gained extensive experience working with a large-scale distributed application using DB2 for z/OS as the database server. She also has experience with DB2 Connect and several third-party tools. She also does volunteer work maintaining a Microsoft Access database for the Friends of Congaree Swamp.

Title: "Cost Control Methods for DB2 for z/OS Workloads"

Cost has increasingly become an issue for applications on any platform, especially the zSeries. This presentation will cover ways to control the costs of both distributed and traditional workloads using DB2 for z/OS as the database server, such as software pricing options, LPAR configuration, zIIP/zAAP, zNALC, performance and tuning methods and tools, and more that enable DB2 for z/OS to compete with LUW as a database server for distributed workloads.

Objective 1: Understand the role DBAs now need to play in understanding and controlling costs in their organizations.
Objective 2: Learn about how various software pricing options, hardware options, and LPAR configuration can have a huge impact on the cost of DB2 for z/OS applications and how to gain control.
Objective 3: Learn about options that can minimize the cost for distributed workloads and things to watch out for when developing and implementing distributed applicaitons using DB2 for z/OS as the database server.
Objective 4: Learn about tools and techniques that can maximize performance and minimize resource utilization.
Objective 5: Learn about user experiences with application cost estimation, platform migrations, DB2 subsystem cloning, IBM and third-party tools, and more.

SIRDUG Home Page

Last Update: March 4, 2011

Copyright © 2011 SIRDUG Inc. All rights reserved.