2024 Db2/DevOps Track

By Michal Bialecki, IBM Poland and Daniel Ratcovich, BMC, SE
By Haakon Roberts, IBM, US

Session Evaluation

Db2 for z/OS - Trends and Directions. 

 

1. Review Db2 for z/OS strategic direction.
2. Take stock of current technology now in V13.
3. Explain what the Db2 for z/OS development team will be working on next and why.
By Susan Lawson, YL&A, US

Session Evaluation

 

Every new release of Db2 brings a bunch of features aimed at improving application performance, data availability, and development capabilities. This session guides you through the exceptional features in Db2 12 (+FLs and APARs) and 13 that will boost your performance, ensure maximum data availability, and streamline application development. We will focus on the features, including the latest function level ones, that can be used by both DBAs and application programmers to ensure efficiency and effectiveness.
• Overall improvements and goals in Db2 z/OS 12/13 (+FLs and APARs)
• Features for improved application and database performance
• Features for improved application and database design
• Usage features for improved application performance
• Discuss new features delivered in latest function levels
By Jørn Thyssen, Rocket Software, DK

Session Evaluation

Db2 V13 Utility History.

 

Db2 13 introduced the ability to track execution of IBM Db2 utilities allowing users to gain insight into the performance of the utilities. In this session you will hear how it has been implemented, what information is recorded and when, and some ideas of how the feature can be used to improve your utility processing
By Bart Steegmans, IBM

Session Evaluation

Mythbusters: Db2 latches vs. page latches vs. IRLM locks.

There is a lot of confusion and misconception about the different serialization mechanisms used by Db2 for z/OS (locks and latches ; claims and drains) ; what they mean ; how and when they are used ; and what impact they have on applications.In this session we will set the record straight. We will explore the different serialization mechanisms used by Db2 for z/OS ; what they are used for ; how you can determine that they are impacting your performance and how to address those performance issues in case they arise.
By Marcus Davage, BMC

Session Evaluation

Squeeze your Data with Db2.

 

This intermediate level presentation quickly covers the history of compression in Db2 for z/OS, from V3.1 to Db2 12.  We will review the original tablespace row compression, index compression, LOB compression, and Huffman compression, with a glance at some application performance considerations.
By Aysen Svoboda, Broadcom

Session Evaluation

Db2 13 for z/OS introduced several new features that have an impact on PBG and PBR table spaces. This presentation will cover the fundamentals of table space concepts and introduce these new features. The discussion will answer questions, such as what these features are, why they are necessary, and how they can be implemented, including best practices around implementation.

By Haakon Roberts, IBM, US

Session Evaluation

Online schema - The Present and the Future

1. Understand what IBM's strategy is for application availability improvements when making schema changes.
2. Review recent improvements in online schema processing in both V12 and V13 of Db2 for z/OS.
3. Look to the future to explain what you can expect to see in the next year or two that are planned to deliver massive improvements in this area. 
By Claus E Mikkelsen, Nordea, Denmark

Session Evaluation

High Performance DBAT in DB2.

 

Experiences from launching High Performance DBATs in Nordea. How to implement, measure and follow-up.
By Marie Ivansson, IBM

Session Evaluation

1. Enhanced SQL optimizer path selection can save DBA’s up to 30% of their time by managing application performance and queries more effectively and efficiently
• Improves access paths by predicting likely SQL behavior and applying additional runtime optimization.
• Automatically stabilizes dynamic queries and supports the ability to lock/unlock the access path.
• Automatically self-tune access paths.

2. Distributed Connection Control -- protects Db2 for z/OS from unintentional disruptions and intrusions that may originate from remote applications
• Uses AI to learn distributed connection behavior to control connection flooding.
• Automatically learn and visualize connection and thread behavior.
• Creates warning and exception alerts with additional connector/thread information

3. Systems Assessment -- analyzes Db2 subsystems for best practices to help reduce the need for costly application optimization and tuning and can improve database performance
• Uses AI to learn what’s normal and perform exception-based analysis.
• Provides recommended actions and correlations for each exception based on Db2 SME knowledge and speeds up analysis.
• Automatically collects key performance information allowing you to visualize KPIs to simplify analysis of data sharing groups, subsystems, and application connection level performance insights.

4. Dynamic Dashboard – Analyze trends with a dynamic graphs.
• drill up and down through all systems to analyze CPU consumption.

By Michal Bialecki, IBM Poland

Session Evaluation

Db2 z/OS meets WLM - 101 basics, stories of common mistakes, pitfalls and failures.  

 

This presentation is based on Db2 z/OS development 360 studies experiences performed by
SWAT team, which Michal is part of.
It will discuss following matters
- explains basics of WLM on z/OS concepts
- how WLM can help in running Db2 workload smoothly in worst scenario conditions or in case
of workload failing over
- what are common pitfalls and ways to avoid them
- what are best practices for setting up Db2 address spaces and application goals
- how to monitor how the goals are met, and what may be bottlenecks, and how to address
them
By Bart Steegmans, IBM

Session Evaluation

 Measuring is knowing - Db2 for z/OS instrumentation enhancements you may have missed.

To analyze performance, Db2 has a wealth of metrics to look at.
Each version, function level or even just with regular maintenance, these instrumentation metrics are being enhanced.
This session will go over the V12 and V13 instrumentation enhancements to bring you up to date with all the latest and greatest IFCIDs and counters. We will also look at when and how to best exploit this information.