Reminder for 3/28 - Central PA Regional DB2 User Group!

Terry Gawlas

Reminder for 3/28 - Central PA Regional DB2 User Group!
Just a reminder, the user group in in 2 weeks! Please let me know if you
plan to attend. Hope to see you there....

Date: Wednesday, March 28, 2007
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 28, 2007 (Topics may be subject to change)
8:00-8:45 Breakfast - Sponsored By: BMC Corporation

8:45-9:00 Opening Remarks

9:00-10:15 Java and DB2 for Dummies
Presenter: John Mallonee, Highmark Corporation
I was once a dummy when it came to Java and DB2, but have been fortunate to
work in this environment for several years. If you haven't had that
opportunity, you might be wondering about all of those acronyms like JAR's,
EAR's, WAR's, EJB's, JSP's, JDBC, SQLJ, JDK, JVM, API, J2SE, J2EE, and
more. Whether you're an application developer or a DBA, this session will
help you to get a better understanding of this development and runtime
environment. Finally, I'll leave a few minutes for open questions and
answer as many as I can from a user experience perspective.

10:15-10:30 Break

10:30-11:45 Performance for SOA Java DB2 Applicatons!
Presenter: David Beulke, Pragmatic Solutions, Inc.
In the Performance for SOA Java DB2 Applications session the application
developer and DBA learn the common SOA Java performance pitfalls and how to
avoid them. This session takes the attendee through the server application
architecture and discusses the Java application pattern choices. It
highlights the common pitfalls and how to avoid performance problems
related to Java sessions, messages and application persistence issues. The
session also highlights the best practices for database connections, SQL
access and error checking within a high performance environment.
Discussing these areas along with common Java JSP and servlet programming
traps and debugging techniques can help you develop faster and improve your
overall application performance.

11:45-12:30 Lunch - Sponsored By: BMC Corporation

12:30-1:45 Dynamic SQL and the Dynamic Statement Cache
Presenter: Bill Arledge, BMC Corporation
DB2 SQL statements can be static or dynamic. Traditionally, static was the
rule and dynamic the exception. Now the tide has turned a bit with dynamic
SQL being used much more frequently. This presentation will discuss some
fundamentals about tuning dynamic and static SQL. We'll go into a more
detailed discussion on the dynamic statement cache, a capability with the
potential to greatly improve performance for dynamic SQL. As with most
things, there are tradeoffs and costs to be considered with this DB2
feature. Meanwhile, the implementation of the cache often changes from
release to release. This technical session will discuss the Dynamic
Statement Cache to help you understand how the cache is implemented, the
contents of the cache and how you can mine the statistics stored there,
potential benefits and costs of the cache, including potential issues
related to use of the Dynamic Statement Cache.

1:45-2:00 Break

2:00-3:15 Tuning Access Paths: Red Flags to Look for
Presenter: Joe Burns, Highmark Corporation
As DBAs and application developers we have all had to look at an access
path at one time or another. Sometimes a performance issue can be easily
seen in the access path, but other times it can be a little more difficult
to spot. This is especially true when dealing with explain output that
generates multiple query blocks. In this session we will look at explain
output and highlight key areas that affect the performance of various SQL
statements such as joins, sorts and subqueries. The intent is to focus our
efforts on the pieces of the access path that have the most impact on the
performance of our SQL.

3:15-3:30 Closing

Welcome to the DB2 User Group - Central Pennsylvania list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG Listserv FAQ is at The DB2 User Group - Central PA List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at