Universal Tablespaces (UTS) have been the strategic tablespace types for Db2 for z/OS since Version 9, effectively rendering legacy tablespaces obsolete. But what truly lies beneath the surface? Why has IBM designated UTS as the future of data storage? In this session, we will place the Universal Tablespace on the operating table for a surgical comparison against legacy objects. We will examine the internal anatomy of Partition-by-Growth (PBG) and Partition-by-Range (PBR) tablespaces. By dissecting the underlying page structures, space map management, and segmentation logic, we will reveal exactly what makes UTS special. Join us for a deep dive into the bits and bytes of Db2 storage to understand why the transition to UTS is not just a recommendation, but a necessity for modern database performance and management.
Emil is a software architect at Broadcom Mainframe Software, he holds a Ph.D. in Mathematical Engineering, is a member of the IDUG Content Committee, and an IBM Champion since 2015.
Tuesday September 29, 2026 11:30am - 12:30pm BST Miragaia
