Pittsburgh DB2 RUG - MARCH 17, 2006

Chris Straub

Pittsburgh DB2 RUG - MARCH 17, 2006

** please make note of the location - Caring Place Forum

Pittsburgh Regional DB2 User Group

Date: Friday, March 17, 2006
Place: Caring Place on Stanwix Street
Cost: FREE
Reservations: Email or call: [login to unmask email]
412.544.5352
[login to unmask email] 412.544.7006

For details and directions: See http://www.db2parug.org

====

Agenda for March 17th, 2006
8:30 - 9:00 Breakfast , Compliments of Impact CSI

9:00 – 10:30 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.

10:30 - 10:45 Break

10:45 - 12:00 Utilizing DB2 UDB Table Expressions on all Platforms
(IDUG Tampa 2006 Session)
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!

12:00 - 12:30 Lunch Compliments of IBM
12:30 – 1:00 Lunch & Learn Session - What's new with Monitoring DB2 V8
Presented by: IBM

1:00 – 2:15 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.


2:15 – 2:30 Closing

====

Chris Straub

Pittsburgh DB2 RUG - MARCH 17, 2006
(in response to Chris Straub)

Reminder... only 2 weeks until the Pittsburgh DB2 RUG... sign up now!


** please make note of the location - Caring Place Forum

Pittsburgh Regional DB2 User Group

Date: Friday, March 17, 2006
Place: Caring Place on Stanwix Street
Cost: FREE
Reservations: Email or call: [login to unmask email]
412.544.5352
[login to unmask email] 412.544.7006

For details and directions: See http://www.db2parug.org

====

Agenda for March 17th, 2006
8:30 - 9:00 Breakfast , Compliments of Impact CSI

9:00 – 10:30 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.

10:30 - 10:45 Break

10:45 - 12:00 Utilizing DB2 UDB Table Expressions on all Platforms
(IDUG Tampa 2006 Session)
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!

12:00 - 12:30 Lunch Compliments of IBM
12:30 – 1:00 Lunch & Learn Session - What's new with Monitoring DB2 V8
Presented by: IBM

1:00 – 2:15 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.


2:15 – 2:30 Closing

====

Chris Straub

Pittsburgh DB2 RUG - MARCH 17, 2006
(in response to Chris Straub)

FYI, we have a change for the first presenter/presentation for tomorrow.


------------------------------------------------------------------------------------------------
** please make note of the location - Caring Place Forum

Pittsburgh Regional DB2 User Group

Date: Friday, March 17, 2006
Place: Caring Place on Stanwix Street
Cost: FREE
Reservations: Email or call: [login to unmask email]
412.544.5352
[login to unmask email] 412.544.7006

For details and directions: See http://www.db2parug.org

====

Agenda for March 17th, 2006
8:30 - 9:00 Breakfast , Compliments of Impact CSI

9:00 – 10:30 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 introduce this functionality, as well as when best to use
these features in order to obtain the best performance.

10:30 - 10:45 Break

10:45 - 12:00 Utilizing DB2 UDB Table Expressions on all Platforms
(IDUG Tampa 2006 Session)
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 ery
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 Compliments of IBM
12:30 – 1:00 Lunch & Learn Session - What's new with Monitoring DB2 V8
Presented by: IBM

1:00 – 2:15 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.


2:15 – 2:30 Closing

====