Modern Db2 for z/OS Physical Database Design – 2022 Edition

Download PDF

Watch recording (logged in Tridex members only)

Session title: Modern Db2 for z/OS Physical Database Design – 2022 Edition

Session abstract: I presented in modern Db2 for z/OS database design for a TRIDEX meeting in 2015, and a lot has changed since then.

In this updated presentation I’ll cover newer Db2 for z/OS physical database design-related topics such as relative page numbering, online migration from multi-table table spaces to universal PBG table spaces, online migration from PBG to PBR, new perspectives in LOB data types, and more.

Speaker biography: Robert Catterall is a Principal Db2 for z/OS Technical Specialist with IBM. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company’s Db2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent Db2 consultant, he rejoined IBM in 2010. Robert is a past President of the International Db2 Users Group (IDUG), and a member of IDUG’s Speakers Hall of Fame. He presents frequently at conferences and user group meetings, and blogs about Db2 for z/OS at http://robertsdb2blog.blogspot.com/.