61288: The Definite Guide to PBG to PBR conversion with Db2 v13
Project and Program:
Performance and Capacity Management,
Application Development,
Databases,
Application Architecture
Tags:
Proceedings,
SHARE Atlanta 2023
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.
Back to Proceedings File Library