Welcome to the MWDUG Website!

Please take a moment to review our site.  Our next meeting will be held Thursday, June 5, 2014 at the IBM Chicago Technical Exploration Center (TEC). The IBM TEC is located in the Hyatt Building on 71 South Wacker in Chicago.

Click here to register for the 2nd Quarter Meeting - June 5, 2014.

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

Agenda for Our Next Meeting
Scroll to the bottom of this page to register.

Agenda for 2nd Quarter Meeting - June 5, 2014

08:30am - 09:00am Registration – Coffee, juice and rolls Registration – Coffee, juice and rolls


09:00am - 09:15am Welcome and IBM Announcements
Paul Bartak, IBM

Welcome and IBM Announcements
Dave Majcher, IBM

09:15am - 10:30am BSQL Tuning Tips for Developers
David Simpson, Themis, Inc.

Experience shows that a high percentage of database performance problems are solved by problems in the actual SQL.  While other pieces of the environment can play a role, the SQL developer is the person most able to make changes that will dramatically improve performance of SQL applications.  This presentation will explore some SQL tuning tips from Tony Andrews' new book on the subject.  These are practical recommendations that you will be able to use in your day-to-day job with SQL.

Data Security:  A DBAs Perspective
Brian Mealman, IBM

This presentation will cover the Who, What, When, Where, Why, and How of data security initiatives going on in companies today and how they impact and benefit DBA.

10:30am - 10:45am Break Break


10:45am - 12:00pm

IBM Data Studio for Mainframe Developers
David Simpson, Themis, Inc.

IBM Data Studio is a no-charge product provided by IBM to allow users, developers and administrators to interact with databases from a client machine.  IBM Data Studio may be used on a variety of platforms, but is most commonly used with the DB2 family of products.  Most of the functionality from previous client tools such as Visual Explain, Control Center and Stored Procedure Builder (aka Development Center and DB2 Developer Workbench) has migrated or is in the process of being migrated to this new platform.  The Eclipse IDE was selected as the environment to be used.  Java developers are generally familiar with this interface since it has been used as a Java development environment for about ten years.  Many products in IBM's Rational line are built on the Eclipse framework.  Mainframe developers are sometimes less familiar with this environment.  This presentation is meant to help those unfamiliar with Eclipse and IBM Data Studio get started with these products.

Achieve High Availability in Your Data Warehouse
Ian Bjorhovde, DataProxy

Usually, DBAs and System Administrators associate the term "High Availability" with clustering or replication solutions.  While these solutions are designed to address hardware failure, there are many other causes for downtime in a data warehouse.

This session will present an expanded definition of "High Availability" using some of the typical causes for downtime in my customer's environments.  I will discuss what solutions we implemented to solve these problems, and what we have learned about how we can improve in the future

12:00pm - 01:15pm

Lunch - free, onsite Lunch - free, onsite 


01:15pm - 02:15pm

DB2 z/OS Profiles the New ZPARMS and MORE
Paul Bartak, IBM

The word "Profile" is likely overused within the DB2 lexicon.  Application, or System, Profiles were introduced in the DB2 9 time frame with little fanfare  Since then, their capabilities have expanded to provide many autonomic and modeling capabilities in a variety of functional categories.  By gaining an understanding of this infrastructure, you will gain insight into one of the ways that new function is being delivered in DB2 for today and tomorrow.

The DB2 for z/OS Profiles presentation will cover the creation of system / application profiles and attributes to monitor things such as threads and connections, maintain copies of access paths, optimize subsystem parameters for SWL statements, set special registers, control ISAA, and model a production environment on a test system.  Establishing and controlling profiles will be covered.

Tips for Running BLU in the Cloud
Ian Bjorhovde, DataProxy

One of the main advantages that IBM provides when discussing BLU Acceleration in DB2 10.5 is its ability to simply "Load and Go."  However, in many enterprises, just getting to the point at which you can eliminate these delays and allow you to bring up a system running DB2 10.5 in just hours.

This session will present some background on the different options available for running BLU in the cloud, give insight into what pitfalls to avoid, and provide other tips to get you up and running as quickly as possible.
02:15pm - 02:30pm Break Break 


02:30pm - 03:45pm

