The Definite Guide to PBG to PBR conversion with Db2 v13

There are many challenges and restrictions with UTS PBG table spaces as they grow large, e.g., degradation of insert and query performance, limited partition level utility support, managing indexes (they are all NPI), and much more.

One of the key features of Db2 V13 is the ability to convert a UTS PBG table space to a UTS PBR RPN tablespace as a pending alter where the application outage is limited to the switch phase and any REBINDs. In this presentation we explore all the details: why convert, how to convert, limitations and restrictions, and some non-scientific measurements.