Welcome to the MWDUG Website!

Click here to register for the Meeting – March 7, 2019  (Important! the 1st Quarter MWDUG Meeting location has been changed)

The 1st Quarter meeting will be held at:

River Forest Country Club
15W468 Grand Avenue
Elmhurst, IL 60126

 


Walk-ins are welcome for only $35.00 daily fee applicable to a full year membership.

 



MWDUG Headquarters

MWDUG c/o Technical Registration Experts, Inc. (TREX) 
303 West State Street
Geneva, IL 60134  
Phone: 630-578-3991
Fax: 630-262-1520 
E-mail:  mwdug@trexperts.com

New Contact: Jeffrey Miller or Sue Reed
Website: http://www.mwdug.org

 



Meeting Agenda – March 7, 2019

 

  Db2 FOR z/OS TRACK
08:30am - 09:00am Registration – Coffee, juice, soda, and cofee cake
09:00am - 010:15am

Zowe - A new Face for z/OS

Paul Bartak - Rocket Software

Zowe: A New Face for z/OS Information Technology is undergoing a revolution of changing architectures, new processing capabilities and a deluge of programming language options. With the ever-increasing speed of technology advancements, a dynamic workforce that spans millennials to baby boomers and rising expectations in user experience, there needs to be a new standard framework for interacting with the mainframe that enables an intuitive, productive and better integrated solutions.

 Come learn about Zowe. A new open source software framework that provides solutions that allow development and operations teams to securely, manage, control, script and develop on the Mainframe like any other cloud platform. Zowe is the first open source project based on z/OS.

 

Paul Bartak has been working with IBM databases since 1985, including the first version of DB2 on MVS. As an IBM customer for 14 years Paul worked in Application Development, Database Administration, and DBA. He joined IBM in 1999 as an Information Management Technical Specialist, teaming with the Sales force to present, design, install, demonstrate, and evaluate IBM Information Management solutions in a pre-sales environment; gaining multiple certifications in Database Administration, Data Replication, Blockchain, and Cloud Computing. Paul developed the four generations of the DB2 Migration Planning Workshops from DB2 V8 for z/OS, to DB2 11 for z/OS; and enablement for Db2 for z/OS pureXML and Temporal features. Currently, as a Principal Solutions Advisor with Rocket Software, Paul is focused on the tools used to maximize DB2 for z/OS value, with emphasis in database cloning and DevOps processes. He supports multiple Db2 User Groups, has been a speaker at several IDUG and Insight/Think conferences, is a Redbook/Redpaper author, and IBM Champion.

10-15am - 10:30am Break
10:30am - 11:45am

IBM Db2 DevOps Experience for z/OS Technical Review

Paul Bartak - Rocket Software

The IBM Db2 DevOps Experience for z/OS Technical Review Studies show the relationship between an agile organization and its success in the marketplace. At the same time, the competitive marketplace is tougher than ever, with technology savvy innovators entering industries and challenging mainstay enterprises. DevOps encapsulates the efficiencies necessary for the rapid, quality delivery of the software that drives these innovators. The database portion of the application is just as important as the application code,and has been identified as a major contributor to DevOps friction. This presentation will position where the IBM Db2 DevOps Experience fits in the DevOps world. With that understanding, we will dive into the details of the architecture and workflows, along with information about what this means for companies. Develop your understanding of this capability, built upon the Zowe open source framework, which elevates Db2 for z/OS into the fast paced, innovative world of DevOps.

11:45am -  12:45pm

z/OS Db2 Batch System Design for High Performance 

Neal Lozins, Softbase a division of Fresche Solutions

Building Db2 for z/OS batch systems can be challenging.  Mission critical high performing Db2 for z/OS batch systems bring the challenge to a whole new level.  Learn the difference between an I/O bound and a CPU bound application.  Learn how to turn an I/O bound Db2 for z/OS application into one that is CPU bound.  Learn the concepts of parallel processing and additional performance considerations.

Neal N Lozins is the creator and chief architect of TestBase, the SoftBase test data management suite, and manager of SoftBase development.  Having more than 35 years of architecting, developing and implementing Db2 for z/OS applications, he has helped countless customers get more value from this important platform.  Neal was the driving force behind a large utility company that transformed a billing system that could not bill forty thousand customers in eight hours into a system that bills seven million customers in three hours today

12:45pm - 1:00pm Lunch
1:00pm -  2:00pm

IBM DB2 Analytics Accelerator saved my life

Jared Wagner, State Farm Greg DeBo, State Farm

Abstract: IBM DB2 Analytics Accelerator saved my life - taking 3 years of processing down to hours by giving us an epic leap in data masking. Then we lit the Optim Scrubbing process on fire. You will learn the details around what made this a success, and the challenges we faced. We'll share mind blowing performance numbers and talk about some non-"traditional" uses for the IDAA. It can be utilized for more than analytics and data mining. Plus we'll share ideas on how transform your data in the fraction of the time traditional methods would take. Greg will then share some of the other features that State Farm is currently working with on both IDAA V5 and V7.

Speaker Profiles:

  • Jared Wagner- Data Analyst for State Farm Insurance with 10+ years of experience working with Test Data, Test Infrastructure and Test Governance.
  • Greg DeBo- IDAA Product Support team at State Farm, formerly IMS DBA, Db2 DB2, Db2 DBSA, Guardium Support, 30+ years on mainframe
2:00pm - 2:15pm IBM news, IBM think 2019 summary and giveaways – Sheryl Larsen, BMC
2:15pm - 2:30pm

IBM Data Server Manager

 

Jason Sizto, IBM

In this session, you will learn how to use Data Server Manager (DSM) for day to day operations along with a real time demo.  Best practice on how to identify problematic statements and different tuning techniques will be shared.  You will learn an advanced method for optimizing SQLs with host variables (or parameter markers).  We will explain how runtime host variable (or parameter markers) values can be captured and utilized for optimization with the integration between Db2 Query Monitor and DSM.  As a result, we will see a 15% CPU saving on the target static SQL by getting a better access path.  That is without creating any indexes, or doing any reorgs, or getting any extra statistics, on a SQL that is already well tuned.

 
Jason Sizto
Senior Engineer, Enablement

Query Workload Tuner | Data Server Manager | @AskIBMAnalytics

IBM Silicon Valley Laboratory
408.463.2822 | T/L 543.2822 | jsizto@us.ibm.com