Ulf Heinrich - SEGUS

DB2 Catalog Statistics are key for costs and performance of your z/OS applications.  Since the introduction of Frequency Values, Distribution and Histogram Statistics, simply adding a keyword to your RUNSTATS can significantly boost performance.

The DB2 Optimizer always relied on the Catalog Statistics to make access path decisions for dynamic and static SQL.  The better the DB2 Optimizer understands your data, the better he can do his job, or in other words: garbage in, garbage out.  Outdated, or inconsistent statistics easily jeopardize your costs and performance.  While current statistics seemed all you needed in the past, Frequency Values, Distribution and Histogram Statistics open up much more options nowadays.  The good thing is:  the right keywords give existing applications a performance boost and reduce the associated costs.  However, a wrong combination gives you a great opportunity to mess it up painfully.

75 Ways to Save I/O abd 25 Ways to save CPU
Lee Goddard, DBI

Want to be a hero on your team?  The #1 performance issue...Yes, I/O!  This interactive discussion is a systematic approach and methodology to helping you solve I/O problems and carving out more time to deploy more projects faster!  Of course, we will throw in some CPU saving items along the way.

This is an interactive discussion on ways to become a hero at your company!  Since DB2 LUW Version 1, we have seen many creative ways clients save CPU and I/O.  Sometimes a checklist is your best friend when you cannot think of what to look for first.

Speaker Bios
Paul Bartak, IBM - 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 Management - working with IBM & ISV Labs on various projects. Since joining IBM in 1999 his role has been that of 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. He is certified in Database Administration for DB2 for z/OS Version 9, 10, and 11; and in DB2 Data Replication. Paul has developed the four generations of Migration Planning Workshops from DB2 V8 for z/OS, to DB2 11 for z/OS; and the enablement for pureXML and Temporal features which are in use world wide.

Ian Bjorhovde, DataProxy - Ian Bjorhovde is a senior consultant for DataProxy, and is based in Phoenix, Arizona. He has worked in the IT industry for nearly 20 years and has spent the last 15 years as a consultant developing and supporting large DB2 UDB databases for clients in many different industries. Ian is an IBM Champion for Information Management and a DB2 Certified Advanced Database Administrator (DB2 10.1 for Linux, UNIX and Windows). He has presented at RUG, IDUG and IBM conferences.

Lee Goddard, DBI - Lee Goddard is DBI’s Software’s Chief Performance Architect. He is an author, speaker, and experienced IT Architect with over two decades of experience with IBM and MPP database system architecture, design, implementation, performance, hardware, consulting, governance, and capacity planning. Lee has successfully led over 200 IT projects for clients in every industry. Lee's passion is solving business problems for clients from SMB to Fortune 500 clients and working with fast growing clients that need large massively parallel systems or blazing fast EFFICIENT OLTP ... of which Lee has led over 80+ terabyte and 3 petabyte DB projects and SME for scaling 12 Petabyte level systems to the 10’s+ of PB level.

Ulf Heinrich, SEGUS Inc. - Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. Ulf's specialties are DB2 availability and performance, focusing on the growing requirement for 24x7 operations and cost reduction. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under real world recovery pressure. Ulf's activities cover EMEA, as well as North America through SE’s U.S. subsidiary, SEGUS Inc.

Brian Mealman, IBM - Brian is a Consulting IT Specialist with IBM with 30 years of experience in the IT industry. He has worked with IBM Database software and tools for his whole IBM career. He has presented many times at the DB2 Users Group and was a co-presenter at Information On Demand (IOD) 2006 in Anaheim CA. He currently is focusing on Database Security and Compliance.

David Simpson, Themis, Inc. - David Simpson is currently a Vice President at Themis Inc. He teaches courses on SQL, Application Programming, Database Administration as well as optimization, performance and tuning. He also installs and maintains the database systems used for training at Themis. Since 1993 David has worked as a developer and DBA in support of very large transactional and business intelligence systems. David is a certified DB2 DBA on both z/OS and LUW. David was voted Best User Speaker and Best Overall Speaker at IDUG North America 2006. He was also voted Best User Speaker at IDUG Europe 2006 and is a member of the IDUG Speakers Hall of Fame.

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