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:
11:00 AM - Welcome - Bill Moran
11:05 AM - Introductions - Bob Vargo
11:10 AM - Nuts and Bolts of Db2 z/OS Recovery - Chad Reiber
12:10 PM - How to save resources by tuning your DEAD(LOCKS) - Shay Miller
1:10 PM - IBM Developer Extension - Brian Tsao
2:10 PM - Wrap up - Bob Vargo
Title: Nuts and Bolts of Db2 z/OS Recovery
Chad Reiber
Bio: In 1983 Chad Reiber started in IT with AT&T as a developer of data generator software. From there he moved into the database arena as a database administrator for IMS, IDMS, and Db2. Chad has been working with Db2 since 1987. Chad began working for BMC Software in 1997 as a Software Consultant and primarily supports all aspects of BMC’s Mainframe products for the Northeast Db2 community.
Abstract:
As a Db2 Database Administrator we are pulled into multiple situations. The most important is when a recovery is needed. This presentation takes us back to the basics when it comes to Db2 z/OS Recovery.
Every day our critical Db2 systems take image copy after image copy of production Db2 databases. Why? Well, there are many answers but the most important is for recovery. This presentation will describe Db2 Recover from start to finish. It is not all about how to physically recover but why you choose one method over another.
Db2 Releases over the years have increase the capability of Recovery to address data availability and data retention. Back to Basic presentation will describe how this change can influence how to address a recovery scenario.
The attendee will leave the presentation with a new foundation of Db2 Recovery
Title: How to save resources by tuning your DEAD(LOCKS)
Shay Miller
Bio:
With over two decades of experience in DB2 for z/OS, Shay Miller is a seasoned Database Administrator (DBA) specializing in both system and application administration. Since 2001, he has developed expertise in designing, building, and tuning database objects, application programs, and SQL queries. Shay has worked across various industries, including a 7-year tenure at IDF, and since 2008, at FIBI.
In addition to his technical expertise, Shay has more than 20 years of experience in educating and mentoring others in the fields of DB2 and z/OS. He has developed and delivered training to a wide range of audiences, including DBAs, programmers, operators, and senior management. Shay's educational contributions include creating training materials and presenting at industry events, such as the IDUG NA conference in Charlotte (2024).
In 2022, Shay transitioned to freelance work, teaching commercial DBA courses and training a new generation of DBAs. He is fluent in both Hebrew and English, enabling him to engage with diverse audiences.
Shay's passion for DB2 and z/OS continues to drive his career, focusing on improving system performance and sharing knowledge within the community.
Abstract:
Introduction of FIBI.
How a deadlock situation occurs.
Deadlock effects
Effects on the victim program: - 911 + possible rollback.
Explain logging done by an updating process.
Explain log processing done by DB2 at ROLLBACK.
Effects of long ROLLBACK on the system/other programs running during the ROLLBACK.
Tips for (application and system):
Minimize DEADLOCKS events.
Minimize ROLLBACK effects described prior.
How DB2 discover DEADLOCKs and acts upon them.
Deadlock reporting done by DB2 and how to monitor DEADLOCKS in the system.
How DB2 choses who is the victim.
NEW in DB2 13 - influencing who is chosen to be the victim.
DEADLOCK detection interval parameter: Where is it.
Possible values and meaning.
Commands to show/change values dynamically.
Display work done at FIBI to tune the interval parameter:
State at start of the project.
Working thoery and data collection.
Display tuning stages that were executed.
Display results - massive (>80%) CPU reduction of IRLM STC.
Title: IBM Developer Extension
Brian Tsao
Bio: Brian is a development tech lead working on the Db2z developer extension. Having designed many impactful features on the developer extension, Brian is passionate about enhancing developer productivity. Constantly advocating for innovative solutions, Brian places a high value on user feedback, ensuring tools are both intuitive and effective.
Abstract:
The Db2z Developer Extension provides developers with a lightweight, efficient solution for working with Db2 for z/OS, seamlessly integrated into one of the most popular IDEs today: Visual Studio Code. This extension empowers developers with a suite of powerful tools, including Db2z SQL syntax highlighting, SQL execution and tuning, database catalog navigation, and stored procedure development, among other capabilities. Designed for seamless collaboration, the extension works in harmony with other tools in the Visual Studio Code ecosystem, such as IBM's Zowe Explorer and Z Open Editor, as well as community-developed extensions.
In this session, we’ll explore the key features of the Db2z Developer Extension, share insights into our vision for its future, and demonstrate how you can actively contribute by submitting enhancement requests and bug reports to our development team. Whether you’re new to Db2z application development or an experienced user, this session will offer valuable insights to boost your productivity and collaboration.