Welcome to the MWDUG Website!

Please take a moment to review our site.  Our next meeting will be held Thursday, June 8, 2017 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 2nd Quarter Meeting - June 8, 2017.

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 2nd Quarter Meeting - June 8, 2017

Agenda for 2nd Quarter Meeting - June 8, 2017


08:30am - 09:00am Registration – Coffee, juice, soda and rolls
09:00am - 09:15am Welcome and IBM Announcements
Shri Shrimali, IBM
09:15am - 10:15am A "Collection" of Quick Hits
Steve Loesch, Anixter, Inc.

As DB2 continues to evolve, I have picked up new techniques for building Stored Procedures, User Defined Functions, and Dynamic SQL. This presentation will also discuss DB2 V11 features used at Anixter.
Objective 1. Using XML with DB2 stored procedures and functions to keep parameters markers in sync. XML Documents are used in input/output parameters and return cursors.
Objective 2, Using DB2 V11's new Autonomous Procedures to aid in procedure debugging and error tracking.
Objective 3. Review requirements for developing a dynamic SQL procedure and use of concentrate literals.
Objective 4. Real World experience with UTS tablespace conversions.
Objective 5. Review of other useful DB2 V11 features used at Anixter.
10:15am - 10:30am Break
10:30am -  11:45am Modern DB2 Security You Can Trust
Troy Coleman, IBM

Security is at the top of the list of concerns for CIO’s these days. DB2 for z/OS is running on the most secure platform in the industry, however, you still need to take steps to ensure you are taking advantage of the security features built into DB2. One of these features “roles and trusted contexts” has been overlooked for years, but more recently companies have been asking for help in understanding and implementing roles and trusted contexts. This presentation will explain the concepts of roles and trusted contexts and will provide some real-world use cases and steps to implement them. In addition, we will discuss some recent enhancements delivered in DB2 11 around secondary roles.

11:45am - 12:30pm

12:30pm -  01:30pm SQL Tuning in the Digital World
Sheryl Larsen, BMC

The Digital World includes all kinds of transactions most of which contain SQL. Trapping and fixing nonperforming SQL has gotten more complicated or has it? The speed at which SQL performance problems need to be resolved has shrunken to .1ms or 0 – meaning that they should never happen. Come learn tips and techniques that can assist you in today’s Digital World.
Objective 1: When your monitors find this, what should you do?
Objective 2: What crazy SQL can do to you?
Objective 3: Finding the most expensive query running in the peak
Objective 4: Some old and new tuning techniques
Objective 5: Monetize your MLC savings with compares
01:30pm - 02:30pm JSON Enhancement and Use Case with Watson
Jae Lee, IBM

Applications around Mobile devices are becoming increasingly important in large enterprises with requirement of storing JSON in database. This presentation will illustrate the JSON storage model and SQL APIs to manipulate JSON data.

We will also present the JSON enhancements we delivered in the services stream. With rapid adoption of JSON, we will share how customers use JSON in a real world scenario and use cases using Watson. Tips and pitfalls will be given to ensure a successful JSON solution in an agile application development model.


Speaker Bios

Troy Coleman is currently an IBM DB2 Advisor z/OS and brings a variety of skills focused around DB2 including product management, DB2 systems programmer installing and configuring DB2, application DBA, and application developer. Troy has been active in the DB2 community as a board member for the Chicago Midwest Database User Group (MWDUG) and former board member of IDUG as well as holding the prestigious title of IBM Information Management Champion from 2011-2015. He is an internationally recognized consultant and lecturer specializing in DB2 database administration and application architecture with experience on many leading hardware platforms, including DB2 for z/OS, Windows, AIX, Solaris and Linux. Troy was the architect and lead developer of the first wireless database management software for DB2 UDB, PocketDBA, by Expand Beyond Corp.

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.

Jae Lee is an advisory software engineer at the IBM Silicon Valley Laboratory in San Jose. He has been a member of the DB2 z/OS Development team since 2005. He is a primary developer for SQL PL and has participated many SQL development projects. Recently, he has been dedicated to provide NoSQL support on DB2 z/OS.

Steve Loesch is a Sr. Technical Database Administrator at Anixter Inc. DB2 Database Administration and Programming since 1988. All versions of DB2. Motorola, 1998-1992 DB2 DBA, Platinum Technology, Inc, 1992-1999, DB2 Internal Application using DB2 C/S Applications and PeopleSoft, CA Technology 2000-2009 DB2 DBA Manager, Managed DB2 SAP 2005-2009. DB2 Consultant 2009-2010, Database Design and Performance Management, Migrated DB2 V8-V9. Anixter Inc, 2010-2016 DB2 DBA, Database Design and Performance Management, Migrated DB2 V9-V11.