确定 Db2 代码级别、目录级别和功能级别
在启用 Db2 功能级别之前，必须确保 Db2 子系统或数据共享组处于适当的代码级别和目录级别。
过程
要确定 Db2 子系统或数据共享组的代码级别、目录级别和功能级别，请执行以下操作：
-DISPLAY GROUP的示例
以下示例显示了 Db2 12 中DISPLAY GROUP命令的输出：
-DB2A DISPLAY GROUP DETAIL- 示例：数据共享组，成员包括 Db2 12 和 Db2 11
在下面的示例中，两个成员被迁移到 Db2 12 ，并准备激活 Db2 12 中的新功能。 然而，成员 DB2B 的代码级别表明它尚未迁移到 Db2 12 ，这意味着该组尚未准备好激活功能级别 500。 LVL值是 DB2 LVL值是111500，表示新功能模式下 Db2 11 的代码级别。
此外，迁移准备报告显示，由于与 Db2 11 并存， Db2 数据共享组尚未准备好迁移到 Db2 13 。
-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 -------------------------------------------------------------------- MIGRATION READINESS REPORT -------------------------- DB2 CODE SPE MIGRATION MEMBER LEVEL APAR ELIGIBLE -------- --------- ------- --- DB2A V12R1M500 ....... NO DB2B V11R1M500 ....... NO DB2B V12R1M500 ....... NO --------------------------------------------------------------------- MIGRATION READINESS STATUS: IS NOT READY FOR DB2 13 REASON: COEXISTENCE PRECLUDES MIGRATION TO THE NEXT DB2 RELEASE -------------------------------------------------------------------- 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- 示例：在启用功能级别500之前，将所有活跃成员的数据共享组迁移到 Db2 12 代码中
以下显示组输出说明了一个数据共享组，所有活跃成员都迁移到了 Db2 12 ，并已准备好激活功能级别500。
此外，迁移准备报告显示，由于激活的功能级别最高，且并非所有成员都拥有备用 SPE APAR，因此 Db2 数据共享组尚未准备好迁移到 Db2 13 。
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 121510 MVSB DJ2B DB2BIRLM DB2C 3 DB2C -DB2C ACTIVE 121500 MVSC DJ2C DB2CIRLM -------------------------------------------------------------------- MIGRATION READINESS REPORT -------------------------- DB2 CODE SPE MIGRATION MEMBER LEVEL APAR ELIGIBLE -------- --------- ------- --- DB2A V12R1M510 ....... NO DB2B V12R1M510 PH37108 NO DB2C V12R1M510 ....... NO --------------------------------------------------------------------- MIGRATION READINESS STATUS: GROUP IS NOT READY FOR DB2 NEXT REASON: HIGHEST ACTIVATED FUNCTION LEVEL NOT V12R1M510 -------------------------------------------------------------------- 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- 示例：在启用功能级别500后，所有活跃成员的数据共享组迁移到 Db2 12
以下显示组输出显示了已激活功能级别为500的数据共享组。
此外，迁移准备报告显示，由于激活的功能级别最高且缺少SPE APAR， Db2 数据共享组尚未准备好迁移到 Db2 13 。
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 -------------------------------------------------------------------- MIGRATION READINESS REPORT -------------------------- DB2 CODE SPE MIGRATION MEMBER LEVEL APAR ELIGIBLE -------- --------- ------- --- DB2A V12R1M500 ....... NO DB2B V12R1M500 ....... NO DB2B V12R1M500 ....... NO --------------------------------------------------------------------- MIGRATION READINESS STATUS: GROUP IS NOT READY FOR DB2 13 REASON: HIGHEST ACTIVATED FUNCTION LEVEL NOT V12R1M510 -------------------------------------------------------------------- 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- 例如： Db2 12 数据共享组准备迁移到 Db2 13
- 单成员 Db2 12 数据共享组的示例已准备好迁移到 Db2 13。
DSN7100I -DB2A DSN7GCMD *** BEGIN DISPLAY OF GROUP(DSNCAT ) CATALOG LEVEL(V12R1M509) CURRENT FUNCTION LEVEL(V12R1M510) HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M510) 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 PRLM2171 DB2A 1 DB2A -DB2A ACTIVE 121510 UTEC5 PR21 PRLM21 -------------------------------------------------------------------- MIGRATION READINESS REPORT --------------------------- DB2 CODE SPE MIGRATION MEMBER LEVEL APAR ELIGIBLE -------- --------- ------- --- DB2A V12R1M510 PH37108 YES --------------------------------------------------------------------- MIGRATION READINESS STATUS: GROUP IS READY FOR MIGRATION TO DB2 13 -------------------------------------------------------------------- DISPLAY SUBGROUP ATTACH INFORMATION FOR GROUP ATTACH DSNG -------------------------------------------------------------------- --------------------------------------------------------------------- SCA STRUCTURE SIZE: 12288 KB, STATUS= AC, SCA IN USE: 5 % LOCK1 STRUCTURE SIZE: 12288 KB NUMBER LOCK ENTRIES: 1048576 NUMBER LIST ENTRIES: 23151, LIST ENTRIES IN USE: 0 SPT01 INLINE LENGTH: 32138 *** END DISPLAY OF GROUP(DSNCAT ) -DB2A DSN7GCMD 'DISPLAY GROUP ' NORMAL DSN9022I COMPLETION - 示例： Db2 12 数据共享组尚未准备好迁移到 Db2 13
- 示例 Db2 12 数据共享组尚未准备好迁移到 Db2 13 ，因为与 Db2 11 并存。
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 PRLM2171 DB2A 1 DB2A -DB2A ACTIVE 121510 UTEC5 PR21 PRLM21 DB2B 2 DB2B -DB2B ACTIVE 111500 UTEC5 QR21 QRLM21 --------------------------------------------------------------------- --------------------------------------------------------------------- DISPLAY SUBGROUP ATTACH INFORMATION FOR GROUP ATTACH DSNG --------------------------------------------------------------------- MIGRATION READINESS REPORT --------------------------- DB2 CODE SPE MIGRATION MEMBER LEVEL APAR ELIGIBLE -------- --------- ------- --- DB2A V12R1M510 PH37108 YES DB2B V11R1M500 ....... NO --------------------------------------------------------------------- MIGRATION READINESS STATUS: GROUP IS NOT READY FOR DB2 13 REASON: COEXISTENCE PRECLUDES MIGRATION TO THE NEXT DB2 RELEASE --------------------------------------------------------------------- SCA STRUCTURE SIZE: 12288 KB, STATUS= AC, SCA IN USE: 5 % LOCK1 STRUCTURE SIZE: 12288 KB NUMBER LOCK ENTRIES: 1048576 NUMBER LIST ENTRIES: 23151, LIST ENTRIES IN USE: 5 SPT01 INLINE LENGTH: 32138 *** END DISPLAY OF GROUP(DSNCAT ) DSN9022I -DB2A DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION - 示例：独立的 Db2 12 子系统尚未准备好迁移到 Db2 13
示例 Db2 子系统具有足够的代码级别，并且有用于迁移到 Db2 13 的后备SPE APAR。 然而，由于激活的功能级别最高，它尚未准备好迁移到 Db2 13 。
DSN7100I -DB2A DSN7GCMD *** BEGIN DISPLAY OF GROUP(........) CATALOG LEVEL(V12R1M500) CURRENT FUNCTION LEVEL(V12R1M100) HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M100) HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M501) PROTOCOL LEVEL(2) GROUP ATTACH NAME(....) --------------------------------------------------------------------- DB2 SUB DB2 SYSTEM IRLM MEMBER ID SYS CMDPREF STATUS LVL NAME SUBSYS PRLMPR21 -------- --- ---- -------- -------- ------ -------- ---- -------- ........ 0 DB2A -DB2A ACTIVE 121510 UTEC6 PR21 PRLMPR21 --------------------------------------------------------------------- --------------------------------------------------------------------- DISPLAY SUBGROUP ATTACH INFORMATION FOR GROUP ATTACH DSNG --------------------------------------------------------------------- MIGRATION READINESS REPORT -------------------------- DB2 CODE SPE MIGRATION MEMBER LEVEL APAR ELIGIBLE -------- --------- ------- --- ........ V12R1M510 PH37108 YES --------------------------------------------------------------------- MIGRATION READINESS STATUS: SUBSYSTEM IS NOT READY FOR DB2 13 REASON: HIGHEST ACTIVATED FUNCTION LEVEL NOT V12R1M510 --------------------------------------------------------------------- SPT01 INLINE LENGTH: 32138 *** END DISPLAY OF GROUP(........) DSN9022I -DB2A DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION- FL 502 示例：数据共享组，所有成员都分配有加密密钥标签
- 如果为数据共享组的成员指定了子系统参数ENCRYPTION_KEYLABEL，请发出以下命令以显示密钥标签：
-DISPLAY GROUP DETAIL输出类似以下内容：
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) - 示例： 子系统不是数据共享成员： Db2 子系统不是数据共享成员
下面的输出显示了针对 Db2 子系统（该子系统不是 Db2 数据共享成员）的 -DISPLAY GROUP 命令（不含
DETAIL关键字）的结果。-DISPLAY GROUP DSN7100I -DB1A DSN7GCMD *** BEGIN DISPLAY OF GROUP(........) CATALOG LEVEL(V12R1M500) CURRENT FUNCTION LEVEL(V12R1M500) HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M500) HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M501) PROTOCOL LEVEL(2) GROUP ATTACH NAME(....) --------------------------------------------------------------------- DB2 SUB DB2 SYSTEM IRLM MEMBER ID SYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC -------- --- ---- -------- -------- ------ -------- ---- -------- ........ 0 DB1A -DB1A ACTIVE 121510 MVSA DJ1A DB1AIRLM --------------------------------------------------------------------- SPT01 INLINE LENGTH: 32138 *** END DISPLAY OF GROUP(........) DSN9022I -DB1A DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION
后续操作
- 如有必要，请对 Db2 子系统或数据共享组成员进行维护，使其达到目标功能级别所需的代码级别，并重复此任务。
- 激活目标功能级别，如激活 Db2 12个功能级别中所述。
