This FREE virtual education event will be held virtually via webex . As such we are not limiting our audience to current user group members. Invite a friend or coworker who may not have had the chance to attend in person in the past and let them experience what NEODBUG is all about! Please register just as you would for an in-person seminar by using the link at the bottom of the page with the name of your organization and any attendees. We will send you a link to the event as it gets closer.
Agenda:
9:15 AM - Welcome - Bob Vargo
9:30 AM - Db2 Developers top 10: Optimization, Performance Tuning, SQL Best Practices, Table Scans - Tony Andrews
10:30 AM - Personal experience: 40 years of battle scars from managing Db2 for z/OS- Steen Rasmussen
11:30 AM - Lunch
12:30 PM - How to Recover When Recovery Seems Impossible - Chad Reiber
1:30 PM - Wrap up - Bob Vargo
Title: Db2 Developers top 10: Optimization, Performance Tuning, SQL Best Practices, Table Scans
Tony Andrews
Bio: Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a database analyst. For the last 20 years, Tony has been splitting his time between performance and tuning consulting engagements along with training. His main focus is to teach today’s developers the ways of RDBMS application design, development and SQL programming -- always with a special emphasis on improving performance. He is a 13 time IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA. He is also the author of a book for developers titled ‘DB2 SQL Tuning Tips for z/OS Developers’.
Abstract:
There are some technical basics that I think every Db2 developer should know as part of their jobs in designing, developing, and tuning applications they are a part of. What should they know in order to code the most efficient queries? What should they know in order to design the most efficient program and application architecture? What should they know about in order to minimize production incidents? This presentation will cover these areas and more to help get the developer more 'Empowered' in their day to day projects.
Title: Personal experience: 40 years of battle scars from managing Db2 for z/OS
Steen Rasmussen
Bio:
A Principal Engineering Services Architect currently instrumental in the ongoing development and support of the Broadcom 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 Broadcom/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 since 2014.
Abstract:
40 Years of war stories in the Db2 for z/OS world
Having been a DBA from 1985 to 1995 followed by working in the field with Db2 customers around the world for 30 years, I have faced quite a few wildfires and wars.
Join me and experience some of the most interesting ones and learn how partner tooling can augment native Db2 features - hopefully you will bring home some ideas and draw some benefits.