2025 - Db2/DevOps
2025 Db2/DevOps Track
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 4262
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 4480
The objectives of this double session are to learn recommended best practice, learn from the good, bad and ugly experiences from other installations and to provide answers to important, frequent or difficult questions. Part 1 will cover the following topics: Online removal of active log dataset, Online migration from PBG UTS to PBR UTS table spaces, ALTER TABLE DATA CAPTURE concurrency enhancement, User controls to improve the ability for SQL DDL operations to succeed and/or reduce application service, RUNSTATS and Page-level Sampling, WLM and DDF High Performance DBATs, DDF system parameters MAXCONQN and MAXCONQW, Misunderstanding about DDF sysplex workload balancing. Part 2 will cover the following topics: Enhancements to Fast Traversal Block (FTB) feature, Considerations using Contiguous Buffer Pool, Use of large index page size, Changes in behavior after migrating to UTS, War story about insert processing with MEMBER CLUSTER, Considerations when collecting column frequency statistics, Increase in false lock contention when using data sharing.
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 4237
What is new in Db2 13 for application developers? Let's explore these topics in this session. We will cover SQL related enhancements (more granular concurrency control, SQL DI, …) as well as performance improvements (FTB enhancements, sort enhancements, …) that application developers can benefit from.
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 4199
The ability to explore, analyze, and visualize data is becoming a hot topic. As DevOps is adapted by the mainframe community the developers show an increasing interest in the Ops side, i.e., being able to monitor and view the health of an application. While showing data in 3270 is not bad there are many advantages of using modern tooling to visualize data.
In the first half of the presentation, we will give a high level introduction to modern open source visualization tools like Kibana and Grafana.
In the second half of the presentation we will explore several use cases of interest to Db2 for z/OS DBAs and application owners and developers, such as viewing Db2 real time statistics, Db2 utility history and Db2 performance metrics. Ultimately this allows you to build dashboards tailored to individual applications.
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 4246
Db2 for z/OS continues to improve the performance monitoring in various ways based on our customers’ needs. This session discusses the latest performance monitoring information for Db2 for z/OS that have were added in Db2 13 and continuous delivery. It includes the recommended set of data collection for various situations, updates on key performance metrics to monitor, as well as performance diagnostic updates.
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 4446
The objectives of this double session are to learn recommended best practice, learn from the good, bad and ugly experiences from other installations and to provide answers to important, frequent or difficult questions. Part 1 will cover the following topics: Online removal of active log dataset, Online migration from PBG UTS to PBR UTS table spaces, ALTER TABLE DATA CAPTURE concurrency enhancement, User controls to improve the ability for SQL DDL operations to succeed and/or reduce application service, RUNSTATS and Page-level Sampling, WLM and DDF High Performance DBATs, DDF system parameters MAXCONQN and MAXCONQW, Misunderstanding about DDF sysplex workload balancing. Part 2 will cover the following topics: Enhancements to Fast Traversal Block (FTB) feature, Considerations using Contiguous Buffer Pool, Use of large index page size, Changes in behavior after migrating to UTS, War story about insert processing with MEMBER CLUSTER, Considerations when collecting column frequency statistics, Increase in false lock contention when using data sharing.
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 5250
How you can access Db2 via REST services, the Java CLP, the Zowe CLI and Python.
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 4489
Final Push to get you over the UTS Finish Line!
IBM is strongly hinting at end of support for non-UTS objects with V Next.
Deprecation of non-UTS objects was announced in 2019. Most shops have done the heavy lifting, but are not fully converted. This session will get you across the finish line.
Session will review the conversion processes, and show least-effort, vendor- neutral techniques to complete these tasks with the minimum amount of administration time.
Techniques will show generation with base functions of any vendor admin tool, as well as native SQL to generate the conversion code for:
• Convert simple single table spaces to PBG
• Convert IX controlled Partitioning to PBR
• And the tough one…..
Convert Multi-Table Tablespaces to Single-Table PBG
• Examples provided to automate this complex process using standard admin product functions, and sample SQL to do outside of administration products. Samples will generate:
o DDL to create new PBG
o Move Table DDL to match up new PBG TS->TB
o Reorg Generation
These processes will scale! Convert tens or thousands with the same administration effort!
Get across the UTS finish line and be ready for V next!
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 4387
WLM Enclaves have been available for about 28 years, but enclaves, and associated measurements, are still widely misunderstood. DB2 makes heavy usage of enclaves, and with the expansion of DB2 DBATs and High Performance DBATs, using and interpreting the WLM measurements to evaluate DB2 workloads has become both more important and more difficult. During the presentation Peter Enrico will demystify WLM enclaves, DB2’s usage of enclaves, and also demystify associated measurements used to evaluate WLM management of DB2 workloads.
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 3527
Analyzing Db2 for z/OS performance problems can be overwhelming. There is a lot of information available in Db2 , z/OS, ... so it is important that you know where to look and what to look at.
This session will discuss a number of real customer problems, what info to collect, and how to analyze and interpret the data to find the heart of the problem.
While the focus will be on Db2, but as Db2 performance is closely related to how the overall z/OS system is doing, the session will also explore a number of z/OS key metrics to see whether the issue you experience in Db2 might be part of a larger system problem or not.
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 4330
Distributed workload is becoming more prevalent, and for many customers it is a significant part of the overall Db2 for z/OS workload.
In this presentation we will recap the Db2 IFCID records available that allow you to monitor your distributed workload including new ones added since last year.
We will also dive into typical use cases, such as identifying badly behaving applications, e.g., not using TLS, using old drivers, and more.
We will also cover how to correlate the different trace records. For example, you might have identified a misbehaving application but want to know the user and IP address or vice versa.
Finally, we will show some examples of how to visualize the data into dashboards.
- Details
- Parent Category: 2025 Gothenburg
- Category: 2025 Db2/DevOps Track
- Hits: 3135
This session explores backup and recovery strategies for Db2 for z/OS, emphasizing the critical importance of compliance and recoverability in today’s data-driven world. Attendees will learn about various backup types, tools, and recovery processes, with a focus on creating resilient systems that align with modern compliance requirements. Through use cases, the session will demonstrate how to ensure recoverability, data integrity, minimizing downtime, and maintaining availability.