Wisconsin DB2 Users Group (WDUG)


Wisconsin DB2 Users Group (WDUG)

The Wisconsin DB2 Users’ Group meets triannually (March, June, & September) at various locations in the vicinity of Milwaukee, Wisconsin. 

WDUG is a non-profit organization run by users of the IBM DB2 family of products to promote education and foster communication of DB2 related information to local IT Professionals. All meeting presentations are technical in nature.

Website: http://wdug.com
Location: Milwaukee, WI
Members: 12
Latest Activity: Jun 7

WDUG Meeting June 6, 2018

Date: Wednesday, June 6th, 2018

Country Springs Hotel & Conference Center
2810 Golf Road
Pewaukee, WI

Cutoff date for pre-registration is:
Friday June 1, 2018

To register please go to our website at www.wdug.com and select Registration from the Main Menu to complete a registration form. E-mail us at wdug@wdug.com with questions.


Meeting Agenda – June 6, 2018
8:30-9:00     Registration – Coffee, juice and rolls

9:00-9:30     Welcome, IBM Announcements and WDUG Board Elections

DB2 for z/OS Track

A Single Point of Entry for Data Virtualization - Data Virtualization Manager
Tim Willging—Rocket Software

  • Today, organizations face a proliferation of data types – different formats, structures, multiple platforms – growing in volumes and needing to be integrated faster to deliver the real-time insight required by business leaders. It’s a daunting challenge complicated by aging tools and outdated data architecture. But what if all your enterprise data could be accessed through a modern single API, use a single metadata model or catalogue, and utilize a single security model? This session will explore IBM’s Data Virtualization Manager for z/OS and a potential new ability to transform Db2 into a complete data virtualization facility. Learn how any application that connects to Db2 can have virtualized access across a wide range of mainframe and non-mainframe data sources.

10:30-10:45 Break

Db2 Recovery Simplified with considerations for GDPR
Bob Bersano, Rocket Software

  • Db2 recovery can be complex and only a small fraction of users will practice any type of recovery scenarios on a regular basis. Recovery scenarios can range from recovering a single object to recovering a complete Db2 system. It seems that whenever a request for recovery ends up on a DBA‘s desk, it‘s always at the most inconvenient time because more and more DBA teams seemed to be understaffed. The majority of time in a recovery exercise is spent analyzing what has happened and which
    objects need to be recovered.
    There are a lot of utilities available in Db2 for z/OS that can help you with recovery. In order to use these utilities at the right time and in the most efficient way, it requires a lot of expertise and experience to execute the steps in the correct order in a situation that normally comes with some pressure.

12:00-1:15 Lunch - Buffet (Must pre-register—See ‘Other News’ for details)

SQL Procedural Language – Creative Uses
David Simpson, 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

2:30-2:45 Break

Environment simulation workload Replay in an agile
Ulf Heinrich, Segus

  • 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?
    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.

DB2 for LUW


App Dev Simplified: A Workshop for Developers and DBAs
Jon Lind—IBM

  • New applications must often leverage multiple types of data from many sources; and you have to deliver fast. While relational or transactional data is at the core of applications, and now you must also integrate unstructured sources like geo-location information, emails, and more. Instead of coding with different databases for different data types, why not use a single
    database to reduce complexity and deliver applications faster?
    IBM Db2 database software stores both relational data and unstructured data like JSON in a single database to make coding simple. Furthermore, Db2 meets requirements for enterprise scalability, availability and reliability. Why does it matter? Because you can do it right the first time without wasting time and productivity cycles to rewrite database components of your applications before deployment..

10:30-10:45 Break


App Dev Simplified:
A Workshop for Developers and DBAs… continued
Jon Lind—IBM

  • We’ll go over:
    1. Supported languages, IDEs and available APIs
    2. Db2 architecture, including the ability to store unstructured data alongside relational tables
    3. Robust compatibility that lets you run SQL written for other platforms like Oracle, Netezza and Postgres
    4. BLU Acceleration for super-fast and efficient in-memory processing that delivers result very quickly
    5. Using Db2 with Node.js and OData / REST API programming projects

          6. Tips and tricks as well as SQL tuning and monitoring capabilities

12:00-1:15 Lunch - Buffet (Must pre-register—See ‘Other News’ for details)


App Dev Simplified:
A Workshop for Developers and DBAs… continued
Jon Lind—IBM

2:30-2:45 Break


How to Write Bad SQL: Seven SQL Performance Killers to
Avoid in Db2
Ember Crooks—XTIVIA

  • Writing top-performing SQL is a complex task. It takes practice and patience, as well as trial and error. Having a framework and a few rules to work from is a good place to start, whether writing SQL is your primary job or you are a database administrator who just needs to be able to help tweak SQL from time to time. Come learn seven mistakes that lead to slow SQL in Db2 and how to avoid them. This session is targeted at LUW, but may have applications across platforms.

Discussion Forum

This group does not have any discussions yet.

Comment Wall

Add a Comment

You need to be a member of Wisconsin DB2 Users Group (WDUG) to add comments!


Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

New SQL pagination syntax - a Db2 12 greatest hit with John Campbell

Posted by Paul McWilliams on May 22, 2018 at 21:25 0 Comments

Db2 12 for z/OS introduces new SQL syntax that makes the difficult task of coding efficient SQL pagination—returning a portion of a result set based on data position—much easier for application developers. Read more in…



  • Add Videos
  • View All

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service