Final Push to get you over the UTS Finish Line!
IBM is strongly hinting at end of support for non-UTS objects with V Next.
Deprecation of non-UTS objects was announced in 2019. Most shops have done the heavy lifting, but are not fully converted. This session will get you across the finish line.
Session will review the conversion processes, and show least-effort, vendor- neutral techniques to complete these tasks with the minimum amount of administration time.
Techniques will show generation with base functions of any vendor admin tool, as well as native SQL to generate the conversion code for:
• Convert simple single table spaces to PBG
• Convert IX controlled Partitioning to PBR
• And the tough one…..
Convert Multi-Table Tablespaces to Single-Table PBG
• Examples provided to automate this complex process using standard admin product functions, and sample SQL to do outside of administration products. Samples will generate:
o DDL to create new PBG
o Move Table DDL to match up new PBG TS->TB
o Reorg Generation
These processes will scale! Convert tens or thousands with the same administration effort!
Get across the UTS finish line and be ready for V next!