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.

Meeting Details

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.

Meeting Agenda

 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 registration@sirdug.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).

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. 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 Biography

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.

"Put Your Database On A Diet" Abstract

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.

Bullet Points:

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 Biography

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.

Roger Sanders Abstract

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.

Tink Tysor's Biography

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".

Tink Tysor Abstract - "DB2 101"

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 astute.

Bullet Points:
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
5. Summary

Tink Tysor Abstract #2"

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.