I was finally able to confirm all the speakers for the LUW track at the December meeting and – wow! – here’s the lineup summary:  Curt Cotner and Paul Westfall from IBM, and the BWDB2UG board’s own Steve Rosenberger from FEPOC doing a user case study on their archiving implementation.  If you are in the area on Wednesday, December 9th, PLEASE join us – it should be great…the z/OS track includes Rick Weaver from BMC and Roger Miller.  Great presenters and great networking.  Hope to see you!  The full agenda is included after the jump and all the registration and PayPal access is through our (new) website at: www.bwdb2ug.org.

Baltimore/Washington DB2 Users Group
December Meeting, 12/9

***DB2 for LUW Track Agenda*** 
The Baltimore/Washington DB2 Users’ Group
Meeting Schedule for December 9, 2009 (Wednesday)

When?
                Wednesday, December 9, 2009
                9:00 AM-3:30 PM
                (Registration at 8:30 AM)

Where?
                Sheraton Columbia, 10207 Wincopin Circle
                Columbia, MD  (410) 730-3900

Meeting Fees (please note changes):
                Pre-registered members                             $30
                Pre-registered non-members                     $40
                At-the-door for members                            $40
                At-the-door for non-members                    $50

To pre-register, please mail the appropriate fee with attendee’s and employer’s name to:

 THE BALTIMORE/WASHINGTON
 DB2 USERS’ GROUP
 P.O. BOX 18554
 BWI AIRPORT, MARYLAND 21240

 All pre-registrations must be received by
 Friday, December 4, 2009.  Make checks payable to the
 Baltimore/ Washington DB2 Users’ Group or use the PAYPAL link on website
               
Visit our *new* website, www.bwdb2ug.org, for more information.
 
Baltimore/Washington DB2 Users’ Group Meeting

Date:                      December 9, 2009 (Wednesday)
Location:                Sheraton Columbia, 10207 Wincopin Circle, Columbia, MD
                                (410) 730-3900
 
DB2 for LUW Track Agenda:

8:30 – 9:00           Registration

9:00 – 10:15        “Scaling OLTP Applications on DB2 for LUW with Clustering Technology”
Paul Westfall, IBM
Abstract:  Organizations running online transaction processing (OLTP) applications on distributed systems that require high availability can now utilize cluster technology similar to DB2 for z/OS shared-disk storage that enables multiple nodes to operate against a single physical database. This delivers scalability, high-availability and the ability to load balance.  This presentation will explain in detail how it works and how it compares with other high availability solutions available for DB2 for LUW.

10:15 – 10:30       Coffee Break

10:30 – 11:45       “Revolutionizing the Data Abstraction Layer”
Curt Cotner, IBM
Abstract:  Looking for a more flexible and efficient way for Java programs to access the database? Join us as we explore how you can bridge the gap between Java and relational databases. Enhance your Java environment with access layer generation, data access best practices, traceability between Java packages and SQL statements, improved impact analysis, and more. And most importantly, see how new technology can improve not only new development, but existing applications as well.

11:45 – 12:45       Lunch
                               
12:45 – 2:00        “Case Study:  Implementing an Archiving Solution”
Steve Rosenberger, FEPOC
Abstract: In this presentation Baltimore/Washington DB2 Users Group Board Member Steve Rosenberger will present a case study on his organization’s implementation of an archiving solution.  The Service Benefit Plan Administrative Services Corporation (SBPASC), aka Federal Employee Program Operations Center (FEPOC), a subsidiary of CareFirst BCBS, implemented an archiving solution for their claims DB2 database.  Steve will review the factors considered prior to implementation of garcinia cambogia, the implementation plan and process followed, and suggestions for other organizations considering an archiving solution.
                               
2:00 – 2:15            Break

2:15 – 3:30         “Accelerating Solution Delivery for Data-Driven Applications”
Curt Cotner, IBM
Abstract:  Accelerate your existing Java applications, leverage static SQL, reduce cost, and gain insight, reliable performance, problem determination, and control over which SQL is issued from where in your Java applications. Whether your application uses Java Database Connectivity (JDBC), the Java Persistence API (JPA), Hibernate, Spring or IBatis, existing programs can be improved without changing the code.
                         
The presenters:
Paul Westfall, IBM
Paul Westfall has been an Information Management Specialist with IBM for over 13 years,  helping customers along the east coast implement IBM’s data management solutions.  He has worked with every distributed release of DB2 for Linux, Unix and Windows,  and has recently been focused on data warehousing, XML, and information integration.
                                

Curt Cotner, IBM
Curt Cotner Vice President & Chief Technology Officer for Database Servers
Curt Cotner is an IBM Fellow, and a member of the IBM Academy of Technology. Curt is the chief technology officer for the DB2 family and Informix IDS database servers, and has both management and technology oversight responsibility for all the client software offerings used with DB2 and IDS. This includes the client runtime APIs (JDBC, .NET, CLI, pureQuery, etc.) and the application development and administration tools offerings (IBM Data Studio). Prior to taking his current assignment, Curt was the chief architect for the DB2 for z/OS development team.

