Change of Location for Central PA Regional User Group on 3/28... Central Pennsylvania College

Lori A Galluzzo

Change of Location for Central PA Regional User Group on 3/28... Central Pennsylvania College

Central PA Regional DB2 User Group

Date: Wednesday, March 28th,2007
Place: CENTRAL PENNSYLVANIA COLLEGE - THIS IS A CHANGED LOCATION - SEE BELOW!
Cost: FREE
Reservations: Email or call: [login to unmask email] (717) 302-3991
For details and directions: See http://www.db2parug.org

Agenda for March 28, 2007

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!


The location is.... Central Pennsylvania College in Summerdale.

Please allow yourself enough time to arrive.

We have moved the meeting to the Central Pennsylvania College in
Summerdale. We will be in the ATECH Building on the corner of
Valley Road and B Street. Please park across the street in the
parking lot. When you go in the building, there is a
receptionist. If the receptionist is not there, you will be
going down the steps. If my directions below are not what you
need, you can get a map on Yahoo or search the internet for
Central Pennsylvania College.

All the times are the same - meaning Breakfast is at 8:00. See
you there!

Directions (detailed directions below):

To get to the campus take I-81 to exit 65. Go South one half mile
from the exit on Routes 11/15. Turn right at the traffic light
onto Valley Road. Travel a half mile or so. Central Penn is on
the left, large building by the flag pole. Visitors may park in
front of the building via a left turn at the adjoining traffic
light on B Street or across the street from this location.

Written directions below:


FROM THE EAST - Take I-76 West (PA Turnpike) get off at Exit 247 (Harrisburg East). Take center
lane to I-83 North toward Hazleton/ Lewistown. Follow signs to I-81. Take I-81 South toward
Carlisle. Take Exit 65 (Enola) onto Routes 11/15 South (Enola). From Routes 11/15 travel one
half mile and turn right at the traffic light onto Valley Road. Travel a half mile or so over
the hill. Central Penn is on the left.
OR
Take I-78 West. This road will merge with I-81 South. Stay on I-81 South and take Exit 65
(Enola). Travel about one half mile and turn right at the traffic light onto Valley Road.
Travel a half mile or so over the hill. Central Penn is on the left.


FROM THE NORTH - Take Routes 11/15 South or I-81 South to Exit 65 (Enola) onto Routes 11/15
South. About one half mile south of I-81, turn right at the traffic light onto Valley Road.
Travel a half mile or so over the hill. Central Penn is on the left.


FROM THE SOUTH - Take I-83 North to Rt. 581 West (Exit 41A). Follow Rt. 581 West to I-81 North (Exit 1A). Take I-81 to Exit 65 (Enola) to Routes 11/15 South. Go one half mile and turn right at the traffic light onto Valley Road. Travel a half mile or so over the hill. Central Penn is
on the left.
Or
Take Rt. 15 to Rt. 581 West. Follow Rt. 581 West to I-81 North (Exit 1A). Take I-81 to Exit 65
(Enola) to Routes 11/15 South. Go one half mile and turn right onto Valley Road. Travel a half
mile or so over the hill. Central Penn is on the left.
Or
Take I-81 North to Exit 65 (Enola). Take Routes 11/15 South one half mile and turn right at the traffic light onto Valley Road. Travel a half mile or so over the hill. Central Penn is on the
left.


FROM THE WEST - Take I-76 East (PA Turnpike) to Exit 226 (Carlisle). Go north on I-81 to Exit
65 (Enola) onto Routes 11/15 South. Go one half mile and turn right at the traffic light onto
Valley Road. Travel a half mile or so over the hill. Central Penn is on the left.



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 http://www.idugdb2-l.org/archives/DB2-UG-Central-PA.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Central PA List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm