March 28th - Free Central PA DB2 Users Group

Lori A Galluzzo

March 28th - Free Central PA DB2 Users Group

Central PA Regional DB2 User Group

Date: Wednesday, March 28th,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 Mallone, 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

Hope to see you all there!

Lori Ann Galluzzo
IBM DB2 V8.1 Certified Specialist & Solutions Expert
EDS - Healthcare - Metavance Product ADU
( phone: +01-717-975-5482 (8-428)
+ mailto:[login to unmask email]
cell : 717-215-0587

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