Determining the release of a data sharing group in coexistence
When the first data sharing member starts in Db2 13, the catalog level is V13R1M100 and the function level is V13R1M100, even though not all members of the group have migrated.
Procedure
To determine the catalog level of a group:
Issue the DISPLAY GROUP command.
The catalog level is shown near the top of the display.
Examples for -DISPLAY GROUP
The following examples show output from DISPLAY GROUP commands in Db2 13:
-DB2A DISPLAY GROUP DETAIL- Example: Data sharing group with coexisting Db2 13 and Db2 12 members
-
In the following example, two members are migrated to Db2 13 and ready for the activation of new function in Db2 13. However, the code level of member DB2B indicates that it is not migrated to Db2 13, which means the group is not ready for activation of function level 500. The DB2 LVL value for DB2B is 121510, which indicates that all Db2 12 function levels are activated.
-DISPLAY GROUP DETAIL DSN7100I -DB2A DSN7GCMD *** BEGIN DISPLAY OF GROUP(DSNCAT ) CATALOG LEVEL(V13R1M100) CURRENT FUNCTION LEVEL(V13R1M100) HIGHEST ACTIVATED FUNCTION LEVEL(V13R1M100) HIGHEST POSSIBLE FUNCTION LEVEL(V13R1M100) PROTOCOL LEVEL(2) GROUP ATTACH NAME(DSNG) -------------------------------------------------------------------- DB2 SUB DB2 SYSTEM IRLM MEMBER ID SYS CMDPREF ELIGIBLE LVL NAME SUBSYS IRLMPROC -------- --- ---- -------- -------- ------ -------- ---- -------- DB2A 1 DB2A -DB2A ACTIVE 131501 MVSA DJ2A DB2AIRLM DB2B 2 DB2B -DB2B ACTIVE 121510 MVSB DJ2B DB2BIRLM DB2C 3 DB2C -DB2C ACTIVE 131501 MVSC DJ2C DB2CIRLM -------------------------------------------------------------------- MIGRATION READINESS REPORT -------------------------- DB2 CODE SPE MIGRATION MEMBER LEVEL APAR ELIGIBLE -------- --------- ------- --- DB2A V13R1M501 ....... N/A DB2B V12R1M501 PH37108 YES DB2B V12R1M501 PH37108 YES --------------------------------------------------------------------- MIGRATION READINESS STATUS: GROUP MIGRATION IN PROGRESS TO DB2 13 REASON: ALL REMAINING MEMBERS ARE READY FOR DB2 13 -------------------------------------------------------------------- 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: Running a DISPLAY GROUP command run on a Db2 12 member during coexistence with Db2 13
-
The following example output shows the result of running the following command on a Db2 12 member in the data sharing group from the previous example:
-DB2B DISPLAY GROUP DETAILBecause the command was run on a Db2 12 member, the highest possible function level indicates V12R1M510, which is the highest level that you can activate by issuing an ACTIVATE command. However, the current function level indicates V13R1M100 because at least one member has been migrated to Db2 13.
-DISPLAY GROUP DETAIL DSN7100I -DB2B DSN7GCMD *** BEGIN DISPLAY OF GROUP(DSNCAT ) CATALOG LEVEL(V13R1M100) CURRENT FUNCTION LEVEL(V13R1M100) HIGHEST ACTIVATED FUNCTION LEVEL(V13R1M100) HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M510) 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 131501 MVSA DJ2A DB2AIRLM DB2B 2 DB2B -DB2B ACTIVE 121510 MVSB DJ2B DB2BIRLM DB2C 3 DB2C -DB2C ACTIVE 131501 MVSC DJ2C DB2CIRLM -------------------------------------------------------------------- MIGRATION READINESS REPORT -------------------------- DB2 CODE SPE MIGRATION MEMBER LEVEL APAR ELIGIBLE -------- --------- ------- --- DB2A V13R1M501 ....... N/A DB2B V12R1M510 PH37108 YES DB2B V13R1M501 ....... N/A --------------------------------------------------------------------- MIGRATION READINESS STATUS: GROUP MIGRATION IN PROGRESS TO DB2 13 REASON: ALL REMAINING MEMBERS ARE READY FOR DB2 13 -------------------------------------------------------------------- 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 -DB2B DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION - Example: Data sharing group with all active members migrated to Db2 13 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 13 and ready for the activation of function level 500.
DSN7100I -DB2B DSN7GCMD *** BEGIN DISPLAY OF GROUP(DSNCAT ) CATALOG LEVEL(V13R1M100) CURRENT FUNCTION LEVEL(V13R1M100) HIGHEST ACTIVATED FUNCTION LEVEL(V13R1M100) HIGHEST POSSIBLE FUNCTION LEVEL(V13R1M500) 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 131501 MVSA DJ2A DB2AIRLM DB2B 2 DB2B -DB2B ACTIVE 131501 MVSB DJ2B DB2BIRLM DB2C 3 DB2C -DB2C ACTIVE 131501 MVSC DJ2C DB2CIRLM -------------------------------------------------------------------- MIGRATION READINESS REPORT -------------------------- DB2 CODE SPE MIGRATION MEMBER LEVEL APAR ELIGIBLE -------- --------- ------- --- DB2A V13R1M501 ....... NO DB2B V13R1M501 ....... NO DB2C V13R1M501 ....... NO --------------------------------------------------------------------- MIGRATION READINESS STATUS: GROUP IS NOT READY FOR DB2 NEXT REASON: NO NEXT RELEASE OF DB2 IS CURRENTLY AVAILABLE -------------------------------------------------------------------- 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 13 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(V13R1M500) CURRENT FUNCTION LEVEL(V13R1M500) HIGHEST ACTIVATED FUNCTION LEVEL(V13R1M500) HIGHEST POSSIBLE FUNCTION LEVEL(V13R1M500) 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 131501 MVSA DJ2A DB2AIRLM DB2B 2 DB2B -DB2B ACTIVE 131501 MVSB DJ2B DB2BIRLM DB2C 3 DB2C -DB2C ACTIVE 131501 MVSC DJ2C DB2CIRLM -------------------------------------------------------------------- MIGRATION READINESS REPORT -------------------------- DB2 CODE SPE MIGRATION MEMBER LEVEL APAR ELIGIBLE -------- --------- ------- --- DB2A V13R1M501 ....... NO DB2B V13R1M501 ....... NO DB2B V13R1M501 ....... NO --------------------------------------------------------------------- MIGRATION READINESS STATUS: GROUP IS NOT READY FOR DB2 NEXT REASON: NO NEXT RELEASE OF DB2 IS CURRENTLY AVAILABLE -------------------------------------------------------------------- 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 - 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 DETAILThe output is similar to the following:
DSN7100I -DB2C DSN7GCMD *** BEGIN DISPLAY OF GROUP(DSNCAT ) CATALOG LEVEL(V13R1M500) CURRENT FUNCTION LEVEL(V13R1M500) HIGHEST ACTIVATED FUNCTION LEVEL(V13R1M500) HIGHEST POSSIBLE FUNCTION LEVEL(V13R1M500) PROTOCOL LEVEL(2) GROUP ATTACH NAME(DSNG) ENCRYPTION KEY LABEL (SYSTEM.KEY01)