Welcome to the MWDUG Website!


Please take a moment to review our site.  Our next meeting will be held Thursday, March 8, 2018 at the IBM Chicago Technical Exploration Center (TEC) located in the Hyatt Center, 71 South Wacker Drive, 6th Floor, Chicago, IL  60606.  

Click here to register for the 1st Quarter Meeting - March 8, 2018.

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

 



Agenda for 1st Quarter Meeting - March 8, 2018

 

  Db2 FOR z/OS TRACK
08:30am - 09:00am Registration – Coffee, juice, soda, and rolls
09:00am - 09:15am Welcome and IBM Announcements
Sheryl Larsen, BMC & Troy Coleman, IBM
09:15am - 10:15am Db2 for z/OS Latest News and Continuous Delivery
Jeff Josten, Distinguished Engineer, IBM

Db2 12 is the latest release of Db2 for z/OS, it is built on the core capabilities of Db2 11, and gives businesses the capabilities needed to meet the business demands of the future by providing scale and speed for next era of Mobile and Interconnected devices along with application support for Cloud and Analytics. It delivers faster analytical insights and leverages advanced speedy In-Memory database performance. This session will give a quick recap of the Db2 12 features of most interest, and the latest news for Db2 11 and 12. We will also cover the latest on Db2 continuous delivery, which delivers features faster than ever before and in a more consumable way for customers.
 
10:15am - 10:30am Break
10:30am -  11:30am A Field Guide for Test Data Management
Kai Stroh, UBS Hainer

In this presentation, we’ll analyze actual customer stories that demonstrate how we’ve helped companies meet their test data provisioning goals and streamline and automate their Db2 data refresh strategies.

You’ll also learn how our Test Data Management Strategy can help you improve your own process by:
  • Isolating production from all other environments
  • Refreshing test beds with mass data
  • Supplying specific data for unit testing
11:30am - 12:30pm Lunch
12:30pm -  01:30pm Db2 Security Best Practices II
Dave Beulke, Gold Consultant, and IBM Information Champion

Implementing the best security techniques and strongest configuration is mandatory these days for safeguarding your data. This presentation discusses the latest DB2 security methods, procedures, and techniques for fortifying DB2 systems, databases and applications. Security for your software configurations, application connections and best practices for applications are required for safeguarding your data against internal and external hacking threats.

This presentation details DB2 z/OS and DB2 LUW security strategies such as the impacts of encryption, database design security techniques and how best to implement a multi-layered DB2 security data perimeter. You will leave this presentation with the latest up-to-date DB2 security techniques and procedures that will help you guard against the many hacker threats and applications issues that can inadvertently expose your data.
01:45pm - 02:45pm Save Serious Money with zIIPs, and Prove it! Here’s How

Calculating the Real Amount of zIIP Offload
Bernie O’Connor, Anixter, Director of Information and Technology
Bob Hill Manager – IT Management at Anixter Inc

You know you can save serious money with zIIPs – but can you prove it to yourself and your Business Management? Learn how. Learn about the SCRT, VWLC, MSUGs, zIIPs, calculating savings, implications of Batch, and more from our experience at Anixter, a leading global distributor.

Anixter is a leading global distributor of Network & Security Solutions, Electrical & Electronic Solutions, and Utility Power Solutions.
02:45pm - 03:00pm Break
3:00pm – 4:00pm Revival of the SQL Tuner – all Developers are welcome to this session at no charge!
Sheryl Larsen, BMC, Sr. DB2 Product Specialist

The pool of DBAs with SME knowledge of SQL tuning has shrunk dramatically while the number of SQL statements needing attention has grown and will continue to grow. DB2 performance tooling can help identify what needs to be tuned. But what do you do then? This presentation will help fill the skills gap by reviving the role of an SQL Tuner. Specifically, you will learn what access paths are good for what types of queries and how to change the DB2 optimizers mind.

Objective 1: Witness the access path choices with graphic animations and understand which paths are good/bad for certain queries

Objective 2: Learn how to read a visual EXPLAIN

Objective 3: Learn how to use traditional query tuning techniques

Objective 4: Learn how to experiment with more extreme tuning techniques

Objective 5: Take a 5-minute test for a chance to qualify for an official SQL Tuner certificate

Speaker Bios

Jeff Josten
Title: Db2 for z/OS Latest News and Continuous Delivery Abstract: Db2 12 is the latest release of Db2 for z/OS, it is built on the core capabilities of Db2 11, and gives businesses the capabilities needed to meet the business demands of the future by providing scale and speed for next era of Mobile and Interconnected devices along with application support for Cloud and Analytics. It delivers faster analytical insights and leverages advanced speedy In-Memory database performance. This session will give a quick recap of the Db2 12 features of most interest, and the latest news for Db2 11 and 12. We will also cover the latest on Db2 continuous delivery, which delivers features faster than ever before and in a more consumable way for customers.

Kai Stroh is a mainframe software developer specializing in DB2 utilities for z/OS. He designs and builds innovative DB2 applications and utilities often working onsite or remotely with UBS’ international clients. He easily navigates his way around DB2 dumps and knows how to move data and definitions across DB2 versions, and this includes the unique in-house DB2 subsystems which each have their own little technical adaptations.

Dave Beulke is a business strategist, systems architect, and performance expert specializing in Big Data, data warehouses, and high-performance internet solutions. He is an IBM Gold Consultant, Information Champion, and President of DAMA-NCR, former President of International DB2 User Group, and a frequent speaker at national and international conferences. His strategies, architectures, and performance tuning techniques enhance analytics, security and performance so organizations can better leverage their information assets and save millions in time to market, CPU, development and overall costs. Follow his blog at davebeulke.com or on Twitter here (@DBeulke) or connect through LinkedIn here (https://www.linkedin.com/in/davebeulke).

Bob Hill is Manager – IT Management at Anixter Inc. Bob is currently responsible for Scheduling, and his experience includes computer operations, storage, and systems programming.

Bernie O’Connor is Director – Information Technology at Anixter Inc. His experience includes Database Administration, Application Development, BI/DW and more. Bernie has been active in MWDUG and IDUG as a member, speaker, and Board Member. Bernie is an IDUG Hall of Fame Speaker and IDUG Past President.

Sheryl M. Larsen is a Sr. DB2 Product Specialist at BMC. Previously she worked for IBM, Sheryl M. Larsen, Inc., and Platinum Technology. She is known for her extensive expertise in SQL Tuning and has performed detailed DB2 Performance Health Checks for many fortune 500 clients. Sheryl has over 25 years’ experience in DB2, has published many articles, white papers and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. Currently, she is the President of the Midwest DB2 User Group - www.mwdug.org, and a member of the Northern Illinois University Computer Science Alumni Council.