-DISPLAY GROUP command (Db2)
The -DISPLAY GROUP command displays information about the data sharing group to which a Db2 subsystem belongs, including information about the code level, catalog level, and function level of the group.
DISPLAY GROUP DETAIL displays information about the Db2 subsystem and data sharing group members.
Abbreviation: -DIS GROUP
Environment for -DISPLAY GROUP
This command can be issued from a z/OS® console, a DSN session under TSO, a DB2I panel (DB2 COMMANDS), an IMS or CICS® terminal, or a program using the instrumentation facility interface (IFI).
Data sharing scope: Member, Group (for ENCRYPTION_KEYLABEL)
Authorization for -DISPLAY GROUP
- DISPLAY privilege
- System DBADM authority
- SYSOPR authority
- SYSCTRL authority
- SYSADM authority
Db2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by Db2 authorization using primary and secondary authorization IDs. A logged-on z/OS user ID must be defined in RACF or a similar security server.
Syntax for -DISPLAY GROUP
Option descriptions for -DISPLAY GROUP
- DETAIL
- Displays information about the current inline length of the LOB that contains bound package information.
Usage notes for -DISPLAY GROUP
- Using this command in a non-data-sharing environment
- Db2 issues the same response, except for information which does not exist: group name, member name, and member ID.
- Member status in DSN7100I
- Message DSN7100I includes information about the XCF status of the members (STATUS in the display output). The status can be ACTIVE, QUIESCED, FAILED, or DEACT.
- ACTIVE
- Indicates that the Db2 subsystem is active.
- FAILED
- Indicates that the Db2 subsystem is failed.
- DEACT
- Indicates that the Db2 subsystem is deactivated. Deactivation is the first step in the process of deleting a data sharing member.
- QUIESCED
- Indicates a normal quiesced state, as the result of a normal STOP DB2 command.
- Q
- Q (quiesced) can be paired with one or more of the following letters:
- I
- Indoubt or postponed abort units of recovery (URs) are outstanding. This means that retained locks are held.
- C
- The member was shut down without completing castout processing. This event might have occurred because Db2 was started with the LIGHT(YES) option or stopped with the CASTOUT(NO) option, or because an error was encountered while attempting to cast out data from the coupling facility to the disk.
If Db2 encounters errors during castout processing, ensure that no connectivity problems exist between the coupling facility and the processor before restarting Db2.
- R
- Retained information is needed for Db2 to perform resynchronization with one or more remote locations.
When Db2 is restarted, this resynchronization occurs.
- ACTIVE
- Indicates a normal active state without conditions.
- A
- The member is active, but with the additional conditions. A (active) can be paired with the following letter:
- I
- Indoubt or postponed abort units of recovery (URs) are outstanding. This indicates that retained locks are held.
********
The state of the member is unknown.
- Trace information for data sharing members
- When this command with group scope is issued in a Db2 data sharing member, it also runs on all other active members. IFICID 090 trace records for other group members can show that the same command was issued by the SYSOPR authorization ID from the 016.TLPKN5F correlation ID, in addition to the trace records from the member where the original command was issued. See Command scope in Db2 data sharing.
Output descriptions for -DISPLAY GROUP
Message DSN7100I indicates the beginning of the output of the DISPLAY GROUP command. Depending on the options specified, the -DISPLAY GROUP command output might contain the following sections.
Output heading for -DISPLAY GROUP
The name of the control section is followed by heading information for the output, including information about the catalog level and function level of the Db2 subsystem or data sharing group:
*** BEGIN DISPLAY OF GROUP(text) CATALOG LEVEL(num)
CURRENT FUNCTION LEVEL(text)
HIGHEST ACTIVATED FUNCTION LEVEL (text)
HIGHEST POSSIBLE FUNCTION LEVEL (text)
PROTOCOL LEVEL(n)
GROUP ATTACH NAME(text)
------------------------------------------------------------------
- GROUP (text)
- The name of the data-sharing group or a series of dots if the Db2 subsystem is not a data sharing member.
- CATALOG LEVEL (text)
- The catalog level of the data sharing group or subsystem. The format is
VvvRrMmmm
, where vv is the version, r is the release, and mmm is the modification level. - CURRENT FUNCTION LEVEL (text)
- The current function level of the data sharing group or subsystem.The format is
VvvRrMmmm
, where vv is the version, r is the release, and mmm is the modification level. For example,V13R1M506
identifies function level 506. For a list of all available function levels in Db2 13, see Db2 13 function levels. - HIGHEST ACTIVATED FUNCTION LEVEL (text)
- The highest function level that was ever activated for the data sharing group or subsystem. 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 specified in an ACTIVATE command based on the catalog level of the group and the code levels of the group members. The format is
VvvRrMmmm
, where vv is the version, r is the release, and mmm is the modification level.For the code levels of each member, see the DB2 LVL column value in data sharing member information section.
- PROTOCOL LEVEL (num)
- A single numeric character that indicates the current locking protocol that is used in the data-sharing group.
- GROUP ATTACH NAME (text)
- The group attach name for the data-sharing group or a series of dots if the Db2 subsystem is not a data sharing member.
Data sharing member and subsystem information
The output heading is followed by a section that contains information about the data-sharing members:
Db2 Db2 SYSTEM IRLM
MEMBER ID SUBSYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC
-------- --- ---- -------- -------- ----- -------- ---- --------
text num text text text num text text text
- DB2 MEMBER text
- The name of the Db2 data-sharing member or a series of dots if the Db2 subsystem is not a data sharing member.
- ID num
- The internally assigned ID for each data-sharing member.
- SUBSYS text
- The subsystem name of the data-sharing member.
- CMDPREF text
- The command prefix of the data-sharing member.
- STATUS text
- The state of the data-sharing member. Expected values are:
- ACTIVE
- The Db2 subsystem is active.
- AI
- The member is active with more conditions. Indoubt or postponed abort units of recovery are unresolved, so retained locks are held.
- DEACT
- The Db2 subsystem is deactivated. Deactivation is the first step in the process of deleting a data sharing member.
- FAILED
- The member terminated abnormally.
- QUIESCED
- The member is down normally.
- QI
- The member is down with indoubt units of recovery.
- QR
- The member is down with resynchronization responsibility.
- QC
-
The member was shut down without completing castout processing. This event might have occurred because Db2 was started with the LIGHT(YES) option or stopped with the CASTOUT(NO) option, or because an error was encountered while attempting to cast out data from the coupling facility to the disk.
If Db2 encounters errors during castout processing, ensure that no connectivity problems exist between the coupling facility and the processor before restarting Db2.
- QCR, QIC, QIR, or QICR
- Possible combinations of the quiesced states (QI, QR, and QC):
- QCR is the equivalent of QC and QR.
- QIC is the equivalent of QI and QC.
- QIR is the equivalent of QI and QR.
- QICR is the equivalent of QC, QI, and QR.
********
The state of the member is unknown.
- DB2 LVL num
- A 6-character string that identifies the code level of the Db2 subsystem or member. The format is vvrmmm, where vv is the version, r is the release, and mm is the modification level. Each member of the group can have a different code level but it is always at or higher than the function level of the data sharing group.
- SYSTEM NAME text
- The name of the z/OS system on which the data-sharing member runs.
- IRLM SUBSYS text
- The accompanied IRLM's subsystem name for this Db2 member.
- IRLMPROC text
- The accompanied IRLM's startup procedure name.
Migration readiness report
If the DISPLAY GROUP Command is issued with the DETAIL option, migration readiness information is provided:
MIGRATION READINESS REPORT
--------------------------
DB2 CODE SPE MIGRATION
MEMBER LEVEL APAR ELIGIBLE
-------- --------- ------- ---
text text text text
MIGRATION READINESS STATUS: text
REASON: text
---------------------------------------------------------------------
- DB2 MEMBER text
- The name of the Db2 data sharing member or a series of dots if the Db2 subsystem is not a data sharing member..
- CODE LEVEL text
- The current code level of the data sharing member or subsystem. The format is
VvvRrMmmm
, where vv is the version, r is the release, and mmm is the modification level. - SPE APARtext
- The fallback SPE APAR value for this data sharing member or subsystem. If the value is not initialized to a fallback SPE APAR number, a series of dots is displayed.
- MIGRATION ELIGIBLE text
Indicates whether the data sharing group member or subsystem has on the fallback SPE for the next Db2 release. The value is YES, NO, or N/A.
N/A indicates a Db2 13 member that is already migrated in coexistence with Db2 12.
- MIGRATION READINESS STATUS: type-textreadiness-text
- GROUP for data sharing or SUBSYSTEM for a standalone Db2 subsystem
- REASON: reason-text
- Indicates one of the following reasons that the subsystem or data sharing group is not yet ready to migrate to the next release of Db2:
- NO NEXT RELEASE OF DB2 IS CURRENTLY AVAILABLE
- COEXISTENCE PRECLUDES MIGRATION TO NEXT DB2 RELEASE
ALL REMAINING MEMBERS ARE READY FOR DB2 nn
- HIGHEST ACTIVATED FUNCTION LEVEL NOT VnnR1Mnnn, where VnnR1Mnnn is the expected highest available function level.
- REQUIRED FALLBACK SPE APAR MISSING: PHnnnnn, where PHnnnnn is the expected fallback SPE APAR number.
Subgroup attachment information
If the DISPLAY GROUP command is issued with the DETAIL option in a Db2 data sharing group member, subgroup attachment information is provided:
DISPLAY SUBGROUP ATTACH INFORMATION FOR GROUP ATTACH text
------------------------------------------------------------------
MEMBERS OF SUBGROUP ATTACH text
text text text text text text text text
- GROUP ATTACH text
- The name of the group attachment group for the data-sharing member that is printing the output.
- MEMBERS OF SUBGROUP ATTACH text
- The name of the subgroup attachment group, followed by one or more lines that list the members of the subgroup. Each line contains up to eight members.
If more than 105 subgroup attachment groups are found, the following message is displayed:
MAXIMUM NUMBER OF SUBGROUP ATTACH GROUPS DISPLAYED
In this case, no additional groups are reported.
Shared communications area (SCA) information
The output provides the following information about the shared communications area (SCA):
SCA STRUCTURE SIZE: num KB, STATUS = tx, SCA IN USE: num %
- STRUCTURE SIZE num
- The size of the shared communications area (SCA), measured in kilobytes (KB).
- STATUS tx
- A 2-character indicator of the status of the shared communications area. Possible values are:
- AC
- The SCA is active.
- CC
- The SCA rebuild connect function completed.
- CS
- The SCA rebuild connect function started.
- DS
- The SCA loss of connectivity, delayed action started.
- DC
- The SCA loss of connectivity, delayed action completed.
- EC
- The SCA rebuild stop complete function completed.
- ES
- The SCA rebuild stop complete function started.
- IN
- The SCA is in initialization phase.
- LC
- The SCA rebuild cleanup function completed.
- LS
- The SCA rebuild cleanup function started.
- OC
- The SCA rebuild connect complete function completed.
- OS
- The SCA rebuild connect complete function started.
- PC
- The SCA rebuild process complete function completed.
- PS
- The SCA rebuild process complete function started.
- QC
- The SCA rebuild quiesce function completed.
- QS
- The SCA rebuild quiesce function started.
- RC
- The SCA rebuild resource manager invocation completed.
- RS
- The SCA rebuild resource manager invocation started.
- SC
- The SCA rebuild stop function completed.
- SS
- The SCA rebuild stop function started.
- TE
- The SCA is in termination phase.
- UC
- The SCA rebuild resource manager invocation completed.
- US
- The SCA rebuild resource manager invocation started.
- VC
- The SCA volatility change function completed.
- VS
- The SCA volatility change function started.
- SCA IN USE num
- Either the percentage of the number of entries that are in use in the SCA or the percentage of the number of elements that are in use in the SCA, whichever is larger. If the SCA structure is very large or if only a small number of SCA entries are in use, the percentage that is in use might be less than 1%. In this case, the percentage is indicated as:
SCA IN USE: < num %
LOCK1 structure
The output provides the following information about the LOCK1 structure:
LOCK1 STRUCTURE SIZE: num KB
NUMBER LOCK ENTRIES: num
NUMBER LIST ENTRIES: num, LIST ENTRIES IN USE: < num
- STRUCTURE SIZE num
- The size of the LOCK1 coupling facility structure, measured in kilobytes (KB).
- LOCK ENTRIES num
- The maximum number of lock table entries in the LOCK1 coupling facility structure.
- LIST ENTRIES num
- The maximum number of modify lock list entries in the LOCK1 coupling facility structure.
- LIST ENTRIES IN USE num
- The number of modify lock list entries in the LOCK1 coupling facility structure that are currently in use. These entries are sometimes referred to as record data.
SPT01 table space information
The output contains information about the inline length of BLOB column SPTSEC_DATA in the SPT01 table space.
If the SPT01 table space is available, the following output is displayed:
SPT01 INLINE LENGTH: num
- SPT01 INLINE LENGTH num
- The current inline length of the SPTSEC_DATA column.
If the SPT01 table space is unavailable when DISPLAY GROUP is issued on a subsystem or data sharing member that is in conversion mode, the following output is displayed:
SPT01 INLINE LENGTH INFORMATION NOT AVAILABLE
REASON reason-code
TYPE resource-type
NAME reason-name
If the SPT01 table space is unavailable when DISPLAY GROUP is issued on a subsystem or data sharing member that is in enabling-new-function mode, the following messages are displayed:
TABLE SPACE NEW FUNCTION ENABLEMENT INFORMATION NOT AVAILABLE
REASON reason-code
TYPE resource-type
NAME reason-name
SPT01 INLINE LENGTH INFORMATION NOT AVAILABLE
REASON reason-code
TYPE resource-type
NAME reason-name
- REASON reason-code
- The Db2 reason code value that indicates the reason for the failure. For explanations of reason codes, see Db2 reason codes.
- TYPE resource-type
- The type of resource. For an explanation of the resource-type value, see Resource types.
- NAME resource-name
- The resource name. For an explanation of resource-type and resource-name values, see Resource types.
End of output for -DISPLAY GROUP
The output normally ends with the following message:
*** END DISPLAY OF GROUP(text)
- GROUP
- The name of the group that the preceding lines of the output refer to.
If the output exceeds the maximum length, the following message marks the end of the output instead:
DISPLAY TERMINATED DUE TO INSUFFICIENT MESSAGE SPACE.
Examples for -DISPLAY GROUP
-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 DETAIL
Because 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 DETAIL
The 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)
- Example: The Db2 subsystem is not a data sharing member
-
The following output illustrates the result for a -DISPLAY GROUP command without the
DETAIL
keyword for a for a Db2 subsystem that is not a Db2 data sharing member.-DISPLAY GROUP DSN7100I -DB1A DSN7GCMD *** BEGIN DISPLAY OF GROUP(........) CATALOG LEVEL(V13R1M500) CURRENT FUNCTION LEVEL(V13R1M500) HIGHEST ACTIVATED FUNCTION LEVEL(V13R1M500) HIGHEST POSSIBLE FUNCTION LEVEL(V13R1M501) PROTOCOL LEVEL(2) GROUP ATTACH NAME(....) --------------------------------------------------------------------- DB2 SUB DB2 SYSTEM IRLM MEMBER ID SYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC -------- --- ---- -------- -------- ------ -------- ---- -------- ........ 0 DB1A -DB1A ACTIVE 131500 MVSA DJ1A DB1AIRLM --------------------------------------------------------------------- SPT01 INLINE LENGTH: 32138 *** END DISPLAY OF GROUP(........) DSN9022I -DB1A DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION