Central PA DB2 User Group -September 8th, 2011 - FREE EVENT & Giveaways! - SIGN UP by September

Lori Ann Galluzzo

Central PA DB2 User Group -September 8th, 2011 - FREE EVENT & Giveaways! - SIGN UP by September
Central PA Regional DB2 User Group

Date: Thursday September 8th, 2011
Place: Giant Super Food Store Community Room, 3301 Trindle Rd , Camp Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen - [login to unmask email]<mailto:[login to unmask email]>

Agenda for September 8th, 2011

8:30-9:00 Breakfast & Announcements
Sponsored By: SoftBase Systems


9:00-10:15 "DB2 10 for zOS Temporal Technology"
Presenter: Paul Wirth, IBM Corporation.
This presentation will discuss DB2 10 for zOS Temporal Technology. Temporal Technology uses a temporal table (a table that records the period of time when a row is valid). This translates to columns being added to application table to track a system period (SYSTEM_TIME) and application period (BUSINESS_TIME).
10:15-10:30 Break

10:30-11:45 "What's new for DB2 Clients and Drivers?"
Presenter: Paul Wirth, IBM Corporation.
IBM's strategy is to remove the reliance on the DB2 Connect Gateways and replace DB2 Connect with the IBM Data Server Drivers or Clients. While DB2 Connect licenses (in the form of DB2 Connect license files) are still required, you can replace DB2 Connect Gateways with the IBM Data Server Drivers or Clients and receive equivalent or superior function. In addition, you can reduce complexity, improve performance, and deploy application solutions with smaller footprints for your business users. IBM has also simplified the configuration of clients and drivers by replacing the database directory with a single XML configuration file. The purpose of this presentation is to review changes and enhancements in creating connections to IBM's relational databases. It is for Architects, Database Administrators, DB2 Connect Support Staff and Developers.

11:45 -12:15 Lunch - Sponsored By: SoftBase Systems.


12:15-1:00 - Lunch/Learn - with SoftBase Systems - Presenter : Mike Arnold, Product Developer & Scott Garrett - Director of Sales, SoftBase Systems
In addition to a quick overview of the SoftBase Systems product set, Mike will discuss ways in which the SoftBase Batch Health Care Facilities can help to quickly pinpoint and correct performance problems in your batch SQL. The Batch Analyzer product can provide hot-spot SQL identification without the need for trace or log analysis. It's very low overhead allows data to be collected continuously with minimal impact to a running system, providing performance data seconds after job completion. The ease of use and low overhead combine to make a product that can be used on application development as well as production LPARS, giving each programmer the ability to quickly see the impact of SQL changes. Mike will also discuss how the other Batch Health Care Facilities can be used to solve some of the most common coding problems.

1:00-1:15 Break & Drawings - IDUG - T-shirts (2) & PC Bag; SoftBase - 2 - $50 Best Buy Gift cards,
+ Giveaways for all in Attendance- IBM has sent DB2 10 for z/OS - Cost Savings...Right out of the Box - book for all attendees - value 19.95 - 94 pages

1:15-2:45 "DB2 Accounting 101 - Performance Details for the Application Developer"
Presenter: Randy Ebersole, IBM Corporation.
This presentation will cover the Accounting related reports that provide a view of performance from an application perspective.

We'll discuss how the statistics from the Accounting reports can be interpreted into evaluating performance. We'll also discuss what the possible DB2 tuning choices are for various situations.

2:45-3:00 Break

3:00-3:45 - Question Panel - with Randy Ebersole, IBM Corporation; Paul Wirth, IBM Corporation, Stan Goodwin, IBM Corporation; Moderator - Lori Galluzzo, HP Enterprise Services.
3:45-4:00 Closing

IF YOU WANT TO SUBMIT A QUESTION FOR THE PANEL - AHEAD OF THE DAY :
EMAIL TO [login to unmask email]<mailto:[login to unmask email]> - your question and if it is platform specific

Lori Ann Galluzzo
Office of Strategy & Technology / Business Solutions
Svc Info Developer III - Metavance DBA

+1 717 975 5482 / Office
+1 717 215 0587 / Mobile
[login to unmask email]<mailto:[login to unmask email]> / Email
Camphill, PA, USA

IBM Certified Database Administrator - DB2 10 for z/OS
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified Database Administrator - DB2 9 for z/OS