March 15, 2006 Central PA RUG Agenda

Terry Gawlas

March 15, 2006 Central PA RUG Agenda

Attached is the agenda for the Central PA DB2 User Group to be held

Central PA Regional DB2 User Group

Date: Wednesday, March 15, 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

Agenda for March 15, 2006
8:30 - 9:00 Breakfast , Compliments of ITGain

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 Explaining Access Paths – Visually (IDUG Tampa 2006
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.

12:00 - 12:30 Lunch, Compliments of ITGain
12:30 – 1:00 Monitoring DB2 Connect and DB2 UDB With Speedgain for DB2
Presenter: ITGain

1:00 – 2:15 SQL Predicate Coding Best Practices for Developers (IDUG
Tampa 2006 Session)
Presenter: Phil Gunning, Gunning Technology Solutions, LLC
This presentation will show you how to code high performing SQL It will
cover Range delimiting, Index SARGable, Data SARGable and residual
predicates. Filter factors and selectivity will be discussed along with
query rewrite examples. Index design and predicate selection best practices
and restriction of result sets will be covered. After attending this
session you will be able to go out and code top performing SQL.

2:15 – 2:30 Break

2:30 – 3:45 Learning from Experience: DB2 Hints for Java (IDUG Tampa 2006
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:45 – 4:00 Closing