Welcome to the MWDUG Website!

Please take a moment to review our site.  Our next meeting will be held Thursday, March 9, 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 1st Quarter Meeting - March 9, 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 1st Quarter Meeting - March 9, 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 Blockchain Technology
Paul Bartak, IBM

Although it's probably mostly known as being associated with cyber currencies like Bitcoin, this technology can be the recording foundation for multiple businesses. Businesses have determined that the foundational technology for cyber currencies can bring efficiencies to business transactions. The concept of a ledger applies to any industry. Credits and debits, that represent the movement of physical & financial assets between accounts, drive big business within and between enterprises. Instead of each party maintaining a private ledger, Blockchain offers the efficiency of a shared ledger for all involved parties. Import / export, Letters of Credit, Supply Chain, Loyalty programs, and Leasing are just a few use cases where serious Blockchain interest can be found. At its core, Blockchain is an open transaction recording platform. Wait a minute? Isn't that what my DB2 platform does today? Maybe! As your company or your business partners continue down the road of digital transformation and cloud adoption your platform may be targeted for Blockchain. It is important to understand what Blockchain is, and isn't. Chances are high that Blockchain is, or will, impact your role. Will you be ready? This session will explain Blockchain and leave you with leads for building deeper skills.
10:15am - 10:30am Break
10:30am - 11:30am

DB2 V12
Adrian Burke, IBM

DB2 12 will usher in a new era of DB2 for z/OS migration, functionality, and flexibility. With the uptake of agile development the internal development as well customer adoption of DB2 features is shifting. DB2 12 embraces the concept of continuous delivery to ship valuable functionality through the maintenance stream without the burden of adopting a new release in the process. DB2 12 continues to focus on our key precepts of reliability, availability, and security as well as CPU reduction through the exploitation of central storage. This release will shift the previous boundaries around data sharing, table space size/definition, buffer pools, as well as throughput. Tell your friends you are coming to learn about the ORIGINAL enterprise level, on premise, cloud data server.

11:30am - 12:30pm

From Virtually Constrained to Really Overcommitted
Adrian Burke, IBM

With the 31 bit virtual storage relief of DB2 and other z/OS middleware customers no longer need to rely on the old ‘diet plan’. However the answer is not to simply open the gates for more threads/connections to come in. Real storage usage and conservation becomes the next major bottleneck. Things like persistent thread, long running units of work, and parallelism can exacerbate the real storage usage. Understanding what to look for, and what functionality can affect your stance on real storage is key to staying ahead of the game. We will look at DB2, z/OS, and Sort product parameter settings, as well as general best practices to keep your systems running safely.

12:30pm - 01:15pm


01:15pm - 02:30pm

SQL Tuning - There's Gold in them there "peaks"
Damon Anderson, Anixter, Inc.

Reducing CPU costs associated with poorly perform SQL can be a great source of pride for a production DBA. Reducing the elapsed time from hours to seconds can make you a hero with end users. This presentation will cover tips and techniques we used that achieved both. With complex SQL using UDFs, XML, CTEs, and other complex SQL coding structures as the challenge we were able cut CPU and elapsed times significantly and reduce costs. The challenge in reducing costs is finding the SQL that impacts the rolling 4 hour average. We will show some scripts we developed in house to alert us to potential run-away SQL.

Speaker Bios

Paul Bartak has been working with IBM Information Management solutions 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 roles have included that of a DB2 Advisor, developing the V8 – V11 Migration Planning Workshops, pureXML and Temporal Proof of Technologies; and a Client Technical Leader, working across a large payments processing company and the IBM account team. Paul holds multiple certifications across Information Management and Cloud domains.

Adrian Burke is an Open Group Master Certified IT Specialist on the DB2 SWAT team based out of the Silicon Valley Lab, led by John Campbell. In this role as a technical advocate for DB2 for z/OS Adrian conducts consulting and educational workshops, DB2 health checks, and availability studies for DB2 for z/OS customers. Previously, as a DB2 Advisor, Adrian supported hundreds of DB2 for z/OS customers from a technical sales perspective delivering consultative and educational workshops. Adrian has spoken at numerous DB2 Regional User Groups both in the U.S. and abroad as well as presented at IDUG, SHARE, and IOD. He is also a published Redbook author on material dealing with DB2 performance.

Damon Anderson is the Manager of Data Services at Anixter Inc. He has extensive experience in DB2, IMS, data replication, application design, Disaster Recovery, and related third-party tools and technologies. He has presented at IDUG many times and was chosen as the top user speaker at the North America conference in 2015. Additionally, he has presented at various regional user groups in the Midwest and Canada.