November 10 SIRDUG Educational Seminars Featuring Dan Luksetich & Tink Tysor
WHEN? November 10 (Friday)
WHERE?
IBM Harris Blvd facility (Charlotte, NC) - See directions below
COST? $40 cash or check, per day, at the door.
We do not accept credit cards.
November 10
Featured Speakers - Dan Luksetich & Tink Tysor
8:00 - 9:00 - Registration - Coffee, Danish, and Networking
9:00 - 9:10 - Announcements
9:10 - 10:20 - Dan Luksetich
10:20 - 10:40 - Break
10:40 - 11:50 - Dan Luksetich
11:50 - 12:50 - Lunch
1:00 - 2:10 - Tink Tysor "Using Views, RI and Other Stuff for Performance"
2:10 - 2:40 - Break - SIRDUG celebration
2:40 - 3:50 - Tink Tysor 'Using Views, RI and Other Stuff for Performance"
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.
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, Friday, November 3rd. 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.
Dan Luksetich is a senior DB2. He works as a DBA, application architect,
presenter, author, and teacher. Dan has been in the information technology
business for over 21 years, and has worked with DB2 for over 16 years.
He has been a COBOL and BAL programmer, DB2 system programmer, DB2 DBA,
and DB2 application architect. His experience includes major
implementations on z/OS, AIX, and Linux environments. This includes:
Application design, Database administration, Complex SQL, SQL tuning,
DB2 performance audits, Replication, Disaster recovery, Stored procedures,
UDFs, and triggers. He is a certified DB2 DBA and application developer,
and the author of several DB2 related articles.
BL “Tink” Tysor, an experienced Database Administrator, SQL developer and
Relational Data Modeler with over 34 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 has taught all levels of DB2 classes, and is on the IDUG Solution’s
Journal Editorial Review Board. He has spoken at the NA and EJ IDUG
Conferences, RJGs, and authored publications on DB2.
Educational Seminar Details
"Using Views, RI and Other Stuff for Performance"
The DB2 optimizer has long been recognized for reliably finding the access path for the best response time for most SQL statements. With DB2 Version 8, this has been taken to new heights. Now with ever decreasing hardware costs, both memory and CPU, programming cost becomes more and more significant. Codd’s original 12 rules for relational data stressed the goal of separating program logic from specific data implementation. Now with DB2 version 8, that separation can be farther realized utilizing views, that can make programming easier and more productive, allow for changing data organization to optimize retrieval, and adjust the access path to the underlying data based on predicate data. This session will cover how to take advantage of these new capabilities to make application programmers more productive while enhancing query response time.
This seminar is appropriate for z/OS as well as the Linux, UNIX and Windows(LUW) platforms.
I. Overview
II. Performance Things
III. Patterns
IV. Strategies for Performance
V. Performance Enablers
VI. Conclusion
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: September 17, 2006
Copyright © 2006 SIRDUG Inc. All rights reserved.