LAADB2UG Quarterly Meeting

December 1 & 2, 2011

New ˝ day format in the middle of the day at 2 locations!

Fees:  FREE!                          

            RSVP by Nov 29th to reserve a seat and lunch

To RSVP: JaniceBies@laadb2ug.org

Please include which session you wish to attend and the names of attendees

Thursday, December 1, 2011
10:00am - 2:00pm

Friday, December 2, 2011
10:00am - 2:00pm

IBM Office
3565 Harbor Blvd, Room 254 (2nd Floor)
Costa Mesa, CA 92626

Computer Associates    
6100 Center Drive, Suite 700

Los Angeles, CA 90045

Parking - Free

Parking - Free

10:00am - 11:30am:  David Simpson - DB2 SQL PL Stored Procedures:  User Experiences in Implementation

10:00am - 11:30am:  David Simpson - DB2 SQL PL Stored Procedures:  User Experiences in Implementation

11:30am – 12:30pm:  Free Lunch hosted by IBM

11:30am – 12:30pm:  Free Lunch hosted by LAADB2UG

12:30pm - 2:00pm:  David Simpson – SQL for the 21st Century:  Overlooked Enhancements

12:30pm - 2:00pm:  David Simpson – SQL for the 21st Century:  Overlooked Enhancements


Speaker: 

David Simpson, Themis Inc.

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 ‘big data’ DB2 databases in excess of 10 terabytes.  David has worked with DB2 for 18 years as an application developer, DBA and technical instructor.  He is a frequent speaker at user groups and IDUG.  David was voted Best Overall Speaker at IDUG North America 2006 and Best User Speaker at IDUG Europe 2006.

Presentations:

DB2 SQL PL Stored Procedures:  User Experiences in Implementation - SQL Procedure Language (SQL PL) procedures have proven to be an invaluable tool for mid-tier developers on both DB2 LUW and z/OS particularly for those with little z/OS experience. DB2 for z/OS introduced Native SQL Procedures are quick and easy to develop, test, and debug.  They perform well and with a little forethought are easy to deploy across environments. This presentation takes a look at SQL PL Procedures development Lifecycle and our client experiences in implementation. We will discuss SQL PL’s strengths and limitations, best practices, interfacing with existing change management tools and the latest enhancements. We will also look at the role of IBM Data Studio in the development life cycle.

SQL for the 21st Century:  Overlooked Enhancements - Are you still coding SQL from the 90s?  This presentation focuses on SQL enhancements in the last few releases of DB2 that can greatly simplify coding and help you solve complex business problems using the power of SQL.  A special emphasis is placed on features that have been most helpful to our clients in real world situations.