
IDUG Brazil 2026
17. August @ 08:00 – 19. August @ 17:30 BRT
Besuchen Sie uns in der Expo
SOFTWARE ENGINEERING & Itaú Unibanco präsentieren:
A08 | Db2 for z/OS – Know your Limits! [Download PDF]
Abstract:
This session will show and explain how to reliably monitor and manage critical limits within Db2 on z/OS along with real world examples from Banco Itaú. Starting with relatively basic simple things like DSSIZE or PIECESIZE. Moving on to Linear Dataset limits (32 for segmented spaces, 254 for LOB). We then will have a quick look at how the COPYPOOL is looking before diving off to the world of PBGs, where you must be aware of MAXPARTITONS among other things. Then we will review SEQUENCES and Numeric Primary Key usage before finally delving into the abstract limit of Db2 within the Db2 engine including DBATs etc.
Objectives:
1. DSSIZE or PIECESIZE among other basic simple things
2. Linear Dataset limits (32 for segmented spaces, 254 for LOB)
3. COPYPOOL
4. PBGs & MAXPARTITIONS
5. SEQUENCES and Numeric Primary Key usage
6. Abstract limit of Db2 (DBATs etc.)
Speaker bios:
Daniel Eli Abreu Torres is a Senior IT Platform Engineer at Itaú Unibanco, specializing in Db2 z/OS environments that support large‑scale, mission‑critical workloads. He serves as a technical focal point for production stability, incident management, monitoring, and complex Db2 operational changes, working closely with DBAs and IBM specialists.
Ulf Heinrich specializes in Db2 recovery and operations, managing cost reduction, and 24×7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under real-world disaster pressure. Ulf contributes to the ZOWE community since day one and helps customers implementing, customizing, and managing modern z/OS/USS solutions. His activities cover EMEA, as well as Americas. As a member of SE’s Request Board, he’s working closely with customers and the development labs. As a member of the TRIDEX.org Board of Directors, he’s proud to support the Db2 community in the greater NY area.

