Migration of multi-table tablespaces to UTS PBG
Difficulties to migrate from old tablespace types to UTS.
DB2 V10 gives us the opportunity to use the ALTER-syntax to change tablespace type from SIMPLE or SEGMENTED to UTS PBG without (almost) any outage. Unfortunately there is a limitation which makes this change possible only to table spaces containing one table.
We have some tablespaces of type SIMPLE and SEGMENTED that contains several tables. We want to avoid closing the services that use these tables, so we don't want to DROP and re-CREATE these tables in new table spaces. This means we can't convert all existing simple table spaces until IBM provides functionality to implement this change in the ALTER syntax.