Wisconsin Db2 Users Group
Log in

March 2019 WDUG meeting

  • 03/06/2019
  • 8:30 AM - 4:00 PM
  • Aurora Medical Center, 36500 Aurora Dr, Summit, WI 53066

Registration

  • Employees of a Sponsor site are allowed free access to the WDUG meetings they are hosting.

Registration is closed

Meeting Agenda – March 6, 2019

8:45-  9:15
Registration – Coffee, juice and rolls 

DB2 for z/OS

9:15 - 10:30

Zowe - A new Face for z/OS

Paul Bartak - Rocket Software

10:30 - 10:45 

Break

10:45 - 12:00

IBM Db2 DevOps Experience for z/OS Technical Review

Paul Bartak - Rocket Software

There are multiple studies that 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 product which elevates Db2 for z/OS into the fast paced, innovative world of DevOps.

12:00 - 1:15

Lunch - On your own

1:15 – 2:30

IBM DB2 Analytics Accelerator saved my life 

 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

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.

2:30-2:45
Break

2:45 - 4:00

Data Server Manager

Jason Sizto, Senior Engineer, Enablement - 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.


DB2 for LUW

9:15-10:30

Db2 Common SQL Engine Enhancements Update: What's new in Db2 Hybrid cloud and IIAS

Vincent Kulandaisamy - IBM

Vincent is one of the senior Db2 technical lead primarily focusing on the Db2 kernel query engine layer. He was part of the original Db2 BLU Acceleration engineering team that designed, implemented and delivered Db2 BLU in v10.5. He still continues to architect, design and implement various key enhancements to Db2 BLU. He was also part of the original team that designed and delivered Db2 HADR in Db2 v8.2 release. Over the two decades of working in database kernel design and development, he had achieved number of high value patents and received the IBM Master Inventor recognition. He is very passionate about understanding customer use cases, requirements and pain points and help solving them. Vincent has been with IBM since 2001. Prior to IBM he was with Informix Software Inc, which IBM acquired in 2001.

The Db2 Common SQL Engine with BLU Acceleration is the core technology behind our Hybrid Data Management Platform offerings including Db2 on-prem, Db2 Warehouse, Db2 Warehouse On Cloud (Db2 WoC), IIAS and IDAA. This talk will cover a high level overview of some of the recent enhancements delivered and available on Db2 WH, Db2 WoC, IIAS and IDAA. This session will also offer a sneak peek of features that will be available in upcoming Db2 on-premise releases.

10:30 - 10:45

Break

10:45 - 12:00

Db2 BLU Acceleration Internal Concepts & Best Practices

Vincent Kulandaisamy - IBM

This session will walk though the key internal design concepts behind IBM's BLU Acceleration in-memory optimized column-store technology. Since its release in Db2 v10.5, the Db2 columnar engine with BLU Acceleration technology has become the foundation for our analytic database offerings delivering speed of thought analytics and superior compression. This session will also cover best practices for BLU Acceleration on various form factors.

12:00 - 1:15

Lunch - On your own

1:15 - 2:30

IBM's Always on architecture introduction - keeping your service up for decades

Dale McInnis - IBM

Dale is a Senior Technical Staff Member (STSM) at the IBM Toronto Canada lab. He has a B.Sc.(CS) from the University of New Brunswick and a Masters of Engineering(M.Eng) from the University of Toronto. Dale joined IBM in 1988, and worked in the DB2 development team from 1992 - 2014. Dale's area of expertise includes DB2 for Linux, UNIX and Windows Kernel development, where he led teams that designed the current backup and recovery architecture and other key high availability and disaster recovery technologies. He has obtained eleven (11) patents in the area of database resiliency. Dale is a popular speaker at the International DB2 Users Groups (IDUG) conferences worldwide, as well as DB2 Regional users groups and IBM's Information On Demand (IOD) conference. His expertise in the area DB2 availability area is well known in the information technology industry. Dale spent 10 months as the IBM Cloud Data Services Chief Availability Architect, and now Dale is now on the North American Hybrid Data Management Technical Sales team.


The IBM Portal has been up and running since June 2001. This presentation describes what architecture does IBM use to achieve that feat and explains how customers can do it themselves with existing technology.

2:30-2:45

Break

2:45–4:00

DB2 Logging - what does it really do

Dale McInnis - IBM


Powered by Wild Apricot Membership Software