RSVP MWDUG 1st Quarter 2018


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

Select a registration category then click 'Continue'