August 19-20 SIRDUG Educational Seminars Featuring Bonnie Baker
Bonnie's back, with two new offerings of things we ALL wish we knew a long time ago! We are pleased to announce that
Bonnie Baker is returning to share her unique perspectives on DB2 in the sixth annual Bonnie Baker class hosted by SIRDUG.
On August 19th, Bonnie will present "Things I Wish They'd Told Me 8 Years Ago - Part 6". On August 20th, she will present "Things I Wish They'd Told Me 8 Years Ago - Part 7". These classes, never before presented at SIRDUG, continue Bonnie's acclaimed series of presentations on getting the most from your mainframe DB2 system. You may attend either day or both, and you do not need to have attended any of the previous parts of the series to benefit from these classes.
WHEN? August 19 (Thursday) & August 20 (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 19 (Thursday)
Featured Speaker - Bonnie Baker
8:00 - 9:00 - Registration - Coffee, Danish, and Networking
9:00 - 12:00 - "Things I Wish They'd Told Me 8 Years Ago -
Part 6"
12:00 - 1:00 - Lunch
1:00 - 4:00 - "Things I Wish They'd Told Me 8 Years Ago -
Part 6 (continued)"
August 20 (Friday)
Featured Speaker - Bonnie Baker
8:00 - 9:00 - Registration - Coffee, Danish, and Networking
9:00 - 12:00 - "Things I Wish They'd Told Me 8 Years Ago -
Part 7"
12:00 - 1:00 - Lunch
1:00 - 4:00 - "Things I Wish They'd Told Me 8 Years Ago -
Part 7 (continued)"
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.
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 13th. 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. 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.
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
This is the sixth in a series of seminars entitles "Things I Wish
They'd Told Me 8 Years Ago." It continues the tradition with all new
ideas, new tips, and new techniques for improving program performance.
Analogies, war stories, and examples are used to simplify difficult
concepts so that the programmers can apply those concepts to program
logic and SQL in order to improve performance. New features available
in V6 and V7 will be emphasized. Hints and tips are given at all
levels, for those who have used DB2 for years as well as those who just
met DB2 this year. This seminar is based on DB2 for MVS-OS390-z/OS but
those using other platforms may find some of the information beneficial
Topics include:
- Reviewing of basic concepts
- Using new features instead of programs
- Understanding Casting
- Designing with variable length rows
- Making locking compromises
- What does this have to do with performance?
- Discovering instant locks
- Understanding REBIND issues
- Deciding among 3 types of tables
- Understanding outer join issues
- Highlighting performance topics
- Benefiting from a few small bits and pieces
This session is the seventh in Bonnie's series of seminars designed to
give programmers a better understanding of how DB2 works and how to
make it work less. Using analogies and war stories to illustrate the
inner workings of DB2,Bonnie will emphasize how a better understanding
of DB2 can lead to better program logic and SQL. The session emphasizes
good programming techniques and alternative ways of writing SQL on the
DB2 for MVS, OS/390, or z/OS platforms.
Topics include:
- New release performance improvements
- DSNZPARMS that programmers should know
- Locking timeouts, deadlocks, and escalation issues
- Ugly SQL
- Understanding and avoiding data integrity exposures
- Join methods
- More about outer join performance
- and much,much more
If you have comments about the SIRDUG site, including requests for
information that you would like to see added to the site,
send SIRDUG an EMAIL
Last Update: June 30, 2004
Copyright © 2004 SIRDUG Inc. All rights reserved.