Welcome to the MWDUG Website!

Please take a moment to review our site.  Our next meeting will be held Thursday, March 5, 2015 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 1st Quarter Meeting - March 5, 2015.

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 Our Next Meeting

For details regarding DB2 for LUW, please email David Majcher.

Scroll to the bottom of this page to register.

Agenda for 1st Quarter Meeting - March 5, 2015

08:30am - 09:00am Registration – Coffee, juice and rolls
09:00am - 09:15am IBM DB2 News
Sheryl M. Larsen, IBM
09:15am - 10:30am DB2 11 Overview and Latest News
Jeff Josten, IBM

A quick overview of the most interesting new features in DB2 11, as well as an update on recent enhancements that support Hybrid Cloud, Dev ops, and developer productivity.

10:30am - 10:45am Break
10:45am - 12:00pm

The Present and Future of Large Memory in IBM DB2
Jeff Josten, IBM

With the flattening of Moore's Law, processor speeds will not serve as a significant source of performance improvement in coming years.  Database systems are looking to use large real memory to avoid I/O latency and processor overhead.  IBM DB2 11 and future releases of DB2 are looking to use large real memories and IBM z/OS features, such as large page sizes and flash memory.  This session highlights the potential performance benefits of large real memories and how the DB2 development team plans to exploit such opportunities.

12:00pm - 01:00pm

Lunch - free, onsite
01:00pm - 02:15pm

Safeguarding your SQL Performance
Damen Anderson, Anixter

Good SQL performance is something developers and DBAs alike aspire to.  SQL that performed well yesterday may have degraded seemingly overnight.  This presentation will provide suggestions on where and how to look for clues about changes in performance for both dynamic and static SQL.  The particulars of using plan management to revert to the prior or original copy of a package will be covered.  Additionally, information will be presented on the identification of SQL "tricks" that may cause a problem as opposed to "tricks" that should not cause a problem.  Finally, tips on how to code or recode troublesome queries will be covered.

02:15am - 03:30pm

DB2 for z/OS - SQL for the 21st Century:  Overlooked Enhancements
David Simpson, Themis

Are you still coding like it's the 90s?  This session will cover some overlooked SQL enhancements in the latest releases of DB2 with a special focus on features that have been most useful in real DB2 environments.

  • Online Analytical processing (OLAP) Built-in Functions
    • Overview of Grouping
    • Ranking and Row Numbering
    • Moving Aggregates
    • Aggregation Partitioning
    • Grouping Sets, Rollup & Cube
  • Common Table Expressions
    • Multiple Levels of Aggregation
    • Recursive SQL
  • MERGE Statement
  • SELECT FROM Insert/Update/Delete/Merge
  • Hash Organization
  • DB2 11 SQL Enhancements