Start of change

DSNU757I src csect-name activate-command-result

Explanation

This message displays output of the ACTIVATE command.

src
The command prefix for the ACTIVATE command.
csect-name
The name of the control section that issued the message.
Start of changeactivate-command-resultEnd of change
Start of changeThe ACTIVATE command output, formatted on multiple subsequent lines, as described in the following sections: End of change

Output heading

The name of the control section is followed by heading information for the output:

*** BEGIN ACTIVATE FUNCTION LEVEL (function-level)
function-level
The function level identifier that was specified in the ACTIVATE command. The format is VvvRrMmmm, where vv is the version, r is the release, and mmm is the modification level. For example, V12R1M510 identifies function level 510. For a list of all available function levels in Db2 12, see Db2 12 function levels.

Function level activation

The heading information is followed by output that indicates the result of the ACTIVATE command.
result-text
information-text
CATALOG LEVEL(text)
CURRENT FUNCTION LEVEL(text)
HIGHEST ACTIVATED FUNCTION LEVEL  (text)
HIGHEST POSSIBLE FUNCTION LEVEL(text)
result-text
Indicates whether the activate command was successful.
information-text
Displays information relevant to the ACTIVATE command. information-text can be displayed on multiple lines. If the function level was not activated successfully, these lines indicate the reason.
Start of changeCATALOG LEVEL(text)End of change
Start of changeThe current catalog level. The format is VvvRrMmmm, where vv is the version, r is the release, and mmm is the modification level.End of change
CURRENT FUNCTION LEVEL(text)
The highest function level that was ever activated.
HIGHEST ACTIVATED FUNCTION LEVEL(text)
The highest function level that was ever previously activated. The format is VvvRrMmmm, where vv is the version, r is the release, and mmm is the modification level.
HIGHEST POSSIBLE FUNCTION LEVEL(text)
The highest function level that can be activated. The format is VvvRrMmmm, where vv is the version, r is the release, and mmm is the modification level.
Tip: If older packages run in Db2 12 after you activate function level 510, the HIGHEST POSSIBLE FUNCTION LEVEL value can indicate V12R1M509, even though the HIGHEST ACTIVATED FUNCTION LEVEL value is V12R1M510. In this case, you can still migrate to Db2 13 without any further action. However, possibly disruptive automatic rebinds might occur in Db2 13 unless you rebind these packages first. To determine which packages to rebind, run the queries in the DSNTIJPM or DSNTIJPE migration jobs.

Data-sharing members

Start of changeThe DSNU757I message includes subsystem or data sharing member details when the ACTIVATE command specifies the TEST keyword and when activation fails.End of change

--------------------------------------------------------------------
DB2            CURRENT     CAPABLE FUNCTION LEVELS
MEMBER     ID  CODE-LEVEL  LOWEST     HIGHEST    STATUS
--------  ---  ----------  ---------- ---------- -------------------
text      num  text        text        text      text
DB2 MEMBER text
The name of the data-sharing member.
ID num
The internally assigned identifier for each data-sharing member.
CODE-LEVEL text
The code level of the subsystem or member. The format is VvvRrMmmm, where vv is the version, r is the release, and mmm is the modification level.
CAPABLE FUNCTION LEVELS
The lowest and highest function levels that can coexist with the subsystem.
LOWEST text
Indicates the lowest function level that can coexist with the subsystem or member. The format is VvvRrMmmm, where vv is the version, r is the release, and mmm is the modification level.
HIGHEST text
Indicates the lowest function level that can coexist with the subsystem or member. The format is VvvRrMmmm, where vv is the version, r is the release, and mmm is the modification level.
STATUS text
The current status of the subsystem or member.

End of output

--------------------------------------------------------------------

System action

Processing continues.

User response

No action is required.

Examples

The following examples show output from ACTIVATE commands.

Example: Testing function level activation
Begin general-use programming interface information.The following command checks whether the subsystem or data sharing group is ready for the specified function level.
-ACTIVATE FUNCTION LEVEL (V12R1M500) TEST
The DSNU757I message indicates whether the group is ready for the specified level. Because TEST is specified, the output includes detailed information about each active member of the data sharing group. In this example, all of the members are at the required code level and catalog level so that function level 500 can be activated. 
DSNU757I  -DB2A DSNUGCCA                                                                 
*** BEGIN ACTIVATE FUNCTION LEVEL (V12R1M500)                                            
                GROUP ELIGIBLE FOR FUNCTION LEVEL (V12R1M500)                            
                CATALOG LEVEL(V12R1M500)                                                 
                CURRENT FUNCTION LEVEL(V12R1M100)                                        
                HIGHEST ACTIVATED FUNCTION LEVEL (V12R1M100)                              
                HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M500)                               
