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

Terry Gawlas

Reminder - Central PA Regional DB2 User Group - 9/19/2006
REMINDER!!!
Please register if you plan to attend!

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

Steve Brown

Re: Reminder - Central PA Regional DB2 User Group - 9/19/2006
(in response to Terry Gawlas)
Terry,

Please register Paul Beltrandi Jr, and myself for the User Group
Meeting on Sept. 19

Thanks,
Steve
S. Steven Brown
Development DB2 DBA
AMS DBA Service Center
IBM Corporation
2020 Technology Pkwy
Office 2-164 Mail Room
Mechanicsburg, PA 17050
Div 6C Dept 7H9A
Tieline 8/471-2067 or 717-610-2067
[login to unmask email]





Terry Gawlas <[login to unmask email]>
Sent by: DB2 User Group - Central Pennsylvania List
<[login to unmask email]>
09/05/2006 02:13 PM
Please respond to
[login to unmask email]


To
[login to unmask email]
cc

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






REMINDER!!!
Please register if you plan to attend!

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

Attachments

  • import1 (7.2k)