Tuesday December 4th ==> Next CODUG Meeting.
We are 1 day away! Please register for tomorrow’s CODUG meeting (December 4). Invite your colleagues, bring along a developer or two. We have great speakers lined up.
To register for the next meeting please use the following link:
We would also like the speakers to register so that we have an accurate lunch count.
The next CODUG meeting is scheduled for Tuesday, December 4th, 2018 at the IBM office 6060 Britton Parkway Building 1, Dublin, Ohio. https://goo.gl/maps/pyg7PFV7sKQ2
8:30 - 9:00 Registration
9:00 - 9:15 Welcome and Opening Remarks
9:15 - 10:30 Haakon Roberts - Db2 for z/OS utilities Update
10:30 - 10:45 Break
10:45 - 12:00 Haakon Roberts - PBR RPN and Availability
12:00 - 1:00 Lunch and Learn presentation (Sponsored by Fresche Solutions)
1:00 - 2:15 Steen - Temporal Table design
2:15 - 2:30 Break
2:30 - 3:45 Steen - Understanding “the normal behavior” of the DB2 applications
3:45 - 4:00 Closing Remarks
Our speakers and their topics for the December meeting will be:
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
Abstract for the utilities session:
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.
Abstract for the availability session:
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.
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.
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.
-) 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
Proactive Performance Management Using Analytics.
Abstract: 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