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 inperson 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:
10:00 AM - Welcome - Bill Moran
10:05 AM - Introductions - Bob Vargo
10:15 AM - Best Practices for Applying Db2 for z/OS Software Maintenance - Robert Tilkes
11:15 AM - Declared Global Temporary Tables (DGTT) user stories - Kurt Struyf
1:15 PM - Code Your Db2 Applications for Performance from the Start!- Craig Mullins
2:15 PM - Wrap up - Bob Vargo
Title: Best Practices for Applying Db2 for z/OS Software Maintenance
Robert Tilkes
Bio: Currently a member of the IBM Db2 Development SWAT Team with 30+ years of experience in System z/Mainframe environment primarily in Db2 for z/OS as a System Engineer/DBA. Prior to working for IBM was a Lead, System Engineer 12+ years. During that time focusing on strategy, best practices, and proof of concepts. Also, led the Db2 for z/OS through 2 federal audit/compliance findings and remediation. Also implemented Db2 for z/OS Native Rest Service in conjunction with z/OS Connect to modernize the access to DB2 for z/OS assets creating restful APIs. At both former employers developed extensive experience installing, using, and supporting Db2 ISV Tooling.
Abstract:
As a member of the IBM Development SWAT team conducting IBM Db2 360 Studys we have seen a variety of different Db2 maintenance strategies, SMP/e environment configuration, deployment methods, and Db2 patch management concepts. We will discuss IBM best practices for Db2 for z/OS maintenance strategy, SMP/e environment configuration, patch management, and deployment.
Title: Declared Global Temporary Tables (DGTT) user stories
Kurt Struyf
Bio:
Kurt Struyf is an independent consultant/contractor and president of Lone Star consulting. He has over 25 years experience as a (system) DBA and has been installing, migrating, troubleshooting and tuning DB2 systems throughout Europe. Besides his consultancy missions he has been teaching a broad spectrum of DB2 classes, both in Europe and the USA. These classes range from basic courses like DB2 fundamentals and SQL workshops, over database administration and system administration classes, to system and application recovery and tuning workshops. He was been a speaker at several large European and North America conferences. Kurt is an IBM information Champion and IBM gold consultant
Abstract:
Declared Global Temporary Tables (DGTT) have been around for some time, this presentation will focus on best use cases from customers.We will address the different kind of Temporary Tables in Db2, together with their advantages and disadvantages.This presentation will show some performance use cases, where DGTTs, brought a big performance benefit to customers.
Title: Code Your Db2 Applications for Performance from the Start!
Craig Mullins
Bio: Craig Mullins is president & principal consultant of Mullins Consulting, Inc. and an in-demand analyst, author and speaker. He has over three decades of experience in all facets of database systems development including creating and teaching database classes, systems analysis and design, data analysis, database administration, performance management, and data modeling. Craig has worked with Db2 on the mainframe since Version 1 and has experience working with other database technologies. IBM appointed Craig as a Gold Consultant for Db2 and as an IBM Champion for Data & AI. Furthermore, Craig was named a Top 200 Thought Leader in BigData & Analytics by AnalyticsWeek and Big Data. And Red Gate appointed Craig one of the 100 most influential in the database community. Craig is a prolific writer, having authored articles for popular journals and websites including the monthly DBA Corner column for Database Trends and Applications. And Craig has authored several books, including the best selling DB2 Developer's Guide and his latest book, A Guide to Db2 Application Performance for Developers.
Abstract:
Assuring the performance of Db2 applications is a very time-consuming management aspect of IT. End users and developers experience performance pains sometimes daily and DBAs continually struggle to adjust parameters, code and database design to improve and tune things. But the cause of most database application performance issues can be traced back to the SQL and application code. If developers better understood how to code for Db2 performance from the outset, a lot of pain and suffering could be eliminated.
In this presentation we will look at performance basics, coding techniques, SQL issues, indexing, and more, with an eye toward helping you to build more efficient Db2 applications.