Steve Rosenberger, FEPOC

Steve has nearly 30 years of Information Technology experience in the healthcare industry. His career began in applications, coding COBOL and Assembler Language programs. He held positions in CICS Systems Programming, Database Administration and finally in management. He has been responsible for Change Management, Disaster Recovery and Business Continuity Services and most recently Data Management. In his current role he is responsible for database administration, data architecture and everything data. Core systems execute in a multi-platform environment consisting of z/OS, UNIX and Windows while data warehousing systems operate on the UNIX platform. He enjoys just about any outdoor activity and ‘relaxes’ maintaining his small farm and creating gardens for his wife in Northwestern Virginia.

DB2 for z/OS Track:

8:30 – 9:00            Registration

9:00 – 10:15         A Row’s Life
Rick Weaver, BMC Software
Abstract – Rows in a DB2 z/OS database get mauled and moved and wholly and partially duplicated.  There are different ways to find them and different surroundings. And most DBAs find they need to understand these transformations thoroughly to manage performance and recovery and even security.

In this presentation, we take a lighthearted view of one row’s life to emphasize some of the internals of DB2 on the z/Os platform including impact of basic DML, Utility implications, and how various DB2 features (e.g. compression) impact the appearance of the row. 
 
Session Objectives:

•         Have a high level understanding of the physical incarnation of data within a DB2 tablespace, log, and other resources.
•         See the impact of some data definition choices on the physical structure of a row.
•         See some differences DB2 Version 9 will introduce to row format and versioning.
•         Understand how the artifacts discussed can be used for recovery and other purposes.
•         Piqued interest in learning more details about physical page layout and logging within DB2.

10:15 – 10:30       Coffee Break

10:30 – 11:45       Audit your SOX off…

Rick Weaver, BMC Software
Abstract – We will discuss methods of using a DB2 log processing tool to accomplish the auditing requirements mandated in your environment. Discussion and examples will be included to show how to monitor power users (e.g. SYSADMs), track changes in authorizations and underlying structures, look for updates to sensitive columns and more. The additional uses of a DB2 log tool will also be covered to show how they can be used for transaction level recovery, data migration, adhoc and regular reporting, and for problem diagnosis. This presentation is vendor neutral, but Log Master for DB2 will be used in the examples. 
Session Objectives:
•         Learn about log processing concepts with a brief overview                
•         Discussion and Examples of Audit compliance reporting 
•         Examples of how log based reporting can be used for problems diagnosis 
•         Transaction Level Recovery using a log tool 
•         Migration to a data warehouse, test system, or wherever you need

11:45 – 12:45       Lunch sponsored by BMC
                               
12:45 – 2:00        DB2 for z/OS Selected Performance Topics 
Roger Miller, IBM
This session will present some of the latest challenges and achievements for DB2 performance, noting some recent measurements and what can be achieved with the latest software and the latest hardware. The discussion will be centered on what you can do to help improve performance in your shop, particularly on the items that can help in DB2 9.
                               
2:00 – 2:15            Break

2:15 – 3:30            Ask the developer (questions and answers)
Roger Miller, IBM
Open discussion (questions and answer). Attendees will be able to ask this key DB2 developer all their burning questions!
 
The presenters:

Rick Weaver 
Rick Weaver has over 30 years of experience in Systems and Database Administration for IMS and DB2 database systems, and has been involved in developing large, complex, mission critical applications in a variety of business areas. At BMC since 1994, Rick has worked in Software Consulting, Professional Services,
Product Marketing, and Product Management.   Rick is currently Product Manager for DB2 Solutions, responsible for setting product direction and managing release requirements for the BMC Software DB2 for z/OS product line. 
                                
Roger Miller
DB2 for z/OS technical evangelist, strategist, architect, designer, developer, writer, service, DB2 factotum (from the Latin for does everything or jack of all DB2 trades, master of several). Roger’s current projects include working to roll out DB2 9 for z/OS, and to design the next improvements in DB2. Roger’s technical accomplishments include being a DB2 for z/OS technical evangelist, architect and designer working on many facets of DB2, ranging from overall design issues to SQL, languages, install, security, audit, standards, performance, concurrency, and availability. He has worked for 30 years on DB2 development, product design and strategy. He often helps customers to use the product, answers many questions and presents frequently to user groups. B.S. Mathematics, Stanford University,
M.S. Quantitative Methods of Business, U.C.L.A.  Fun facts – Roger likes hiking, bicycling, music, reading, Shakespeare, Yosemite and bears.  He has learned to like working out with a personal trainer.