Fwd: Re: Central PA Regional DB2 User Group = Wed. June 25th 2008 - save the date! UPDATED AGENDA

Tom Fennell

Fwd: Re: Central PA Regional DB2 User Group = Wed. June 25th 2008 - save the date! UPDATED AGENDA
Please unscribe me, too.

Thanks,
Tom

"Wolf, James L CIV NAVSISA" <[login to unmask email]> wrote: Date: Thu, 15 May 2008 06:15:02 -0400
From: "Wolf, James L CIV NAVSISA" <[login to unmask email]>
Subject: Re: Central PA Regional DB2 User Group = Wed. June 25th 2008 - save the date! UPDATED AGENDA
To: [login to unmask email]

I'm trying to unscribe but your web site,
http://www.idugdb2-l.org/archives/DB2-UG-Central-PA.html cannot be
found. Please unscribe me.

Thanks,
Jim Wolf

-----Original Message-----
From: DB2 User Group - Central PA
[mailto:[login to unmask email] On Behalf Of Brian Charles
Sent: Wednesday, May 14, 2008 15:19
To: [login to unmask email]
Subject: Re: Central PA Regional DB2 User Group = Wed. June 25th 2008 -
save the date! UPDATED AGENDA

Uh, can we please stop responding to the forum...

-----Original Message-----
From: DB2 User Group - Central PA
[mailto:[login to unmask email] On Behalf Of H r Orth
Sent: Wednesday, May 14, 2008 2:10 PM
To: [login to unmask email]
Subject: Re: Central PA Regional DB2 User Group = Wed. June 25th 2008 -
save the date! UPDATED AGENDA

I will plan to attend.




Have a great day.

Richard Orth
Advisory IT Specialist
IBM Business Services
DBA Solution Center of Excellence
40 Bobby Jones Dr.
Etters, Pa. 17319-9515
email: [login to unmask email]
phone: 717-441-6222
tie line: 273-7128







"Galluzzo, Lori
A"

To
S.COM>
[login to unmask email]
Sent by: DB2 User
cc
Group - Central
PA
Subject

[login to unmask email]> Group = Wed. June 25th 2008 -
save
the date! UPDATED AGENDA

05/12/2008 04:05
PM


Please respond to
DB2 User Group -
Central
Pennsylvania

[login to unmask email]
rg>









Central PA Regional DB2 User Group


Date: Wednesday, June 25th, 2008
Place: Giant Super Food Store Community Room,
Cost: FREE
Reservations: Email or call: Odessa Fennen -
[login to unmask email]


Agenda for June 25th, 2008
8:00-9:00 Breakfast & Announcements


Sponsored By: Softbase Systems


9:00-10:10 "What's My Java App Called Your COBOL DB2 Stored
Procedure"


Presenter: John Mallonee, Highmark Corporation
See the experiences of Java Development team
that
the guts to call DB2 for z/OS stored procedures
written in COBOL. See how the application was
developed, challenges faced ranging from
Workload
Manager to developer diversity, and tips for
support. Java experience is preferred, but not
a
must. This new presentation is from IDUG NA
2008
conference in Dallas, TX. Objectives :


Objective 1: Learn why & where a COBOL stored procedure
makes
sense for Java applications.
Objective 2: Learn the basics of building a COBOL stored
procedure.
Objective 3: Learn the basics of calling a DB2 stored
procedure
from a Java application.
Objective 4: Understand the potential challenges.
Objective 5: Develop a methodology for ongoing support.

10:10-10:25 Break


10:25-11:35 "More Batch, Less Time"


Presenter: Troy Coleman, Softbase Corporation
More Batch, Less Time takes a look at the art of
tuning batch applications and why batch is
different than tuning online systems. We will
take
a look at design considerations to reduce elapse
time, CPU and I/O. We will also look at some of
the tools needed for tuning effort and how
tuning
is a team effort between application
development,
DBA, storage, and systems management. We will
wrap
up with some how to topics such as locate
expensive
or long running SQL; identify and eliminate
contention problems; improve batch throughput,
and
develop safe and predictable recovery position
for
all DB2 production batch jobs.


11:35-12:15 Lunch


Sponsored By: Softbase Systems


12:15-12:45 Lunch & Learn Demo - Batch Analyzer with Softbase
Corporation!


Presenter: Softbase Systems


Softbase Systems has a tool - Batch Analyzer
that
is used to analyze your system for potential
performance tuning points from contentions,
deadlocks to finding troublesome SQL statements.


12:45-1:00 Break


1:00 - 2:00 "Top Impacts on Application Performance! - Part 1"
Presenter: Sheryl Larsen, Sheryl M. Larsen Inc.
The past twenty years of DB2 has offered us many ways to architect
an application. SOA, web services, and the like, have changed our
thinking, but has SQL performance improved? Come find out what DB2
features impact response time, throughput, peak response time, hits, and
sessions per second for the better, and for the worse. This session is
packed with performance hints and tips and even contains material about
DB2 versions yet to be released.


Things that Impact Application Speed


Query Vs. Prog.
4K Page Processing
Order of Index Columns - z/OS
Order of Index Columns - LUW


Variations of Index Access


DB2 z/OS Favorite Access: List Prefetch
DB2 z/OS Favorite Join: Nested Loop Join


DB2 LUW Favorite Access: Table Scan
DB2 LUW Favorite Join:Hash Join
Other System Impacts


Buffer Pool
Total Buffer Pools
Typical Schema &Index Design
Optimal Schema &Index Design
Performance Structure Impacts


Optimal Index Design
Optimal Materialized Query Tables
Application Considerations
Proper Use of SQL Clauses


Over Use of LEFT JOIN
Misuse of GLOBAL TEMP TABLES


2:00 - 2:15 Break
2:15 - 3:15 "Top Impacts on Application Performance! - Part 2"
Presenter: Sheryl Larsen, Sheryl M. Larsen Inc.


3:15-3:45 "Introduction to DB2 Application Tuner's Boot Camp"
Presenter: Sheryl Larsen, Sheryl M. Larsen Inc.
The purpose of the presentation is to introduce to the DB2 Applications
Tuner's Boot Camp Class. It will touch on SQL tuning techniques, access
paths, estimating response time, reading Visual Explain, sample SQL
Tuning case studies, and Optimization Service Center Tutorial. The full
class will be offered the day following the RUG meeting for an
additional fee.
Look for a separate announcement on this class.


3:45-4:00 Closing


Lori Ann Galluzzo
Information Specialist/DBA - IBM DB2 V8.1 Certified Specialist &
Solutions Expert /ASFOA-US


EDS
US Healthcare
MS:C10
225 Grandview Ave.
Camp Hill, PA 17011, USA


Tel: 717-975-5482
Fax: 717-975-4219
Mobile: 717-215-0587
E-mail: [login to unmask email]





We deliver on our commitments
so you can deliver on yours.



_____________________________________________________________________


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

_____________________________________________________________________

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

Disclaimer: This e-mail message is intended only for the personal use of
the recipient(s) named above. If you are not an intended recipient, you
may not review, copy or distribute this message. If you have received
this communication in error, please notify us immediately by e-mail and
delete the original message.

This e-mail expresses views only of the sender, which are not to be
attributed to Rite Aid Corporation and may not be copied or distributed
without this statement.

_____________________________________________________________________

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

_____________________________________________________________________

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



_____________________________________________________________________

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