DB2 Forum Meeting Tuesday

Robert Brock

DB2 Forum Meeting Tuesday
DB2 Forum - The Southwest DB2 Users Group. Visit our webpage at:
http://www.db2forum.com

Come to the 1st Quarter DB2 Forum Meeting.
DB2 Forum would like to thank Compuware for sponsoring this meeting.

Date: Tuesday January 20, 2004

Registration & Continental Breakfast: 8:00 A.M. - 9:00 A.M
Meeting: 9:00 A.M. - 12:00 P.M.

Meeting Location:
Renaissance Dallas North Hotel
4099 Valley View Lane (I-635 at Midway)
Dallas, TX 75244
972.385.9000

Meeting Cost: $10 for non-members, free to members.
Membership is $25 per year per person --or--
$100 for 5 people in a company --or--
$350 for unlimited people in a company.
You can register at the meeting.
Cash or Check only please

Speaker
Susan Lawson - YL&A
First Presentation Overview

Table and Index Design for High Performance

This presentation will discuss many issues surrounding alternative table designs and performance. We will look at many different alternatives to help design tables for the best performance possible for the type of application process. There are many issues to consider for high volume insert and update transactions, and a balancing act to be achieved for responsiveness to readers. Table issues such as denormalization, non-column attributes, indicator columns, repeating columns, derived data, aggregated columns, table flipping, identify columns, surrogate keys, horizontal and vertical partitioning. We will also look at issues with designing VLTBs (Very Large Tables) and XVLTBs (eXtremely Large Tables) - the rules have changed!

Second Presentation Overview

Top 20 Performance Myths 2003

Throughout the years, we are all doing things because we used to do so. DB2 has evolved and so have you/we - but we are still carrying pieces from the past because "This is what we have always done". During this session, Susan Lawson will look into some of these myths.

Speaker Biography

Susan Lawson is an internationally recognized consultant and lecturer with a strong background in system and database administration, and is a principal with YL&A. In the past, she has been an IBM Data Sharing advocate where she supported a variety of large DB2 customers. She provided technical expertise for migration to DB2 Data Sharing in a Parallel Sysplex environment, as well as troubleshooting performance problems during post-implementation. She currently works with several clients to help develop, implement and tune some of the world's largest and most complex DB2 databases. Her other activities have included authoring articles, presenting at user group meetings (where she has won best speaker awards), and providing technical editing for trade journals. She is an IBM GOLD Consultant for DB2 and S/390, and is an IBM Certified DBA and Application Developer for DB2 UDB Version 7 for OS/390. She is one of the authors of "DB2 Answers!" published by Osborne/McGraw-Hill, "DB2 High Performance Design and Tuning" published by Prentice-Hall, "DB2 UDB for OS/390 Version 7 DBA Certification Guide" published by Prentice-Hall, "DB2 UDB for OS/390 Version 7 Application Development Certification Guide" and "DB2 UDB V7 Family Reference Guide" published by YL&A.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Robert Brock

DB2 Forum meeting Tuesday
(in response to Robert Brock)
DB2 Forum - The Southwest DB2 Users Group. Visit our webpage at:
http://www.db2forum.com

Come to the 1st Quarter DB2 Forum Meeting.
DB2 Forum would like to thank Compuware for sponsoring this meeting.

Date: Tuesday January 20, 2004


Registration & Continental Breakfast: 8:00 A.M. - 9:00 A.M
Meeting: 9:00 A.M. - 12:00 P.M.

Meeting Location:
Renaissance Dallas North Hotel
4099 Valley View Lane (I-635 at Midway)
Dallas, TX 75244
972.385.9000

Meeting Cost: $10 for non-members, free to members.
Membership is $25 per year per person --or--
$100 for 5 people in a company --or--
$350 for unlimited people in a company.
You can register at the meeting.
Cash or check only please.

Speaker
Susan Lawson - YL&A
First Presentation Overview

Table and Index Design for High Performance

This presentation will discuss many issues surrounding alternative table designs and performance. We will look at many different alternatives to help design tables for the best performance possible for the type of application process. There are many issues to consider for high volume insert and update transactions, and a balancing act to be achieved for responsiveness to readers. Table issues such as denormalization, non-column attributes, indicator columns, repeating columns, derived data, aggregated columns, table flipping, identify columns, surrogate keys, horizontal and vertical partitioning. We will also look at issues with designing VLTBs (Very Large Tables) and XVLTBs (eXtremely Large Tables) - the rules have changed!

Second Presentation Overview

Top 20 Performance Myths 2003

Throughout the years, we are all doing things because we used to do so. DB2 has evolved and so have you/we - but we are still carrying pieces from the past because "This is what we have always done". During this session, Susan Lawson will look into some of these myths.

Speaker Biography

Susan Lawson is an internationally recognized consultant and lecturer with a strong background in system and database administration, and is a principal with YL&A. In the past, she has been an IBM Data Sharing advocate where she supported a variety of large DB2 customers. She provided technical expertise for migration to DB2 Data Sharing in a Parallel Sysplex environment, as well as troubleshooting performance problems during post-implementation. She currently works with several clients to help develop, implement and tune some of the world's largest and most complex DB2 databases. Her other activities have included authoring articles, presenting at user group meetings (where she has won best speaker awards), and providing technical editing for trade journals. She is an IBM GOLD Consultant for DB2 and S/390, and is an IBM Certified DBA and Application Developer for DB2 UDB Version 7 for OS/390. She is one of the authors of "DB2 Answers!" published by Osborne/McGraw-Hill, "DB2 High Performance Design and Tuning" published by Prentice-Hall, "DB2 UDB for OS/390 Version 7 DBA Certification Guide" published by Prentice-Hall, "DB2 UDB for OS/390 Version 7 Application Development Certification Guide" and "DB2 UDB V7 Family Reference Guide" published by YL&A.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm