DSNTIP00: Activate a function level panel

Use the DSNTIP00 panel to specify a target function level and other related settings.

 DSNTIP00               ACTIVATE A FUNCTION LEVEL FOR DB2                       
 ===>                                                                           
                                                                                
 Enter the current and target DB2 function levels:                              
   1 CURRENT FUNCTION LEVEL===>           (DB2's current function level)        
   2 TARGET FUNCTION LEVEL ===> V12R1M500 (Function level to be activated)      
                                                                                
 Enter the default application compatibility level:                             
   3 APPL COMPAT LEVEL     ===> V12R1M500 (DB2 function level or V11R1 or V10R1)
                                                                                
 Enter the default SQL level for the precompiler:                               
   4 PRECOMPILER SQL LEVEL ===> V12R1M500 (DB2 function level or V11R1 or V10R1)
                                                                                
                                                                                
 PRESS:  ENTER to continue   RETURN to exit   HELP for more information

The purpose of this panel depends on the value of the USE Z/OSMF WORKFLOW field on panel DSNTIPA1:

When the USE Z/OSMF WORKFLOW field value is NO, the CLIST uses the settings specified on this panel to customize jobs for migration to Db2 12 at function level V12R1M100. Then you can use the ACTIVATE function of the CLIST to activate function level 500 or higher.
When the USE Z/OSMF WORKFLOW field value is YES, the CLIST uses the settings specified on this panel to customize jobs for activating the specified Db2 function level and for setting the specified APPLCOMPAT and SQLLEVEL settings after completion of migration to Db2 12 function level. For z/OSMF migrations, all fields on this panel are selected as z/OSMF variables and the settings are stored in DSNTIVMN, the variable input file for the DSNTIWMN workflow. You can use the DSNTIWMN workflow to complete the migration of a subsystem or data sharing group to function level 500 or higher. In Db2 data sharing, do not run DSNTIWMN before all members of the group are migrated to Db2 12 at function level V12R1M100.

How you use CURRENT FUNCTION LEVEL and TARGET FUNCTION LEVEL fields of this panel depend on your activity. In some situations the fields are protected and cannot be changed. The following table describes how the values are used in particular situations.

Table 1. DSNTIP00 default and valid values and JCL template actions
Activity	CURRENT FUNCTION LEVEL field	TARGET FUNCTION LEVEL field (FUNCLVL)	JCL templates updated (result value)
Installing a new Db2 subsystem or originating data sharing member by using z/OSMF or not.	The field is blank and protected.	The default is V12R1M500. You can modify the value to specify a higher function level.	DSNTIJTC (FUNCLVL) DSNTIJAF (FUNCLVL)
Installing subsequent data sharing members, including by using z/OSMF	The field is blank and protected.	The default is FUNCLVL from the DSNTID`xx` output member from the first group member.	None.
Enabling data sharing	The field is blank and protected.	The default is FUNCLVL from the DSNTID`xx` member from the first group member.	None.
Migrating a Db2 subsystem or the first data sharing member to Db2 12	The field is blank and protected.	The default value is V12R1M100 and it is protected.	DSNTIJTC (catalog level V12R1M500)
Migrating subsequent group members to Db2 12	The field is blank and protected.	The default value is V12R1M100 and it is protected.	None.
Activating function levels	The default is FUNCLVL from DSNTID`xx`	The default is blank. You can specify V12R1M500 or higher.	DSNTIJA1 (V12R1M501)¹ DSNTIJTC (FUNCLVL) DSNTIJAF (FUNCLVL)
Using z/OSMF to migrate a Db2 subsystem or the first data sharing member to Db2 12	The field is blank and protected.	The default is V12R1M500. You can modify the value to specify higher function levels.	DSNTIJA1 (V12R1M501)² DSNTIJTC (FUNCLVL) DSNTIJAF (FUNCLVL)
Using z/OSMF to migrate subsequent group members to Db2 12	The field is blank and protected.	The default is FUNCLVL from the DSNTID`xx` output member from the first group member, and the field is protected.	None.
Using z/OSMF to activate a function level	The default is FUNCLVL from the input DSNTID`xx` member. You can specify V12R1M100 or higher.	The field is blank. You can specify V12R1M100 or higher.	DSNTIJTC (FUNCLVL) DSNTIJAF (FUNCLVL)
Updating subsystem parameters	The field is blank and protected.	The default is FUNCLVL from DSNTID`xx`, and the field is protected.	None.

Notes:

DSNTIJA1 is generated only if CURRENT FUNCTION LEVEL is V12R1M100 and TARGET FUNCTION LEVEL is V12R1M502 or higher.
DSNTIJA1 is generated only if TARGET FUNCTION LEVEL is V12R1M502 or higher.