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: 14
Latest Activity: Oct 30, 2019

WDUG Meeting May 15, 2019

Meeting Agenda – May 15, 2019

Register at: https://wdug.com/event-3325517

Db2 for z/OS Program 

8:45-  9:15

Registration – Coffee, juice and rolls

9:15 - 10:30

Tablespace Evolvement – PBR2 is the new kid on the block

Steen Rasmussen - CA Technologies

Abstract  :  The tablespace design has been through many changes and enhancements. This presentation will cover each of the tablespace types including pro’s and con’s and limitations as well as best practices. The emphasis will be on the new tablespace type (Relative Addressing) introduced in Db2 12 using a live Db2 12 system to illustrate the details.   

  1. Tablespace types since the early days of Db2 and their pro’s and con’s.
  2. Table Controlled Partitioning 
  3. Partition By Growth
  4. Relative Byte Addressing
  5. Live walk through of all the new DDL attributes, utility processing a enhancements to schema changes

10:30 - 10:45 


10:45 - 12:00

What’s new in the TEMPORAL world of Db2

Steen Rasmussen - CA Technologies 

Abstract  :  The Temporal Table design was introduced in Db2 10 and there were quite a few restrictions. Some of these were lifted in Db2 11 and Db2 12 has lifted more – but the temporal design has really started to be adopted by Db2 itself, so we will cover the restrictions removed using live examples as well as a detailed walkthrough of how the Db2 engine itself is starting to offer this functionality and predictions for the future.   

  1. Basics before news
  2. Include / Exclude / Include
  3. Referential Integrity -  how does it all work
  4. RTS autonomics - No more need to offload RTS on a periodic basis
  5. Catalog prep for autonomic auditing

12:00 - 1:15

Lunch - On your own

1:15 – 2:30

Why does the Db2 for z/OS Optimizer need a Data Scientist?

Sheryl M. Larsen - BMC

Abstract  : To sum up the past 30 years of Db2 access path optimization – good for many, great for few.  Come find out what IBM is doing about this and how the solution will fit in your DevOps environment.  There are four specific uses cases discussed and time for some futures as this solution keeps on growing.

  1. How is machine learning and AI infused in today’s Db2 Optimizer
  2. What is a Virtual Data Scientist and what does it eat?
  3. Which scenarios are the VDS’s hot spot? i.e. :hv/?, FETCH FIRST, || FOR STATIC, Sort
  4. What does the VDS provide your Db2 environment?\
  5. What lies next in the VDS roadmap?



2:45 - 4:00

An Audit A Day Keeps the Lawyers at Bay

Roy Boxwell - SEGUS

Abstract  : 

Audit and Compliance is one of the big challenges companies are facing these days. With GDPR and a bunch of other laws either in force or "coming soon to an auditor near you" it is time to bite the bullet and start working with the auditor not against. This presentation shows how you can answer Who did What When ‐ whenever needed.

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!


© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service