Final (???) Update to Central PA Regional DB2 User Group

Terry Gawlas

Final (???) Update to Central PA Regional DB2 User Group

At least one thing I know for sure - in your jobs you have to be flexible,
so another change is never a surprise. Below is the final (???) agenda.
If you have not registered, and would like to, just let me know!

Looking forward to seeing you next week!

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

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 Stored Procedures, UDFs, and Triggers
Presenter: Daniel Luksetich, Yevich, Lawson & Associates
These new features significantly enhance and expand
application design possibilities and require coding techniques quite
different from traditional methods. There are even new languages and client
server tools involved. But besides the methods used to write and implement
these features, they can become very complex in function. Table and scalar
functions to access non-DB2 data from within the SQL statement, recursive
triggers, and nested stored procedures require well-thought out designs and
have performance impacts that needed to be understood for proactive tuning.
This session will introduction this functionality, as well as when best to
use these features in order to obtain the best performance.

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

12:30 – 1:45 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.

1:45 – 2:00 Break

2:00 – 3:15 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:15 – 3:30 Closing