2024 - Db2/DevOps
2024 Db2/DevOps Track
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 3617
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 3818
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. |
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 3536
| 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 |
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 3523
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 |
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 3634
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. |
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 3830
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. |
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 4642
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.
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 3859
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. |
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 3766
High Performance DBAT in DB2.
| Experiences from launching High Performance DBATs in Nordea. How to implement, measure and follow-up. |
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 2920
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 3716
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 |
- Details
- Parent Category: 2024 Copenhagen
- Category: 2024 Db2/DevOps Track
- Hits: 2603
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. |