Jørn Thyssen

  • Jørn Thyssen

  • S206 - The Definite Guide to PBG to PBR conversion with Db2 v13

    Session Evaluation

    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.

  • S209 - Db2 for z/OS Utilities Update

    Session Evaluation

    The Db2 for z/OS Utilities Suite plays an essential role for virtually every Db2 environment and it remains an area of intense development, continually delivering significant improvements in usability, performance and availability. This talk will look at what has been delivered in 2021, 2022 and 2023 and explain why these improvements matter to you.