How can I convert BMC Classic Segmented Tablespaces to Universal Tablespaces (UTS) for DB2 V12, as IBM recommends?

There is no mandatory requirement to use Universal Tablespaces in DB2 databases used by BMC products. They can continue being Segmented with no impact to the operation of BMC Products.

However, if you want to follow the IBM's recommendation to use Universal Tablespaces, you can ALTER existing BMC Classic Segmented tablespaces using MAXPARTITIONS 5 clause.

You can use a query like this to generate the required ALTER Statements:

--#SET TERMINATOR @
SELECT 'ALTER TABLESPACE '||
        RTRIM(DBNAME) ||'.'||
        RTRIM(NAME) ||
        ' MAXPARTITIONS 5;'
FROM SYSIBM.SYSTABLESPACE
WHERE DBNAME LIKE '%BMC%' -- Replace with a Search Condition for the
                          -- names of BMC products databases
                          -- used at your installation
AND SEGSIZE > 0        -- Segmented TSs
AND PARTITIONS = 0     -- Non-Partitioned
AND MAXPARTITIONS = 0  -- Non-UTS
AND NTABLES = 1        -- Single table TSs
ORDER BY 1 @

In this query you would possibly just need to modify the search condition to list the databases used for BMC products in your installation.

Important notes:

• The above query applies to BMC Tablespaces that contain a single table. BMC tablespaces that contain more than one table will be addressed in the next OZI release.
• After executing these ALTER statements you will need to execute an online REORG to materialize the conversion to Partition-By-Growth Universal Tablespaces (ALTER TABLESPACE... MAXPARTITIONS n is a 'pending change' when converting a Segmented TS to a PBG, Universal TS).
• In the search condition against the DBNAME column in the above query, you need to use the names of BMC products' databases used in your installation. In general, the default names for databases used by BMC products include the 'BMC' string in them, but you can validate the specific default names for the different products on Page 304, Appendix E Configuring BMC products for DB2, of Installation System Reference Manual Supporting Version 3.1.00 and later of Installation System - December 2016.