August 21-22 SIRDUG Educational Seminars Featuring Bonnie Baker



Meeting Details

WHEN? August 21 (Thursday) & August 22 (Friday)

WHERE?
IBM Harris Blvd facility (Charlotte, NC) - See directions below

COST? $175 cash or check, per day, at the door.
We do not accept credit cards.


Meeting Agenda

August 21
Featured Speaker - Bonnie Baker

 8:00 -  9:00  -  Registration - Coffee, Danish, and Networking
 9:00 - 12:15  -  Bonnie Baker "A DBA's Self-Audit Guide"
12:15 -  1:00  -  Lunch
 1:00 -  4:00  -  Bonnie Baker "A DBA's Self-Audit Guide"

August 22
Featured Speaker - Bonnie Baker

 8:00 -  9:00  -  Registration - Coffee, Danish, and Networking
 9:00 - 12:15  -  Bonnie Baker "Little Things Can Make a Big Difference"
12:15 - 12:55  -  Lunch
 1:00 -  4:00  -  Bonnie Baker "Little Things Can Make a Big Difference"
  

Registration

To pre-register please 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.

Pre-registration must be completed by Midnight, Friday, August 15th. 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 2nd stop light onto IBM Drive and follow 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) Find a parking place and enter the Visitors Lobby. Follow the SIRDUG signs to the Cafeteria Conference Room.


Bonnie Baker Biography

Bonnie Baker, a consultant with over 19 years of information systems experience, concentrates on supporting the IBM DB2 product on the MVS platform. She performs as both consultant and architect on application development projects. She also performs design reviews, conducts performance and tuning consulting engagements, makes recommendations for performance improvements, and presents seminars for application designers, developers, and DBAs. She is best known for creating and presenting application performance seminars in a series entitled, "Things I Wish They'd Told Me 8 Years Ago." She is a frequent speaker at the U.S., European, Australian and Canadian DB2 Technical Conferences and IDUG's as well as many local DB2 user groups (like ours!!). She has won Best Speaker for her sessions. She tries to bring her 'hands-on' 'from-the-trenches' perspective to her presentations to provide real-life solutions to real-world problems.


Educational Seminar Details


August 21: "A DBA's Self-Audit Guide"


The job of ensuring good DB2 performance can be a difficult one, but there is information available that can make it easier. The purpose of this seminar is to tell you where you can look, define the information that is available, and explain how to interpret that information. With a better understanding of this information, the performance of DB2 programs can be improved. In this seminar Bonnie will share many of the techniques that she uses in her consulting engagements. And of course, she'll uses analogies and war stories to make the concepts clear and easy to understand.

WHY ASK QUESTIONS
DISCOVER PERFORMANCE INHIBITORS
Fragmented Data
Problems Caused by DDL Parameters
Inappropriate BIND Parameters
SQL Red Flags

SAVE DASD
Unused/Underused Indexes
Unnecessary Freespace
Empty Extents
Un-reclaimed Space

STOP PROBLEMS BEFORE THEY START
SQL Prototyping

WHAT TO ASK
WHERE TO LOOK FOR ANSWERS
HOW TO ASK
COMING TO CONCLUSIONS

August 22: "Little Things Can Make a Big Difference"


You write a program that runs for hours. Someone makes a minor change and the program runs in minutes. What are those little things, those minor trivial changes that make a BIG difference in program performance? This session will give you a list of things to try that might make you a hero.

If you have any links that you would like to see on our pages, send SIRDUG an EMAIL using our mail box below.


 


SIRDUG Home Page

Last Update: July 15, 2003

Copyright 2003 SIRDUG Inc. All rights reserved.