September 15, 2016

Old Sturbridge Village, 1 Old Sturbridge Village Road, Sturbridge, MA 01566
Sponsored By: 
Compuware
Agenda: 
9:00
Opening Remarks
9:15
DB2 Performance & Tuning – It’s All About The SQL!
10:30
Break
10:45
Connecting DB2 for z/OS Applications, Including Mobile and Cloud, with Data on z Systems
12:00
Lunch
1:00
V11 DB2 Utilities Update
2:15
Break
2:30
Solving an Intermittent Production Problem Using DB2 for z/OS System Profile Monitoring
3:45
Wrap Up
Abstracts and Biographies: 
 
DB2 Performance & Tuning – It’s All About The SQL!

Mike Wingfield - Compuware Corporation

Abstract:

Mainframe Application Performance Management is more imperative today with processor speeds approaching the 7 GHZ limit.  Throwing hardware at performance issues is not enough anymore.  Application response
times and runtimes need to be tuned to run as efficiently as possible and often times when it’s DB2 in the application, most of the performance opportunities will be found there.  Various CICS, Batch, and DDF DB2 Version 10 tuning opportunities will be examined; analyzing SQL Text, DB2 Access Paths, and the DB2 Catalog Objects involved.
* What on Mainframe Applications are Using CPU and Causing Wait
* Analyzing Online and DDF SQL for Optimal Response Times
* Investigating DB2 Batch Jobs to Reduce Overall Runtimes
* Exploring Access Path Efficiency by Examining the Explain
* Scrutinizing Information Contained in the DB2 Catalog

Bio:

Mike Wingfield has been in IT for over 40 years and has been working with DB2 since Version 1.1 in 1987 as a programmer, DBA, Tech Support, Data Modeler, Data Architect, and for the last 25 years as a DB2 Performance and Tuning Specialist. Mike has been utilizing Strobe since 1991 and has documented mainframe operating cost savings of over 50 million dollars using Strobe from 1994 through 2001. Mike retired from U S WEST (which became Qwest Communications and now Century Link) after 30 years of service. As a Strobe Solution Consultant for the last 12 years in Compuware’s Field Technical Support, Mike takes part in Application Performance Assessments for many Strobe customers throughout North & South America, Asia/Pacific, and Europe analyzing Batch, Onlines, Stored Procedures, and DDF performance with Strobe and iStrobe and providing recommendations for runtime and response time improvements.

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

Connecting DB2 for z/OS Applications, Including Mobile and Cloud, with Data on z Systems

Paul Wirth & John Iczkovits - IBM

Abstract:

Although z Systems provides unmatched scalability, security and availability for valuable data, applications have to be able to get to that data. Applications also must be able to access the data from a variety of front-end layers, including cloud and mobile. In this session, you learn about new options for connecting to z Systems -based data, including z/OS Connect. You also learn about new ways to manage connections to a DB2 for z/OS system for enhanced performance and control.

Bio:

Paul Wirth is a Senior Data Management Technical Professional with IBM Corporation located in Maryland, and has been involved in database administration and storage management for over twenty five years.  Over the years Paul has worked in database administration with IMS, DB2, Oracle and Microsoft SQL Server.  He has also worked and extensively with enterprise storage subsystems for both Open Systems and z/OS.  Recent assignments included supporting IBM's data governance products that manage test data and archiving of data, and currently is working on the z Systems Growth Technical Sales team.   Paul is an IBM Certified Database Administrator for: IMS, DB2 for z/OS and DB2 Linux, UNIX and Windows.

John Iczkovits is a Senior IT Specialist with IBM Advanced Technical Support. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has 34 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, trade magazine articles, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, Insight Conference, zEXPO Conference, IBM System z Technical Symposium, Edge, CMG, IDUG, InterConnect, and at local DB2 users groups.

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

V11 DB2 Utilities Update

Craig Friske - IBM

Abstract:

DB2 for z/OS V11 is another release filled with enhancements for DB2 utilities. This presentation covers utility enhancements which improve the use, availability, and performance of individual utilities in V11.

Bio:

Craig Friske has over 2 decades of development experience working on DB2 for z/OS at the Silicon Valley Lab. He has worked on numerous utility projects  including statistics gathering enhancements, partition independence, data compression, and online utilities. He has also led the development of several large availability enhancements in the area of Online Schema Evolution.

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

Solving an Intermittent Production Problem Using DB2 for z/OS System Profile Monitoring

Mark Rader - IBM

Abstract:

Learn how a client using DB2 for z/OS solved a production problem by deploying System Profile Monitoring.  A runaway distributed application had caused significant impact to the DB2 production environment. System Profile Monitoring allowed the client to manage the distributed threads and ensure the main DB2 environment was unaffected. System Profile Monitoring provides a variety of exciting capabilities: ZPARMs at a more granular level than the subsystem, modeling the production environment in a test environment, SQL optimization choices, and setting special registers for distributed threads - all available via online changes.

Bio:

Mark Rader is a Senior Consulting IT Specialist with IBM working with DB2 for z/OS clients. He has over 32 years of technical experience with IBM, primarily with DB2 for z/OS.  He focuses on data sharing, performance, availability, distributed client access to DB2 for z/OS and DB2 and WLM interaction.  He has led many DB2 data sharing implementations and has presented a variety of topics at Insight (IOD), Enterprise (now Edge), IDUG and SHARE conferences and at regional user group meetings. He has worked closely with DB2 development in delivering the Early Support Programs for DB2 10, DB2 11 and DB2 12.  He is an author of redbooks on Parallel Sysplex application considerations, DB2 data sharing, and DB2 for z/OS distributed function.