IDUG Brazil 2026

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.)