Determining the Db2 code level, catalog level, and function level

Before you can activate a Db2 function level, you must ensure that the Db2 subsystem or data sharing group is at the appropriate code level and catalog level.

Procedure

Begin general-use programming interface information.To determine the code level, catalog level, and function level of a Db2 subsystem or data sharing group:

  1. Issue a DISPLAY GROUP command.
  2. Examine the DISPLAY GROUP output in message DSN7100I.
    The DB2 LVL value indicates the code levels of each Db2 subsystem or data sharing member.
    Important: Do not attempt to start Db2 at any code level that is lower than the highest ever activated function level, even at the lower star (*) function level. Activate a function level only after you are satisfied that Db2 can continue to run at the required code level.

Examples

The following examples show output from DISPLAY GROUP commands:
-DB2A DISPLAY GROUP DETAIL
Example: Data sharing group with coexisting Db2 12 and Db2 11 members

In the following example, two members are migrated to Db2 12 and ready for the activation of new function in Db2 12. However, the code level of member DB2B indicates that it is not migrated to Db2 12, which means the group is not ready for activation of function level 500. The DB2 LVL value is 111500, which indicates the code level of Db2 11 in new-function mode.

-DISPLAY GROUP DETAIL                                                             
DSN7100I  -DB2A DSN7GCMD                                                          
*** BEGIN DISPLAY OF GROUP(DSNCAT  ) CATALOG LEVEL(V12R1M500)                     
                  CURRENT FUNCTION LEVEL(V12R1M100)                               
                  HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M100)                     
                  HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M100)                      
                  PROTOCOL LEVEL(2)                                               
                  GROUP ATTACH NAME(DSNG)                                         
--------------------------------------------------------------------              
DB2          SUB                     DB2    SYSTEM    IRLM                        
MEMBER   ID  SYS  CMDPREF   STATUS   LVL    NAME      SUBSYS IRLMPROC             
-------- --- ---- --------  -------- ------ --------  ----   --------             
DB2A       1 DB2A -DB2A     ACTIVE   121500 MVSA      DJ2A   DB2AIRLM             
DB2B       2 DB2B -DB2B     ACTIVE   111500 MVSB      DJ2B   DB2BIRLM             
DB2C       3 DB2C -DB2C     ACTIVE   121500 MVSC      DJ2C   DB2CIRLM             
--------------------------------------------------------------------                            
DISPLAY SUBGROUP ATTACH INFORMATION FOR GROUP ATTACH DSNG                         
--------------------------------------------------------------------              
--------------------------------------------------------------------              
SCA   STRUCTURE SIZE:    12288 KB, STATUS= AC,   SCA IN USE:     8 %              
LOCK1 STRUCTURE SIZE:    12288 KB                                                 
NUMBER  LOCK ENTRIES:     1048576                                                 
NUMBER  LIST ENTRIES:       23073, LIST ENTRIES  IN USE:           7              
SPT01 INLINE LENGTH:        32138                                                 
*** END DISPLAY OF GROUP(DSNCAT  )                                                
DSN9022I  -DB2C DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION
Example: Data sharing group with all active members migrated to Db2 12 code, before the activation of function level 500

The following DISPLAY GROUP output illustrates a data sharing group with all active members migrated to Db2 12 and ready for the activation of function level 500.

DSN7100I  -DB2B DSN7GCMD                                                                               
*** BEGIN DISPLAY OF GROUP(DSNCAT  ) CATALOG LEVEL(V12R1M500)                                          
                  CURRENT FUNCTION LEVEL(V12R1M100)                                                    
                  HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M100)                                          
                  HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M500)                                           
                  PROTOCOL LEVEL(2)                                                                    
                  GROUP ATTACH NAME(DSNG)                                                              
