RSVP MWDUG 2nd Quarter 2018

Scroll to the bottom of this page to register.

Agenda for 2nd Quarter Meeting - June 7, 2018


08:30am - 09:00am Registration – Coffee, juice, soda, and cofee cake
09:00am - 09:15am Welcome and IBM Announcements
Sheryl Larsen, BMC & IBM
09:15am - 10:15am Selling Your Mainframe to Upper Management
Sheryl Larsen, BMC, WW Db2 Z Solution Strategist

The topic for this presentation was a request from many BMC customers. This will give you ammunition educating upper management on justifying keeping, growing, relocating data on the Mainframe. You’ll get a tone of Db2 Z bragging material. This meeting is sponsored by BMC and she will eventually mention their solutions.
10:15am - 10:30am Break
10:30am -  11:30am Birds Eye View of BMC Db2 Development Labs
John Barry, BMC, Supercharged Db2 Product Manager

John Barry is a 20-year veteran of Db2 and currently manages the production of superior technology that greatly enhances your mainframe environment. IBM provides the boiling water with the Z14 and Db2 12. BMC turns the water into steam to power your enterprise. John will update you on the BMC Db2 solutions and include a taste of futures.
11:30am - 12:30pm Lunch
12:30pm -  01:30pm Total Environment Simulation – Workload Replay in an Agile World
Ulf Heinrich, Software Engineering (SEGUS Inc.), Director of Solutions Delivery

Is your production cloning for development/testing a quick and fully automated procedure? Does it consider differences of the underlying hardware and does it allow to choose and automatically run SQL workloads? Maybe your Db2 cloning needs an upgrade! By using a highly customizable XML script and by exploiting virtualization features we can make a clone YOUR clone and even make it behave like production. However, most importantly SQL Capture/Replay fills the gap of automatically running your production workload for testing. It captures production SQL 24/7 by exploiting highly efficient IFCID-via-OPx technology and it filters and prepares statements for replay. This enables shops to capture any SQL being ever executed and keep them in sets of workloads to be selected for testing. As an integrated part of Db2 cloning, this adds up to a comprehensive cloning solution, not only for objects and data, but even for production workloads. Learn how to integrate individual task for flexible automation and how to choose from four different levels of testing. The levels include simple anomaly alerting, access path verification, cloning and workload capture/replay to easily discover different behavior resulting from changes, like new application releases, or environment upgrades. Find out how easily you can pick and choose from KPI based test automation.
1:30pm - 1:45pm Break
01:45pm - 02:45pm

SQL Procedural Language - Creative Uses
David Simpson, Vice President, Themis

The SQL PL language is useful for writing stored procedures, user defined functions (UDFs) and triggers. The language is becoming more powerful with each release. This session will cover the basics of the language and give you some samples to take home and try!

• Overview of SQL PL
• Strengths and Limitations of SQL PL
• Sample stored procedures for use anywhere!
• Sample user defined functions for use anywhere!
• SQL PL and Triggers .

02:45pm - 03:00pm Break
3:00pm – 4:00pm Access Path Stability on Db2 for z/OS - Best Practices
David Simpson, Vice President, Themis

Db2 has provided some great features for stabilizing performance through changes in the environment, particularly through a Db2 version upgrade. In this session we will look at the evolution of access path stability over the last few releases and provide some thoughts on best practices for implementation.

Select a registration category then click 'Continue'