June 16, 2016

Old Sturbridge Village, 1 Old Sturbridge Village Road, Sturbridge, MA 01566
Sponsored By: 
IBM
Agenda: 
9:00
Opening Remarks
9:15
Using DB2 Performance Analytics To Accelerate Business Operations In The New Application Economy
10:30
Break
10:45
DB2 Version 11.1 - A Packaging and Technology Overview
12:00
Lunch
1:00
Benefits of Apache Spark on Z Systems
2:15
Break
2:30
SQL for the 21st Century: Overlooked Enhancements
3:45
Wrap Up
Abstracts and Biographies: 

Using DB2 Performance Analytics To Accelerate Business Operations In The New  Application Economy

Jim Endler - CA

Abstract:

Proactive database management helps in controlling risks, preventing downtime,  reducing processing costs, and effectively doing more with  less IT staff and resources. DB2 DBAs need analytics to identify potential issues and trigger actions before they disrupt  operations. Attend this session to learn how Performance  analytics can benefit you and maximize your application  performance running on DB2.

Bio:

Jim Endler has over 30 years of industry experience, which includes customer management, pre and post technical sales, management of the development life cycle, from market requirements through release to manufacturing. Experience in establishing product direction, as well as project and personnel management. Technical background includes database and application configuration, administration, recovery and performance tuning. As well as a system programmer supporting various IBM operating systems, CICS and DB2 z/OS.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

DB2 Version 11.1 - A Packaging and Technology Overview

George Baklarz

Abstract:

DB2 Version 11.1 for Linux,UNIX, and Windows was announced on April 12th. While there has been plenty of activity in the cloud, we've also been busy enhancing our on-premise database technology. This session will discuss the new enhancements in DB2 V11, including BLU (Columnar) support on DPF, pureScale enhancements including full HADR support, added SQL capability (too many to mention!) and some packaging changesthat you need to be aware of.

Bio:

George Baklarz, B. Math, M. Sc, Ph.D. Eng., has spent 30 years in IBM working on various aspects of database technology (it seems longer, trust me). He has worked in every department in the Toronto DB2 Development lab and generally can't keep a job for more than 18 months. George is part of the worldwide Core Database Technical Sales group and creates powerpoint slides for a living.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Benefits of Apache Spark on Z Systems

George Wang - IBM

Abstract:

This sessions covers the key enhancements of DB2 for z/OS Version 12 and explains how DB2 can be used in conjunction with Apache Spark to address complex analytical challenges. We will show how to reuse existing data assets from DB2, CICS, IMS, VSAM and multiple other data sources with today available components but also provide an outlook on upcoming enhancements and optimization. The session will conclude with a real customer example, how Spark and DB2 are used together for large scale XML processing.

Bio:

George Wang is a software engineer at IBM DB2 for z/OS Development from Silicon Valley Lab in California. He is the technical lab advocate and Spark liaison for large banking customers on z system. His technical expertise focuses in architecture design of  core system engine components for developing high availability features and providing solutions for warehouse applications in support of high volume online transactional database processing. He also focuses to enable the integration of analytics with transactional environments with the adoption of Apache Spark for z systems for advanced analytics capability on z data.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SQL for the 21st Century: Overlooked Enhancements

David Simpson - Themis

Abstract:

Are you still coding like it's the 90s? This session will cover some overlooked SQL enhancements in the latest releases of DB2 with a special focus on features that have been most useful in real DB2 environments.

Technical areas this presentation will apply to: SQL and XML Features, SQL and XML Performance

Objective 1: Advanced Grouping and Aggregation

Objective 2: Online Analytical Processing (OLAP) Built-in Functions

Objective 3: Table Expressions and Recursion

Objective 4: Merge Statement

Objective 5: SELECT FROM INSERT/UPDATE/DELETE/MERGE

Bio:

David Simpson is currently a Senior Technical Advisor at Themis Inc. He teaches courses on SQL, Application Programming, Database Administration as well as optimization, performance and tuning. He also installs and maintains the database systems used for training at Themis. Since 1993 David has worked as a developer and DBA in support of very large transactional and business intelligence systems. 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 and is a member of the IDUG Speakers Hall of Fame.