--------------------------------------------------------------------                                   
DB2          SUB                     DB2    SYSTEM    IRLM                                             
MEMBER   ID  SYS  CMDPREF   STATUS   LVL    NAME      SUBSYS IRLMPROC                                  
-------- --- ---- --------  -------- ------ --------  ----   --------                                  
DB2A       1 DB2A -DB2A     ACTIVE   121500 MVSA      DJ2A   DB2AIRLM                                  
DB2B       2 DB2B -DB2B     ACTIVE   121500 MVSB      DJ2B   DB2BIRLM                                  
DB2C       3 DB2C -DB2C     ACTIVE   121500 MVSC      DJ2C   DB2CIRLM                                  
--------------------------------------------------------------------                                                                     
DISPLAY SUBGROUP ATTACH INFORMATION FOR GROUP ATTACH DSNG                                              
--------------------------------------------------------------------                                   
--------------------------------------------------------------------                                   
SCA   STRUCTURE SIZE:    12288 KB, STATUS= AC,   SCA IN USE:     9 %                                   
LOCK1 STRUCTURE SIZE:    12288 KB                                                                      
NUMBER  LOCK ENTRIES:     1048576                                                                      
NUMBER  LIST ENTRIES:       23073, LIST ENTRIES  IN USE:          17                                   
SPT01 INLINE LENGTH:        32138                                                                      
*** END DISPLAY OF GROUP(DSNCAT  )                                                                     
DSN9022I  -DB2B DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION
Example: Data sharing group with all active members migrated to Db2 12 after the activation of function level 500

The following DISPLAY GROUP output illustrates a data sharing group with function level 500 activated.

DSN7100I  -DB2A DSN7GCMD                                                     
*** BEGIN DISPLAY OF GROUP(DSNCAT  ) CATALOG LEVEL(V12R1M500)                
                  CURRENT FUNCTION LEVEL(V12R1M500)                          
                  HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M500)                
                  HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M500)                 
                  PROTOCOL LEVEL(2)                                          
                  GROUP ATTACH NAME(DSNG)                                    
--------------------------------------------------------------------         
DB2          SUB                     DB2    SYSTEM    IRLM                   
MEMBER   ID  SYS  CMDPREF   STATUS   LVL    NAME      SUBSYS IRLMPROC        
-------- --- ---- --------  -------- ------ --------  ----   --------        
DB2A       1 DB2A -DB2A     ACTIVE   121500 MVSA      DJ2A   DB2AIRLM        
DB2B       2 DB2B -DB2B     ACTIVE   121500 MVSB      DJ2B   DB2BIRLM        
DB2C       3 DB2C -DB2C     ACTIVE   121500 MVSC      DJ2C   DB2CIRLM        
--------------------------------------------------------------------                 
DISPLAY SUBGROUP ATTACH INFORMATION FOR GROUP ATTACH DSNG                    
--------------------------------------------------------------------         
--------------------------------------------------------------------         
SCA   STRUCTURE SIZE:    12288 KB, STATUS= AC,   SCA IN USE:     9 %         
LOCK1 STRUCTURE SIZE:    12288 KB                                            
NUMBER  LOCK ENTRIES:     1048576                                            
NUMBER  LIST ENTRIES:       23073, LIST ENTRIES  IN USE:           0         
SPT01 INLINE LENGTH:        32138                                            
*** END DISPLAY OF GROUP(DSNCAT  )                                           
DSN9022I  -DB2A DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION
FL 502 Example: Data sharing group with an encryption key label assigned to all members
If the subsystem parameter ENCRYPTION_KEYLABEL is specified for the members of a data sharing group, issue the following command to display the key label:
-DISPLAY GROUP DETAIL

The output is similar to the following:

DSN7100I -DB2C DSN7GCMD                                                  
*** BEGIN DISPLAY OF GROUP(DSNCAT  ) CATALOG LEVEL(V12R1M502)       
                  CURRENT FUNCTION LEVEL(V12R1M502)
                  HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M502)
                  HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M502)
                  PROTOCOL LEVEL(2)
                  GROUP ATTACH NAME(DSNG)
                  ENCRYPTION KEY LABEL (SYSTEM.KEY01)

What to do next

  1. If necessary, apply maintenance to the Db2 subsystem or data sharing group members for the code level required by the target function level, and repeat this task.
  2. Activate the target function level as described in Activating Db2 12 function levels.