Per (ID 1335) Technical bulletin: Recommendation to convert non-UTS product table spaces to UTS - IBM has deprecated the creation of the following types of table spaces:

Simple
Segmented
Index-controlled
Table-controlled

How do customers convert BMC AMI Log Master Repository non-UTS multi-table tablespaces to UTS?

The examples below illustrates the correct procedure for converting a BMC AMI Log Master Repository non-UTS multi-table (or any non-UTS multi-table table spaces) to UTS table spaces for customers with DB2 V12 FL508.

Please note: Function Levels below FL508 do not have the "Move Table" option. Customers with Change Manager can convert the tablespaces using an alternative method - please see Knowledge Article 000197282. Customers with Function Levels below FL508 and who do not have Change Manager will need to unload the tables in question, drop the non-UTS multi-table tablepsace, re-create their Log Master tables in new UTS tablespaces (1 UTS tablespace per table), and load the new tables.

In the example that follows there is one non-UTS table spaces containing 3 tables. The result of the process results three UTS table spaces with one table each.

The Db2 objects:
•    Table space BMCALP.ALPFSSP
  o    Table BMCALP.ALPFLTH
  o    Table BMCALP.ALPFLIN
  o    Table BMCALP.ALPDRLN

Step 1:  Create the UTS table spaces that will be the target of the table moves.
•    CREATE TABLESPACE ALPFLTH IN BMCALP
        MAXPARTITIONS 1
        DEFINE NO
•    CREATE TABLESPACE ALPFLIN IN BMCALP
        MAXPARTITIONS 1
        DEFINE NO
•    CREATE TABLESPACE ALPDRLN IN BMCALP
        MAXPARTITIONS 1
        DEFINE NO

Step 2:  Alter the table space moving the tables to their respective targets.
•    ALTER TABLESPACE BMCALP.ALPFSSP     
        MOVE TABLE BMCALP.ALPFLTH         
        TO TABLESPACE BMCALP.ALPFLTH;  
•    ALTER TABLESPACE BMCALP.ALPFSSP     
        MOVE TABLE BMCALP.ALPFLIN         
        TO TABLESPACE BMCALP.ALPFLIN;
•    ALTER TABLESPACE BMCALP.ALPFSSP
        MOVE TABLE BMCALP.ALPDRLN         
        TO TABLESPACE BMCALP.ALPDRLN;

Step 3:  Materialize the changes.
•    LISTDEF REORG1 INCLUDE TABLESPACE BMCALP.ALPFLTH
                     INCLUDE TABLESPACE BMCALP.ALPFLIN
                     INCLUDE TABLESPACE BMCALP.ALPDRLN    
TEMPLATE COPYDS DSN hlq.&DB..&TS..FCOPY
REORG TABLESPACE LIST REORG1                      
        SHRLEVEL CHANGE COPYDDN(COPYDS)

Step 4:  Results.
The Db2 objects:
•    Table space BMCALP.ALPFLTH
o    Table BMCALP.ALPFLTH
•    Table space BMCALP.ALPFLIN
o    Table BMCALP.ALPFLIN
•    Table space BMCALP.ALPDRLN
o    Table BMCALP.ALPDRLN
Note, the original source table space, BMCALP.ALPFSSP, still exists and can be dropped at this point.

For a customer’s table spaces the procedure described above may need to be adjusted. Due to utility processes already in place, they may be averse to changing the source table space name. Follows a modification of the above process to accommodate this.

The Db2 objects:
•    Table space BMCALP.ALPFSSP
  o    Table BMCALP.ALPFLTH
  o    Table BMCALP.ALPFLIN
  o    Table BMCALP.ALPDRLN

Step 1:  Create the UTS table spaces that will be the target of the table moves.  Note, the first table space, BMCALP.ALPFLTH, is omitted.
•    CREATE TABLESPACE ALPFLIN IN BMCALP
        MAXPARTITIONS 1
        DEFINE NO
•    CREATE TABLESPACE ALPDRLN IN BMCALP
        MAXPARTITIONS 1
        DEFINE NO

Step 2:  Alter the table space moving the tables to their respective targets.  Note, the move of the first table is omitted.
•    ALTER TABLESPACE BMCALP.ALPFSSP     
        MOVE TABLE BMCALP.ALPFLIN         
        TO TABLESPACE BMCALP.ALPFLIN;
•    ALTER TABLESPACE BMCALP.ALPFSSP
        MOVE TABLE BMCALP.ALPDRLN         
        TO TABLESPACE BMCALP.ALPDRLN;

Step 3:  Materialize the changes.  Note, tablespace BMCALP.ALPFLTH is omitted, and the original source non-UTS table space is included.
•    LISTDEF REORG1 INCLUDE TABLESPACE BMCALP.ALPFSSP
                     INCLUDE TABLESPACE BMCALP.ALPFLIN
                     INCLUDE TABLESPACE BMCALP.ALPDRLN    
TEMPLATE COPYDS DSN hlq.&DB..&TS..FCOPY1
REORG TABLESPACE LIST REORG1                      
        SHRLEVEL CHANGE COPYDDN(COPYDS)

Step 4:  Results.
The Db2 objects:
•    Table space BMCALP.ALPFSSP        non-UTS
o    Table BMCALP.ALPFLTH
•    Table space BMCALP.ALPFLIN        UTS
o    Table BMCALP.ALPFLIN
•    Table space BMCALP.ALPDRLN    UTS
o    Table BMCALP.ALPDRLN

Step 5:  The source non-UTS table space needs to be converted.
•    ALTER TABLESPACE BMCALP.ALPFSSP MAXPARTITIONS 1;
•    LISTDEF REORG1 INCLUDE TABLESPACE BMCALP.ALPFSSP
      TEMPLATE COPYDS DSN hlq.&DB..&TS..FCOPY
REORG TABLESPACE LIST REORG1                      
        SHRLEVEL CHANGE COPYDDN(COPYDS)

The original source table space, and the two new table spaces, are all UTS