Upgrading the TEMPLATE control table

When you migrate to a new version of Db2, you can upgrade the TEMPLATE control table to the current Db2 version.

To upgrade the TEMPLATE control table:

1. On the DB2 Administration Menu (ADB2) panel, specify option 5, and press Enter.
2. On the Utility generation using LISTDEFs and TEMPLATEs (ADB25) panel, specify option UT, and press Enter.

   ADB25 min ----- DD1A Utility generation using LISTDEFs and TEMPLATEs ---- 00:33
   Option ===>                                                                    
                                                                                  
      L - Manage LISTDEFs                                   DB2 System: DD1A      
      T - Manage TEMPLATEs                                  DB2 SQL ID: ADM001     
     TU - Specify TEMPLATE usage                                                  
                                                                                  
     CL - Create LISTDEF control table                                            
     UL - Upgrade LISTDEF control table                                           
     CT - Create TEMPLATE control table                                           
     UT - Upgrade TEMPLATE control table                                          
                                                                                  
    LISTDEF control table:                                                        
        Table owner . . . DSNACC   >                                              
        Table name  . . . UTLIST            >                                     
                                                                                  
    TEMPLATE control table:                                                       
        Table owner . . . DSNACC   >                                              
        Table name  . . . UTTEMPLATE        >    

   The table name is validated to make sure it is a TEMPLATE control table. The validation is based on the following column names and data types:

   • NAME VARCHAR(8),
   • CREATEDBY VARCHAR(8),
   • MODIFIEDBY VARCHAR(8),
   • DSN VARCHAR(254),
   • DISPSTATUS VARCHAR(3),
   • DISPNTERM VARCHAR(7),
   • DISPATERM VARCHAR(7),
   • DEVICETYPE VARCHAR(8),
   • MODELDCB VARCHAR(53),
   • BUFNO SMALLINT,
   • DATACLAS VARCHAR(8),
   • MGMTCLAS VARCHAR(8),
   • STORCLAS VARCHAR(8),
   • DSVOLSER VARCHAR(1784),
   • GDGLIMIT INTEGER,
   • EXPDL VARCHAR(10),
   • RETPD INTEGER,
   • UNITTYPE CHAR(1),
   • PQTY INTEGER,
   • SQTY INTEGER,
   • SPACEUNIT VARCHAR(3),
   • PCTPRIME INTEGER,
   • MAXPRIME INTEGER,
   • NBRSECND INTEGER,
   • UNCNT SMALLINT,
   • STACK CHAR(1),
   • JES3DD VARCHAR(8),
   • TRTCH VARCHAR(6),
   • REMARKS VARCHAR(254),
   • VOLCNT SMALLINT.

   If the TEMPLATE control table name is not at the current version, the control table is upgraded.