![[CODUG]](images/logo3.jpg){kind=logo}
The official CODUG web site. |
 |
|
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 Abstract |
| 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 Abstract |
| noon - 1:00 | Lunch and learn -- (Sponsored by Fresche Solutions) |
| 1:00-2:15 |
Temporal Table Design
Presented by Steen Rasmussen - Computer Associates Abstract |
| 2:15 - 2:30 | Break - Refreshments will be served. |
| 2:30 - 3:45 |
Proactive Performance Management Using Analytics.
Presented by Steen Rasmussen - Computer Associates Abstract |
| 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.- 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
About the Speakers - Steen Rasmussen
See above
Announcements
Directions Map
We are the Central Ohio Db2 User Group in Columbus, Ohio. paul@nationwide.com.