SIRDUG meeting featuring James Surber and Sheryl M. Larsen

SIRDUG Meeting April 8th, 2005

Featuring: James Surber and Sheryl M. Larsen
Has your maintenance window shrunk until you need a magnifying glass to find it? Are your queries choosing The Access Path Less Taken . . . and never coming back? Then we have two speakers that YOU need to hear. James Surber and Sheryl Larsen will share tips and techniques to improve the availability and performance of your DB2 system, whether you work on a mainframe, an LUW platform, or both.

In the morning, James Surber will show us database design techniques that can help us achieve that elusive 24x7 availability. He'll also share approaches that can reduce the duration of unavoidable outages, planned and unplanned. Come hear the presentation that won James the Best Speaker award at IDUG 2003 -- Europe!

In the afternoon, Sheryl Larsen will address the topic for which she is best known: SQL that PERFORMS. If someone in your organization (not you, of course!) has written SQL that is crawling its way through the system, learn how to make it sprint in Sheryl's presentation of Extreme SQL Tuning for Performance.

This year's IDUG North American Conference will be in Denver, Colorado on May 22 through 26th. If you are considering attending this year's IDUG NA conference, make sure you scroll to the bottom of this announcement for some exciting discount information!

Meeting Details

WHEN? Friday, April 8, 2005

WHERE? IBM Harris Blvd facility

COST? $25 cash or check, in advance or at the door.
We do not accept credit cards.

Meeting Agenda

 8:00 -  9:00 - Registration - Coffee, Danish, and Networking
 9:00 - 10:15 - James Surber
10:15 - 10:35 - Mid-Morning Break
10:35 - 11:50 - James Surber
11:50 -  1:00 - Lunch
 1:00 -  2:00 - Sheryl Larsen "Extreme SQL Tuning for Performance"
 2:00 -  2:20 - Mid-Afternoon Break  and chat with speakers
 2:20 -  3:20 - Sheryl Larsen "Extreme SQL Tuning for Performance"
 3:25 -  4:00 - Networking, Adjourn


To pre-register please use our new online registration form at:
meeting registration form
email and give us your name and company. If you are not already on our distribution list and wish to be, include your email address and phone number.

If you do not wish to continue receiving these occasional notices, please indicate that in your registration email.

Pre-registration must be completed by Midnight, Friday, April 1st. 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 the meeting site:

The meeting is in the IBM Harris Blvd facility

North bound on I-77 (from the Rock Hill direction):Turn right onto I-85 North and follow next directions.

On I-85 (coming from either direction): Take exit 45B onto Harris Blvd. West. Turn Left at 2stop light onto IBM Drive and follow the directions below.

South bound on I-77 (from the Statesville direction) Turn left onto Harris Blvd. East (exit 18) Go approximately 6.3 miles to the 10th stop light (counting the one at top of I-77 ramp) Turn Right onto IBM Drive (Don't turn onto the IBM Drive at the 7th stop light).

Once on IBM Drive, Turn Right at 2nd drive. Look for the SIRDUG parking sign on the right side of the road. We are to park in the lower visitor parking lot. Enter the Visitors Lobby and follow the SIRDUG signs to the Cafeteria Conference Room.

James Surber's Biography

James Surber has been a database administrator on several DBMS's for over 10 years. He is currently a Senior DBA at Werner Enterprises, one of the nation's largest truckload transportation companies utilizing the Global Positioning System (GPS) and DB2's Spatial Extender and Geodetic Extender. He currently works on DB2 Windows, Unix and AIX in a 24x7 environment using OLAP Databases and Data Warehouses. James has been in the computer industry for over 25 years where he has taught computers, been a programmer, network administrator, project lead and database administrator. IBM Certified § Specialist DB2 UDB V6/7 User § Solutions Expert DB2 V7.1 Database Administrator for OS/390 § Solutions Expert DB2 UDB V7.1 Database Administrator for UNIX, Windows and OS/2. IBM Certified § Specialist DB2 UDB V6/7 User § Solutions Expert DB2 V7.1 Database Administrator for OS/390 § Solutions Expert DB2 UDB V7.1 Database Administrator for UNIX, Windows and OS/2.

Title: "Designing Database Structures with 24x7 in Mind"
Designing Database Structures with 24x7 in Mind There are database design choices and operational techniques that can reduce outages. We discuss designing tables and structures with 24x7 in mind with the following concepts: rule base table structures, segregate tables to maintain table information (partition keys etc.), flexible code table design, and referential Integrity and constraints. We will also cover some techniques through application coding for 24x7.

Title: "Maintaining Near 24x7 During Table Changes II"
Table changes are typically incompatible with the goal of full availability. There are database design choices and operational techniques that can eliminate or reduce outages when change is unavoidable. We discuss the limited “alter” statement permitted in DB2 OS/390 today and how it can best be used. When a table drop or create is required, we describe a process that has allowed us to shrink table downtime from hours to minutes. We conclude with recovery scenarios from various table change problems.

Sheryl M. Larsen's Biography

Sheryl M. Larsen, Inc., SMLI, is a firm specializing in Advanced SQL Consulting and Education ( Sheryl M. Larsen is the founder/president and is an internationally recognized researcher, consultant and lecturer and is known for her extensive expertise in SQL. She has over 20 years experience in DB2, published many articles, several popular DB2 posters, and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. She is frequently asked to keynote DB2 world wide events. She is an IDUG "Hall of Fame" speaker, President of the Midwest Database Users Group (, and a member of IBM's DB2 Gold Consultants program.

Title: "Extreme SQL Tuning for Performance"

Recommended Track: z/OS This presentation will examine traditional and extreme methods for altering optimizer chosen access paths. IBM warranted tuning methods such as OPTIMIZE FOR 1 ROW, no operations, REOPT(VARS), as well as additional methods, such as fake filtering and table expressions, will be demonstrated. Extreme Cross Query Block Optimization techniques, X2QBOpt will be demonstrated for extreme situations. The how to tune SQL is usually easy, however, sometimes drastic situations demand extreme measures.
Recommended Track: z/OS

IDUG North America 2005 Discount Information

You can download the IDUG 2005 North America Conference RUG coupon by Clicking here

SIRDUG Home Page

Last Update: March 2, 2005

Copyright © 2003 SIRDUG Inc. All rights reserved.