Seminar Program

Next seminar: December 5, 2018

Location: Four Points by Sheraton, Novi

8:15 am - 9:00 am Check In and Breakfast
9:00 am - 9:15 am Opening Comments
9:15 am - 10:30 am "Online Schema and Availability Enhancements"
Speaker: Haakon Roberts (IBM)
Download "Online Schema and Availability Enhancements"
10:30 am - 10:45 am Break
10:45 am - 12:00 pm "Db2 Utilities: The Very Latest Developments"
Speaker: Haakon Roberts (IBM)
Download "Db2 Utilities: The Very Latest Developments"
12:00 pm - 1:00 pm Lunch (Provided)
1:00 pm - 2:15 pm "What’s New in the Temporal World of Db2"
Speaker: Steen Rasmussen (CA Technologies)
Download "Whats New in the TEMPORAL World of Db2"
2:15 pm - 2:30 pm Break
2:30 pm - 3:45 pm "Proactive Performance Management Using Analytics"
Speaker: Steen Rasmussen (CA Technologies)
Download "Proactive Performance Management Using Analytics"
3:45 pm - 4:00 pm "Closing Comments "


Presentation Abstracts

Presentation #1:

Speaker: Haakon Roberts - "Online Schema and Availability Enhancements"

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.

Presentation #2:

Speaker: Haakon Roberts - "Db2 Utilities: The Very Latest Developments"

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.

Presentation #3:

Speaker: Steen Rasmussen - "What’s New in the Temporal World of Db2"


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

Presentation #4:

Speaker: Steen Rasmussen - "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.

• Is the Green Highway really green and what is it?

• Why baselining?

• Static versus dynamic baselines pros and cons

• Moving average and electric rules – what’s happening with DB2

• Avoiding War Room meetings and finger pointing

Speaker Biographies

Haakon Roberts (IBM)

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.

Steen Rasmussen (CA Technologies)
Steen Rasmussen is a Sr. 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-tuning, application design and implementation, education of developers, backup and recovery planning and automation of housekeeping processes Steen has been working with Db2 for z/OS since 1985 and is always looking for new opportunities in the CA Db2 solutions which can help customers manage Db2 more efficiently. Besides 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.