August 21-22 SIRDUG Educational Seminars Featuring Bonnie Baker
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.
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"
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.
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, 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
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
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.