Central PA Regional DB2 User Group - 9/19/2006

Terry Gawlas

Central PA Regional DB2 User Group - 9/19/2006
Central PA Regional DB2 User Group

Date: Tuesday, September 19, 2006
Place: Camp Hill Corporate Center, Building 300, Large Auditorium
Cost: FREE
Reservations: Email or call: [login to unmask email] (717) 302-3991
For details and directions: See http://www.db2parug.org

Agenda for September 19, 2006
8:00-8:45 Breakfast, Sponsored by Quest Corporation
8:45-9:00 Opening Remarks
9:00-10:15 Top 10 Ways to Waste CPU!
Presenter: Susan Lawson, Yevich, Lawson & Associates, Inc.
During the past several years we have worked with several
companies to design high performance databases and applications and have
done extensive testing and research on ways to minimize I/O and CPU. Many
of those applications and databases are faster than we ever could imagine.
However, those are the exception. Too often we see shops with critically
CPU constrained environments. Most of these shops have one thing in common:
They are wasting CPU. There are some very common ways to do this and we
need to look at how you can safely and effectively reduce CPU usage in a
DB2 z/OS environment. This presentation will look at the top 10 ways we
have seen customers waste enormous amounts of CPU unnecessarily (and
unknowingly). A few tuning efforts here and there can improve overall
performance and reduce CPU consumption. Of course every environment is
different and processing needs will vary. However, there are still ways to
reduce CPU usage through some very practical performance tuning efforts and
better design efforts early in the development.
10:15-10:30 Break
10:30-11:45 Managing DB2 Performance in Heterogeneous Environment!
Presenter: Jim Wankowski, Quest Corporation
Obtaining optimal performance from your DB2 applications is a
multi-faceted exercise. DB2 performance optimization cannot be limited to
simply tuning SQL. You need to have an understanding of how factors such as
memory, physical design, and maintenance can affect performance. If you are
a DBA having to manage DB2 on multiple platforms, it is important that you
have an understanding of the differences of what needs to be monitored.
This presentation will show you how to identify and resolve the most common
areas of performance bottlenecks in DB2 running on Unix, Windows and z/OS.
This presentation will compare/contrast the differences in memory
architecture, physical design, maintenance, and SQL tuning techniques for
applications running in z/OS vs. LUW.
11:45-12:30 Lunch, Sponsored by Quest Corporation
12:30-1:45 Managing Data for Long Retention Periods
Presenter: Craig Mullins, Neon Corporation
Several events in recent years have changed the requirements
for retaining data from operational databases to long periods of time.
Required retention periods have ballooned to many years, and in some cases,
to many decades. This coupled with the rapid rise in data volumes and the
importance of providing archived data on demand many years after it is
created, has surfaced the need for companies to build a solid practice for
archiving and managing business data from their online operational
databases. The presentation covers the basics of an archiving methodology
and a number of topics that require special consideration in building a
database archiving practice. Topics covered are application independence,
metadata independence, data authenticity, change management, storage
management, and access control.
1:45-2:00 Break
2:00-3:15 Null & Void: Dealing with Nulls in DB2
Presenter: Craig Mullins, Neon Corporation
Nulls are one of the most controversial aspects of SQL database
systems. On the one hand they seem to be useful as means to record missing
information; on the other hand, they introduce three-valued logic and other
difficulties into our applications. This presentation will delve into the
various aspects of nulls, show some of the problems presented by nulls, and
give advice on how best to use/avoid them.
3:15-3:30 Closing

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