--------------------------------------------------------------------
DB2          CURRENT     CAPABLE FUNCTION LEVELS                    
MEMBER   ID  CODE-LEVEL  LOWEST      HIGHEST     STATUS             
-------- --- ----------  ----------  ----------  -------------------
DB2A       1 V12R1M500   V12R1M100   V12R1M500   ELIGIBLE           
DB2B       2 V12R1M500   V12R1M100   V12R1M500   ELIGIBLE           
DB2C       3 V12R1M500   V12R1M100   V12R1M500   ELIGIBLE           
--------------------------------------------------------------------
DSN9022I  -DB2A DSNZACMD '-ACTIVATE FUNC' NORMAL COMPLETION
End general-use programming interface information.
Example: Activating function level 500
Begin general-use programming interface information.The following command attempts to activate function level 500.
-ACTIVATE FUNCTION LEVEL (V12R1M500)
The DSNU757I message indicates that function level 500 is successfully activated for the data sharing group.
DSNU757I  -DB2A DSNUGCCA                                                   
*** BEGIN ACTIVATE FUNCTION LEVEL (V12R1M500)                              
                FUNCTION LEVEL (V12R1M500) SUCCESSFULLY ACTIVATED          
                CATALOG LEVEL(V12R1M500)                                   
                CURRENT FUNCTION LEVEL(V12R1M500)                          
                HIGHEST ACTIVATED FUNCTION LEVEL (V12R1M100)                
                HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M500)               
DSN9022I  -DB2A DSNZACMD '-ACTIVATE FUNC' NORMAL COMPLETION
End general-use programming interface information.
Example: Activating function level 502
The following command attempts to activate function level 502.The DSNU757I message indicates that function level 502 is successfully activated for the data sharing group.
DSNU757I  -DB2A DSNUGCCA                                                   
*** BEGIN ACTIVATE FUNCTION LEVEL (V12R1M502)                              
                FUNCTION LEVEL (V12R1M502) SUCCESSFULLY ACTIVATED          
                CATALOG LEVEL(V12R1M502)                                   
                CURRENT FUNCTION LEVEL(V12R1M500)                          
                HIGHEST ACTIVATED FUNCTION LEVEL (V12R1M500)                
                HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M502)               
DSN9022I  -DB2A DSNZACMD '-ACTIVATE FUNC' NORMAL COMPLETION
Example: Attempting to activate a function level with ineligible members
Begin general-use programming interface information.For example the following command attempts to activate the specified function level.
-ACTIVATE FUNCTION LEVEL (V12R1M500)
The DSNU757I message indicates that the group is not yet ready for the activation of function level 500. The example subsystem is being migrated from Db2 11. One or more members is not at the required code level. Start of change
DSNU757I  -DB2A DSNUGCCA                                                       
*** BEGIN ACTIVATE FUNCTION LEVEL (V12R1M500)                                  
                GROUP NOT ELIGIBLE FOR FUNCTION LEVEL (V12R1M500)              
                MEMBER(S) NOT STARTED WITH REQUIRED CODE LEVEL                 
                CATALOG LEVEL(V12R1M500)                                       
                CURRENT FUNCTION LEVEL(V12R1M100)                              
                HIGHEST ACTIVATED FUNCTION LEVEL (V12R1M100)                    
                HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M100)
--------------------------------------------------------------------
DB2          CURRENT     CAPABLE FUNCTION LEVELS                    
MEMBER   ID  CODE-LEVEL  LOWEST      HIGHEST     STATUS             
-------- --- ----------  ----------  ----------  -------------------
DB2A       1 V12R1M500   V12R1M100   V12R1M500   ELIGIBLE           
DB2B       2 V11R1M500   V11R1M500   V12R1M100   NOT ELIGIBLE           
DB2C       3 V12R1M500   V12R11M100   V12R1M500   ELIGIBLE           
--------------------------------------------------------------------                      
DSN9022I  -DB2A DSNZACMD '-ACTIVATE FUNC' NORMAL COMPLETION
End of changeEnd general-use programming interface information.
Example: Activating a lower (*) function level
Begin general-use programming interface information.Assuming that the subsystem or data sharing group is at function level 500, the following command reverts the subsystem or group to function level 100*
-ACTIVATE FUNCTION LEVEL (V12R1M100)
The DSNU757I message indicates that function level 100* is activated.
DSNU757I  -DB2A DSNUGCCA                                                   
*** BEGIN ACTIVATE FUNCTION LEVEL (V12R1M100)                              
                FUNCTION LEVEL (V12R1M100) SUCCESSFULLY ACTIVATED          
                CATALOG LEVEL(V12R1M500)                                   
                CURRENT FUNCTION LEVEL(V12R1M100*)                         
                HIGHEST ACTIVATED FUNCTION LEVEL (V12R1M500)                
                HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M500)                 
DSN9022I  -DB2A DSNZACMD '-ACTIVATE FUNC' NORMAL COMPLETION
End general-use programming interface information.
End of change