Central Ohio Db2 User Group
The official CODUG web site.
Like us on Facebook
Search CODUG.org:


CODUG Leaders 

Subscribe / Membership 

All Presentations / PDFs


Meeting December 4, 2018 at IBM Tuttle Crossing
6060 Britton Parkway, Dublin, Ohio* (Map)
*Lots of free parking.

Please register for the next meeting on Eventbrite
. There is a green "Register" button on the right below our logo.

8:30 - 9:00 Registration
9:00 - 9:15 Opening remarks. Announcements.
9:15 - 10:30 Db2 for z/OS utilities - improvements in v11 and v12
Presented by Haakon Roberts - IBM
10:30 - 10:45 Break - Refreshments will be served.
10:45 - noon Benefits of v12's Partition By Range Relative Page Numbering (PBBR RPN)
Presented by Haakon Roberts - IBM
noon - 1:00 Lunch and learn -- (Sponsored by Fresche Solutions)
1:00-2:15 Temporal Table Design
Presented by Steen Rasmussen - Computer Associates
2:15 - 2:30 Break - Refreshments will be served.
2:30 - 3:45 Proactive Performance Management Using Analytics.  
Presented by
Steen Rasmussen - Computer Associates
3:45-4:00 Q&A

Db2 for z/OS utilities - improvements in v11 and v12

Db2 for z/OS utilities is an area of intense and continuous development delivering many significant functional, performance and availability enhancements outside of V12. This session will focus on the very latest improvements that you can take advantage of today, even in V11.

About the Speaker - Haakon Roberts
Haakon Roberts has over 30 years' experience working with Db2 on the mainframe platform covering various aspects of systems programming, database administration, software development and support. He is a Distinguished Engineer in Db2 for z/OS development at the IBM Silicon Valley Laboratory in San Jose, California and the chief technical architect and strategist for Db2 for z/OS Utilities and Tools. He holds several patents and is a leading expert in data integrity, availability, serialization techniques and problem resolution. He is a regular speaker on these and other topics.

Benefits of v12's Partition By Range Relative Page Numbering (PBR RPN)

You've probably heard of PBR RPN in Db2 12 and how it's now possible to store 4 petabytes of data in a single Db2 table. But the real benefit of RPN is how it improves availability and creates a foundation for future improvements in Db2. This session will explain why we delivered RPN in 12, how it works, what the benefit is and how to get there. We'll also look at other significant availability improvements delivered in V12 and after.

About the Speaker - Haakon Roberts
See above

Temporal Table Design

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.
  • Basics before news
  • Include / Exclude / Include
  • Referential Integrity - how does it all work
  • RTS autonomics - No more need to offload RTS on a periodic basis
  • Catalog prep for autonomic auditing

About the Speaker - Steen Rasmussen
Steen Rasmussen is a Principal Engineering Services Architect currently instrumental in the ongoing development and support of the CA Technologies DB2 tools. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark working with all aspects of DB2 - like tuning, application design and implementation, education of developers, backup and recovery planning and automation of housekeeping processes. In 1995 Steen became a technical manager at PLATINUM Technology managing technical support and presales for the DB2 products.

Steen has been working with DB2 for z/OS Release 1.0 since 1985 and is always looking for new opportunities in the CA DB2 solutions which can help customers manage DB2 more efficiently. Besides from providing support to the teams in the field as well as internal groups at CA technologies working with DB2, Steen is also a frequent speaker at IDUG in North America, EMEA and Australia as well as local DB2 User Groups around the world. Steen is honored to be an IBM Champion for four years.

Proactive Performance Management Using Analytics.

Understanding “the normal behavior” of the DB2 applications (static as well as dynamic SQL) can be a challenge, but using existing performance metrics and baseline these could put you in a situation where you can take action before the SLA’s are violated and even save you a lot of headaches in the “war room” finger pointing.
  1. Is the Green Highway really Green and what is it ?
  2. Why baselining ?
  3. Static versus dynamic baselines pros and cons.
  4. Moving average and Electric Rules – what’s happening with DB2
  5. Avoiding War Room meetings and finger pointing

About the Speakers - Steen Rasmussen
See above


Directions Map

CODUG Home | Meetings | CODUG Leaders | Subscribe / Membership | All Presentations / PDFs | CODUG Home  2018 by Central Ohio Db2 User Group. All rights reserved.

Created: 6/18/2018 / Changed: 11/20/2018 6:04:54 PM

We are the Central Ohio Db2 User Group in Columbus, Ohio. paul@nationwide.com.