Stream: Virtual Room 2
Time: 09:00 - 10:00
In this presentation we focus on two recent enhancements related to UTS migrations:
Multi-table table spaces are deprecated and while they are still supported by Db2 (and can still be created!) they do have several challenges. We will cover the enhancements from V12 function level 508 that allows you to migrate to PBG as a pending alter with minimal outage.
There are also 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.
In this presentation we explore all the details: why convert, how to convert, limitations and restrictions, best practices for the materializing REORG, and some non-scientific measurements.
Jørn Thyssen has worked more than 19 years on the mainframe platform as a developer, application DBA, application architect, technical field specialist, and more recently as a Db2 tools product specialist for Rocket Software. He is also an 2020 IBM Champion
Jørn Thyssen has worked more than 19 years on the mainframe platform as a developer, application DBA, application architect, technical field specialist, and more recently as a Db2 tools product specialist for Rocket Software. He is also an 2020 IBM Champion
Jørn Thyssen has worked more than 19 years on the mainframe platform as a developer, application DBA, application architect, technical field specialist, and more recently as a Db2 tools product specialist for Rocket Software. He is also an 2020 IBM Champion
Jørn Thyssen has worked more than 19 years on the mainframe platform as a developer, application DBA, application architect, technical field specialist, and more recently as a Db2 tools product specialist for Rocket Software. He is also an 2020 IBM Champion
Click here to give some Feedback so we can make it even better next year!