February 21 IDUG Preview Session featuring Robert Catterall, Roger Sanders and Tink Tysor
SIRDUG Meeting February 21st, 2003
Featuring: Robert Catterall - IDUG Speaker's Hall of Fame & Roger
Sanders, author of several DB2 books.
SIRDUG presents our annual "Sneak Preview" of the IDUG North America
Conference. Come hear Robert Catterall, Tink Tysor, and Roger Sanders
offer 2003 IDUG conference presentations. Your training budget won't
be taking you to IDUG this year? Or you're going, and want to get a
peak at coming attractions? Come to SIRDUG and get an early piece of
the IDUG action.
Our own Tink Tysor will start the day by giving us some insights into
explaining DB2 to "newbies". He will be followed by our feature
speaker, Robert Catterall of Check Free. As an IBMer, Robert was the
recipient of the IDUG Speaker's Hall of Fame award. Now that he works
for Check Free, he is an especially popular and highly-qualified User
Speaker. Robert will give us tips for trimming down our "overweight"
databases. Following lunch, we will hear from Roger Sanders who has
authored several DB2 books, including the recent "DB2 Administration
Exam Guide". Robert will clarify the mysteries of isolation levels,
locking, and concurrency.
WHEN? Friday, February 21, 2003
WHERE? IBM Harris Blvd facility
COST? $15 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:10 - Tink Tysor - "DB2 101"
10:10 - 10:30 - Mid-Morning Break
10:30 - 11:40 - Robert Catterall - "Put Your Database On A Diet"
11:40 - 12:30 - Lunch
12:30 - 1:40 - Roger Sanders - "Taking the Mystery Out of Isolation
Levels and Locking"
1:40 - 2:00 - Mid-Afternoon Break
2:00 - 3:30 - Tink Tysor - "Let Cartesian Products Be Your Friend - But Caution"
3:30 - 4:00 - Networking, Adjourn
To pre-register please email firstname.lastname@example.org and give us your
name, company, 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, Monday, February 17th.
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).
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. Go through gate (tell them
that you are here for a SIRDUG meeting). 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.
Robert Catterall is the Director of Strategic Technology for the
Electronic Commerce Division of Atlanta-based CheckFree Corporation.
Robert has twenty one years of experience in enterprise systems, and
is a member of the IDUG Speaker's Hall of Fame.
Title: "Put Your Database On A Diet"
When it comes to databases, bigger is NOT always better. At CheckFree,
we like to run lean and mean. This presentation will describe
techniques, such as data bucketing and surrogate keys, that we have
used to make our DB2 for z/OS system more disk- and CPU-efficient.
1. CICS shared data tables
2. Surrogate keys and the incredible shrinking index
3. Bucket that data
4. Store only what you need
5. MQ - a better data parking lot
Roger Sanders is a Database Performance Engineer with Network Appliance
, Inc. He has been designing and programming software applications for
IBM PCs for more than 15 years and he has worked with DB2 Universal
Database and its predecessors for the past 10 years. He has written
several computer magazine articles, co-authored an IBM Redbook, presented
at three International DB2 User's Group (IDUG) conferences, and is the
author of All-In-One DB2 Administration Exam Guide, DB2 Universal Database
SQL Developer's Guide, DB2 Universal Database API Developers Guide, DB2
Universal Database CLI Developer's Guide, ODBC 3.5 Developer's Guide, and
The Developer's Handbook to DB2 for Common Servers. His background in
database application design and development is extensive and he holds the
following professional certifications: IBM Certified Advanced Technical
Expert -- DB2 for Clusters; IBM Certified Solutions Expert -- DB2 UDB
V7.1 Database Administration for UNIX, Windows, and OS/2; IBM Certified
Solutions Expert -- DB2 UDB V6.1 Application Development for UNIX,
Windows, and OS/2; IBM Certified Specialist -- DB2 UDB V6/V7 User.
Individuals who have taken the DB2 Family Fundamentals (512) exam often
tell me they received their lowest scores on the section that covers
isolation levels and locking. This implies that these two concepts
remain a mystery to a large number of DB2 users. This presentation is
designed to take away the mystery and replace it with a solid understanding
of the DB2 components that make database concurrency possible.
BL "Tink" Tysor, an experienced Database Administrator, SQL developer
and Relational Data Modeler with over 32 years of computer experience,
has concentrated on DB2 Universal Database for z/OS & OS/390 since 1994,
and has been involved in every aspect of Database Management from
Conceptual, Logical and Physical Data Modeling, database creation and
maintenance, SQL generation and reviews, through performance tuning
and data recovery.
Tink is on the North American Conference Planning Committee for IDUG,
has spoken at the North American and European IDUG Conferences, and
recently Co-authored an IBM REDBOOK "DB2 for z/OS Tools for Database
Administration and Change Management".
Title: Beginning DB2, SQL and Thinking Relationally (or DB2 101)
Relational technology had a dramatic impact on proper design of
software. This presentation will help IT professionals, new to
relational technology, bridge the gap between Flat File, VSAM and IMS
thinking to relational thinking. This also will be valuable to
management in determining if prospective employees are relationally
1. What Makes Relational Technology Different
2. Effect on Data Design (OLTP vs. OLAP)
3. Effect on System Design
4. Effect on Program Design and Implementation
Title: Let Cartesian Products Be Your Friend - But Proceed With Caution
Not including a proper join predicate in an SQL statement could
produce an intermediate result set that "brakes the bank" in size and
will not finish before retirement. This presentation explores examples
of how to properly harness the awesome power of a Cartesian join to
produce exceptionally useful result sets.
What is a Cartesian join
No Join Predicate Example
Partial Join Predicate Example
Earned Premium Example
Anticipating the Unexpected
Based on Article: "Let Cartesian Products be Your Friend - But Proceed With Caution" in the IDUG Solutions Journal - Volume 8 Issue 3, 2001
SIRDUG Home Page
Last Update: February 8, 2003
Copyright © 2003 SIRDUG Inc. All rights reserved.