Central PA RUG Meeting Dec 8, 2010

Philip Gunning

Central PA RUG Meeting Dec 8, 2010
Come join us for the upcoming RUG meeting sponsored by Gunning Technology
Solutions, LLC. Cheers, Phil


Central PA Regional DB2 User Group

Date: Wednesday, December 8th, 2010

Place: Giant Super Food Store Community Room, 3301 Trindle Rd , Camp Hill,
PA 17011

Cost: FREE

Reservations: Email: Odessa Fennen - <mailto:[login to unmask email]>
[login to unmask email] This e-mail address is being protected from spambots.
You need JavaScript enabled to view it

Agenda for December 8, 2010

8:30-9:00 Breakfast & Announcements

Sponsored By: Gunning Technology Solutions, LLC.

09:00-10:10 "Top 10 DBA and Application Features of DB2 10 for z/OS"

Presenter: Randy Ebersole, IBM Corporation

This presentation will discuss DB2 10 features that are specific to DBAs and
application development.

We'll discuss the variety of new features in DB2 10 and how they can help
the everyday life of the DBA and DB2 application developer.

10:10-10:25 Break

10:25- 11:45 " HADR Implementation with 9.7 Enhancements"

Presenter: Phil Gunning, Gunning Technology Solutions, LLC.

Attend this session to learn how to Implement DB2's flagship High
Availability and Disaster Recovery (HADR) feature. This presentation will
cover HADR overview, architecture, design and implementation. This
presentation will cover new HADR features in DB2 9.7 to include
hadr_peer_window and Read-only on the Standby. An implementation checklist
will be provided to attendees. MSCS clustering and HADR will be covered.

11:45-12:45 Networking Lunch /Drawings - Sponsored By: Gunning Technology
Solutions, LLC.

12:45-2:00 "DB2 Questioning-the-Experts SIG"

Presenter: Randy Ebersole, IBM Corporation;

Stan Goodwin, IBM Corporation;

Dave Beulke, Dave Beulke & Associates - Division of Pragmatic Solutions;

Phil Gunning, Gunning Technology Solutions, LLC

Organizer : Lori Galluzzo, HP Enterprise Services

Our discussion will an open forum question session with DB2 area experts
involving both platforms (z/OS & LUW). Attendees can submit questions prior
to the event, the day of event or ask during the session.

Send any questions prior to the event in an email to '
<mailto:[login to unmask email]> [login to unmask email] This e-mail address is
being protected from spambots. You need JavaScript enabled to view it - with
subject - 12/8/10 - Questions for DB2 Panel ; Body of email - stating the
platform if any, and the question" . See the example at the end of this

2:00-2:15 Break

2:15-3:55 "Database Performance Discoveries and Recommendations"

Presenter: Dave Beulke, Dave Beulke & Associates - Division of Pragmatic

Database Performance Discoveries and Recommendations -by Dave Beulke Is your
database application experiencing poor response time, scalability problems,
and too many deadlocks or poor application performance? One or a
combination of zParms, database design and application coding techniques can
cause these performance issues.

There are many new DB2 9 and DB2 10 techniques, system parameters, database
design, and application coding methods to avoid problems and revitalized
your older databases' performance. This presentation will take you through
the discoveries found during recent performance reviews and you will learn
about the latest recommendations for fixing your database and application
performance problems.

Understand the database design techniques with the PBG tablespaces

Learn about the latest zParms and the optimum settings for OLTP or DW BI

Learn the latest coding considerations and techniques for Java and .NET

Find out the latest recommendations for application performance coding

Understand the latest consideration and recommendations for efficient setup
and maintenance of your tablespaces and indexes.

3:55-4:10 Closing

Next day class reminder :

DB2 10 Training and Performance on December 9, 2010 - fee based class ( COST
: $250 ahead of time/$300 the day of) - sign up on Dave Beulke's website :

Example of Questioning-the-Experts email :

12/8/10 - Questions for DB2 Panel - subject line of email

Platform : z/OS _X_ LUW ___

Question : In DB2 9 - Have you ever seen any issue with using index
compression - effecting items like cluster ratio, index overhead or

* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv