-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

To execute this command, you must use a privilege set of the process that includes one of the following privileges or authorities:

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. Start of change A logged-on z/OS user ID must be defined in RACF or a similar security server. End of change

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. End of change

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
Data sharing member and subsystem information
Migration readiness report
Subgroup attachment information
Shared communications area (SCA) information
LOCK1 structure
SPT01 table space information
End of output for -DISPLAY GROUP

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. End of change

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.

Start of change N/A indicates a Db2 13 member that is already migrated in coexistence with Db2 12. End of change

MIGRATION READINESS STATUS: type-textreadiness-text

GROUP for data sharing or SUBSYSTEM for a standalone Db2 subsystem

type-text

GROUP or SUBYSTEM.

readiness-text

One of the following status indicators:

IS NOT READY FOR DB2 nn
IS NOT READY FOR DB2 NEXT
IS READY FOR DB2 nn
GROUP MIGRATION IN PROGRESS TO DB2 nn

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

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. Start of change The DB2 LVL value for DB2B is 121510, which indicates that all Db2 12 function levels are activated. End of change

-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