DELAWARE VALLEY DB2 USERS GROUP

 

 

_____________________________________________________________________________

 

MEETING DATE:       Friday, November 7th 2008

 

LOCATION:                 Dave & Buster’s

STARTING TIME:      9:00 AM

REGISTRATION

and BREAKFAST:    8:30 AM - 9:00 AM

COST:                          ADVANCE REGISTRATION:       MEMBERS $20, NON-MEMBERS $30

                                       WALK IN REGISTRATION:           MEMBERS $50, NON-MEMBERS $60

_____________________________________________________________________________

 

AGENDA

 

09:00 - 09:15                           Opening Remarks

                                                Joe Carola, Chairperson DVDUG

 _____________________________________________________________________________

 

09:15 -10:30                            DB2 9 XML Support: What Can It Do For You? (Part 1)

                                                Gregg Lippa, Themis Inc.

_____________________________________________________________________________

10:30 - 10:45                           BREAK

_____________________________________________________________________________

10:45 - 12:00                           DB2 9 XML Support: What Can It Do For You? (Part 2)

                                                Gregg Lippa, Themis Inc.

_____________________________________________________________________________

12:00 - 01:00                           LUNCH: Sponsored by Themis Inc.

_____________________________________________________________________________

01:00 - 02:15                           SQL Optimization & Access Paths: What’s Old & New (Part 1)

David Simpson, Themis Inc.

_____________________________________________________________________________

02:15 - 02:30                           BREAK

_____________________________________________________________________________

02:30 - 04:00                           SQL Optimization & Access Paths: What’s Old & New (Part 2)

David Simpson, Themis Inc.

 

_____________________________________________________________________________

 

The DELAWARE VALLEY DB2 USERS GROUP reserves the right to change the agenda without notice.

 

Visit our Web Site for the latest information @ www.dvdug.org

Mark your calendars for the next meeting:  March 20, 2009

 

Casual Dress

Message from the chair:

Our agenda for this session will be filled with new DB2 V9 topics from the education experts at Themis, Inc.  Come hear the basics and details on the new features available in the native XML support in V9, and what’s new in V9 Optimization.

 

Joe Carola

 

 

 

 

BOARD OF DIRECTORS

 

Chairperson       Joe Carola                     (610) 219-8328               joseph.carola@siemens.com

 

Vice-Chair         Rachel Murawski            (570) 200-1558               rachel.murawski@bcnepa.com

 

Program            Anne Stout                    (609) 520-5240               anne.stout@dowjones.com

                               

Newsletter         Tom Orner                     (215) 238-6872               tomorner@aim.com

 

Membership      Stan Katinsky                                                    skatinsky@comcast.net

 

Arrangements    Mark Weichman             (856)346-5752               mcweichman@comcast.net

 

Secretary          Mike Piontkowski           (610) 326-9529               michael_piontkowksi@compuserve.com

                       

Treasurer          Denise Walters              (610) 219-6556               denise.walters@siemens.com

                        Bill Saunders                 (215) 625-5892               bill.saunders@attglobal.net

 

Website            Joseph Mako                      (610) 359-6766                   joseph.mako@siemens.com

 

IBM Liaison:      Linda Snow                    (610) 578-2367               lindasnow@us.ibm.com

                        Howie Hirsch                 (732)-926-2362               hshirsch@us.ibm.com

Morning Presentation

 

DB2 9 XML Support: What Can It Do For You?

Gregg Lippa, Themis Inc.

 

DB2 had begun to incorporate XML features prior to DB2 9, but has now become a real leader in XML support. This presentation reviews the basics of XML and XPath expressions, discusses the benefits and uses of XML in a DB2 database, and covers the XML-related features of DB2 9 in detail, including the new XML data type and the DB2 functions that support it, how it is supported in COBOL and Java programming environments, its impact on indexing, and an overview of its support for validation. If you are considering using XML in your DB2 environment, this session will give you an understanding of the potential benefits and pitfalls and a great jumpstart to understanding what is available in DB2.

Speaker:

Gregg Lippa is currently a Senior Technical Advisor at Themis Inc. He teaches DB2-related courses on SQL, Application Programming, and optimization, performance and tuning as well as Java, J2EE, distributed computing and Java-related topics. Gregg has worked with DB2 as a consultant and trainer for over 20 years and with Java for 10 years.

 

 

 

 

Afternoon Presentation

SQL Optimization & Access Paths: What’s Old & New

David Simpson, Themis Inc.

 

Some things with SQL optimization have been the same for a long time. Others change are changing rapidly with the introduction of Version 8 and 9. This presentation reviews the basics of access path analysis with extended discussion of what’s new in the latest releases of DB2. The appropriate place for Visual Explain and Optimization Service Center will also be covered. Let’s talk about what’s old, what’s new and how to make the optimizer work for you.

 

Speaker:

David Simpson is currently a Senior Technical Advisor at Themis Inc. He teaches courses on SQL, Application Programming, DB2 Administration as well as optimization, performance and tuning. He has supported transactional systems that use DB2 for z/OS databases in excess of 10 terabytes. David has worked with DB2 for 15 years as an application programmer, DBA and technical instructor. David is a certified DB2 DBA on both z/OS and LUW. David was voted Best User Speaker and Best Overall Speaker at IDUG North America 2006. He was also voted Best User Speaker at IDUG Europe 2006.