Central PA Regional DB2 User Group - AGENDA REVISION!

Terry Gawlas

Central PA Regional DB2 User Group - AGENDA REVISION!

The agenda for the Central PA Regional DB2 User Group had to be revised for
3/15/06. Phil Gunning will no longer be able to attend and the Lunch and
Learn will not be held. Please note, Daniel Luksetich will now be doing a
second presentation. If you would like to change your reservation, please
let me know!

Thanks!
Terry

Central PA Regional DB2 User Group

Date: Wednesday, March 15th, 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 March 15th, 2006
8:30 - 9:00 Breakfast
Sponsored By: Phil Gunning, Gunning Technology Solutions, LLC

9:00 - 10:30 Utilizing DB2 UDB Table Expressions on all Platforms (IDUG
2005 & IBM Tech 2005)
Presenter: Daniel Luksetich, Yevich, Lawson & Associates
This presentation focuses on DB2 table expressions
across all platforms, their usefulness and performance implications. It
also contains a very inspirational story and some real world examples of
how table expressions were used to replace application programs and save
customers considerable resources. Included are some examples of some
amazingly complex SQL statements, as well as some that improved SQL
application response times from days to minutes or seconds!

10:30 - 10:45 Break

10:45 – 12:00 Taking Advantage of DB2 UDB V8 Table Expressions (IDUG 2005
& IBM Tech 2005)
Presenter: Daniel Luksetich, Yevich, Lawson & Associates
This presentation focuses on DB2 table expressions
across all platforms. It also contains a very inspirational story and some
real world examples of how table expressions were used to replace
application programs and save customers considerable resources. Included
are some examples of some amazingly complex SQL statements, as well as some
that improved SQL application response times from days to minutes or
seconds!

12:00 - 12:30 Lunch
Sponsored By: Phil Gunning, Gunning Technology Solutions, LLC

12:30 – 1:45 Explaining Access Paths – Visually (IDUG Tampa 2006
Session)
Presenter: Chris Straub, Highmark
Ever wonder what a table space scan actually looks
like? What about a merge scan join? How about multiple index access? Or a
non-matching index scan? We've all heard the DBA's mention these terms and
we've seen them in our Explain, but have you ever wondered what they
actually look like? This presentation gives a detailed graphical depiction
and explanation of these and many other DB2 access related terms.

1:45 – 2:00 Break

2:00 – 3:15 Learning from Experience: DB2 Hints for Java (IDUG Tampa 2006
Session)
Presenter: John Mallonee, Highmark
Java and DB2 work well together, but like any
application environment, there are lots of ways to get the job done. After
working with Java development projects for over 5 years, I've come to find
that I've made some mistakes and learned some valuable lessons. This
presentation will cover many of the helpful tips that I've learned related
to performance, security, debugging, application design, and coding.

3:15 – 3:30 Closing