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!
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.
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
or
email registration@sirdug.org 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.
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 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, Inc., SMLI, is a firm specializing in Advanced
SQL Consulting and Education (www.smlsql.com). 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 (www.mwdug.org), and a member of IBM's DB2
Gold Consultants program.
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
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.