-DISPLAY GROUP (DB2)
The DB2® command DISPLAY GROUP displays information about the data sharing group to which a DB2 subsystem belongs.
DISPLAY GROUP DETAIL displays the DB2 subsystem and group mode (conversion mode, enabling new function mode, or DB2 Version 8 new-function mode or later).
Abbreviation: -DIS GROUP
Environment
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: Group
Authorization
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.
Syntax
>>-DISPLAY GROUP--+--------+----------------------------------->< '-DETAIL-'
Option descriptions
- DETAIL
- Displays information about the parallelism coordinator, parallelism assistant, and the current inline length of the LOB that contains bound package information.
Usage notes
Member status: 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.
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.
Examples
- Example: Displaying information about a data sharing group when the group is in conversion mode
- Suppose that you issue the following command against a data sharing group, when all members
are in conversion mode, and are all members are on DB2 10:
-DB1A DISPLAY GROUPThe output is similar to the following output:
DSN7100I -DB1A DSN7GCMD *** BEGIN DISPLAY OF GROUP(DSNDB10 ) CATALOG LEVEL(101) MODE(C ) PROTOCOL LEVEL(2) GROUP ATTACH NAME(DB10) -------------------------------------------------------------------- DB2 DB2 SYSTEM IRLM MEMBER ID SUBSYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC -------- --- ---- -------- -------- --- -------- ---- -------- DB1A 1 DB1A -DB1A ACTIVE 101 MVSA DJ1A DB1AIRLM DB1B 2 DB1B -DB1B ACTIVE 101 MVSB DJ1B DB1BIRLM DB1C 3 DB1C -DB1C ACTIVE 101 MVSC DJ1C DB1CIRLM DB1D 4 DB1D -DB1D FAILED 101 MVSD DJ1D DB1DIRLM DB1E 5 DB1E -DB1E QUIESCED 101 MVSE DJ1E DB1EIRLM DB1F 6 DB1F -DB1F ACTIVE 101 MVSF DJ1F DB1FIRLM DB1G 7 DB1G -DB1G ACTIVE 101 MVSG DJ1G DB1GIRLM -------------------------------------------------------------------- SCA STRUCTURE SIZE: 1024 KB, STATUS= AC, SCA IN USE: 11 % LOCK1 STRUCTURE SIZE: 1536 KB NUMBER LOCK ENTRIES: 262144 NUMBER LIST ENTRIES: 7353, LIST ENTRIES IN USE: 0 *** END DISPLAY OF GROUP(DSNDB10 ) DSN9022I -DB1A DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION - Example: Displaying information about a data sharing group when the group is in coexistence mode
- Suppose that you issue the following command against a data sharing group, when not all members
are on DB2 10:
-DB1A DISPLAY GROUPThe output is similar to the following output:
DSN7100I -DB1A DSN7GCMD *** BEGIN DISPLAY OF GROUP(DSNDB10) CATALOG LEVEL(101) MODE(X ) PROTOCOL LEVEL(2) GROUP ATTACH NAME(DB10) -------------------------------------------------------------------- DB2 DB2 SYSTEM IRLM MEMBER ID SUBSYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC -------- --- ---- -------- -------- --- -------- ---- -------- DB1A 1 DB1A -DB1A ACTIVE 101 MVSA DJ1A DB1AIRLM DB1B 2 DB1B -DB1B ACTIVE 101 MVSB DJ1B DB1BIRLM DB1C 3 DB1C -DB1C ACTIVE 101 MVSC DJ1C DB1CIRLM DB1D 4 DB1D -DB1D FAILED 910 MVSD DJ1D DB1DIRLM DB1E 5 DB1E -DB1E QUIESCED 910 MVSE DJ1E DB1EIRLM DB1F 6 DB1F -DB1F ACTIVE 101 MVSF DJ1F DB1FIRLM DB1G 7 DB1G -DB1G ACTIVE 101 MVSG DJ1G DB1GIRLM -------------------------------------------------------------------- SCA STRUCTURE SIZE: 1024 KB, STATUS= AC, SCA IN USE: 11 % LOCK1 STRUCTURE SIZE: 1536 KB NUMBER LOCK ENTRIES: 262144 NUMBER LIST ENTRIES: 7353, LIST ENTRIES IN USE: 0 *** END DISPLAY OF GROUP(DSNDB10 ) DSN9022I -DB1A DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION - Example: DISPLAY GROUP in a non-data-sharing environment
- Suppose that you issue the following command against a single subsystem on which new function is
activated:
-DB1A DISPLAY GROUPThe output is similar to the following output:
DSN7100I -DB1A DSN7GCMD *** BEGIN DISPLAY OF GROUP(.......) CATALOG LEVEL(1010) MODE(N ) PROTOCOL LEVEL(...) GROUP ATTACH NAME(....) -------------------------------------------------------------------- DB2 DB2 SYSTEM IRLM MEMBER ID SUBSYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC -------- --- ---- -------- -------- --- -------- ---- -------- ........ 0 DB1A -DB1A ACTIVE 101 MVSA DJ1A DB1AIRLM -------------------------------------------------------------------- *** END DISPLAY OF GROUP(DSNDB10) DSN9022I -DB1A DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION
- Example: Displaying detailed information about a data sharing group
- You can obtain more information about the data sharing group by using the DISPLAY GROUP command
with the DETAIL option. Issue the following
command:
-DB1A DISPLAY GROUP DETAILThe output is similar to the following output:
DSN7100I @ DSN7GCMD 488 *** BEGIN DISPLAY OF GROUP(DSNCAT ) CATALOG LEVEL(101) MODE(NFM ) PROTOCOL LEVEL(2) GROUP ATTACH NAME(DSNG) -------------------------------------------------------------------- DB2 DB2 SYSTEM IRLM MEMBER ID SUBSYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC -------- --- ---- -------- -------- --- -------- ---- -------- VA1A 1 VA1A @ ACTIVE 101 DTEC745 PR21 PRLM21 -------------------------------------------------------------------- DB2 PARALLEL PARALLEL MEMBER COORDINATOR ASSISTANT -------- ----------- --------- VA1A NO NO -------------------------------------------------------------------- DISPLAY SUBGROUP ATTACH INFORMATION FOR GROUP ATTACH DSNG -------------------------------------------------------------------- MEMBERS OF SUBGROUP ATTACH SUBA VA1A VA1B MEMBERS OF SUBGROUP ATTACH SUBB VA1C -------------------------------------------------------------------- SCA STRUCTURE SIZE: 4096 KB, STATUS= AC, SCA IN USE: 5 % LOCK1 STRUCTURE SIZE: 4096 KB NUMBER LOCK ENTRIES: 524288 NUMBER LIST ENTRIES: 3833, LIST ENTRIES IN USE: 0 *** END DISPLAY OF GROUP(DSNCAT ) DSN9022I @ DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION
Output
Message DSN7100I indicates the beginning of the output of the command.