Can CA Gen Host Encyclopedia (HE) table spaces be converted to Universal Table Spaces (UTS)

Document ID : KB000124457
Last Modified Date : 16/01/2019
Show Technical Document Details
Introduction:
DB2 v9 introduced a new type of table space known as a universal table space (UTS) which provides "partition-by-range" capability and is now the recommended option to use.
Question:
By default a CA Gen Host Encyclopedia (HE) is created to use partitioned (non-UTS) table spaces. Can those tablespaces be altered to be universal table space (UTS) without any negative impact on the HE functionality?
Environment:
CA Gen Host Encyclopedia (HE) 8.x
Answer:
The Gen 8.x Host Encyclopedia has not been tested with UTS and it is therefore not supported. So although the change may not cause any negative impact if it is implemented then it would be at own risk.
Additional Information:
"Converting partitioned (non-UTS) table spaces to partition-by-range universal table spaces"
DB2 v11: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/admin/src/tpc/db2z_converttspbr.html
DB2 v12: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/admin/src/tpc/db2z_converttspbr.html