| Officers
Meeting Schedule Meeting Minutes Membership Links of interest DB2 Trivia Hot Tips Home |
Meeting at Highlights For Children in
Grandview
|
| 12:30-1:00 | Registration |
| 1:00-1:15 | Business Meeting. Announcements. |
| 1:15-2:45 | Things I Wish They'd Told Me 8 Years Ago, Part 5 Presented by Bonnie Baker Abstract |
| 2:45-3:00 | Break - Coffee, cookies, and pop will be served. |
| 3:00-4:30 | Things I Wish They'd Told Me 8 Years Ago, Part 5 (Cont.) Presented by Bonnie Baker. Abstract |
HOW DOES A PROGRAM GET DATA FROM DB2?
Program Execution ? The Big Picture
Program Preparation ? Bind vs Rebind
Retrieving Data ? Rid and Data Sort Required, Multiple Index Access
Program Execution ? The Bigger Picture - more about Stage 2 Predicates
WHAT DOES THIS HAVE TO DO WITH PERFORMANCE?
Some More Referential Integrity Issues
Lock Avoidance ? one more time
Data Integrity Exposures
Index Overhead
Read-Only Program Commits
SIX Locks
Alter to Add Column Impact
Little Things
System Tips, Design Tips, Programming Tips, SQL Tips
About the Speaker - Bonnie Baker
Bonnie Baker is a consultant and instructor specializing in application performance
issues with DB2 on the MVS, OS/390, and z/OS platforms. She is best known for
her series of seminars entitled "Things I Wish They'd Told Me 8 Years Ago."
She also writes the "Programmers Only" column for DB2 Magazine and
has won the IDUG Best Speaker Award 5 times and is a member of the IDUG Speakers Hall of
Fame.
All in attendance must have either paid in advance or be prepared to pay the dues at
the meeting. Walk-in attendees will be charged $25.
Please review the Membership page. Our Officer of Dues and
Membership is Sharon Hamilton. She can be
reached at membership@codug.org or (614) 854-5219. Contact her with any questions
regarding your company's status.
From the North I: 315 S. to 670 E, exit Neil Ave. Right at exit
(Neil), right at Dublin Rd.
From the North II: I-71 S. to 670 W, exit Neil Ave. Left at exit
(Neil), right at Dublin Rd.
From the North III: Riverside Dr. south, becomes Dublin Rd.
From the South: I-71 N to 315 N. Exit Long St./Dublin Rd. Turn left.
From the East: I-70 W, to 670 W, exit Neil Ave. Left at exit (Neil),
right at Dublin Rd.
From the Airport: 670 W, exit Neil Ave. Left at exit (Neil),
right at Dublin Rd.
From Downtown: W. on Spring St., becomes Dublin Rd.
From Dublin Rd. at Grandview Ave: Turn south on
Grandview, turn right (west) on Watermark Dr.
From the West: I-70 W. to Grandview Exit. Right (north) on Grandview
Ave., left (west) on Watermark Dr.
Created: August 29, 2001 / Updated: August 29, 2001
Send changes and corrections to webmaster@codug.org