DSNZPARM Data Sharing Parameters

This panel shows information about the data sharing installation parameters in the DSNZPARM module. It shows the name of the DSNZPARM module that is specified for Db2 startup and the date on which the module is assembled. It also shows a list of the default values of the Db2 application.

If a field is not available for the current DB2® release, the string N/A is displayed. For other conditions, for example, if specific Db2 traces are not started or control block data is not available, the string N/P is displayed.


________________ ZPSHR    VTM     O2       V550.#P SC11 S 07/08/16 10:44:53 2  
>       Help PF1      Back PF3      Left PF10      Right PF11                   
> R.H.J                                                                         
>       DSNZPARM INFORMATION:  Enter a selection letter on the top line.        
                                                                                
>  A-THREAD    B-TRACE     C-LOGGING   D-ARCHIVING     E-AUTH/RLF/DDF   F-IRLM  
>  G-STORAGE   H-DATASET   I-DDCS      *-DATA SHARING  K-STORED PROC    L-UTIL  
>  M-APPL      N-DATA      O-PERF      P-BUFFERPOOL    Q-OTHERS                 
=============================================================================== 
>                       DSNZPARM DATA SHARING PARAMETERS                        
 ZSHR                                                                           
+ Collection Interval:  REALTIME                SNAPTIME: 07/08/16 10:44:53.41  
+                                                                               
+ DSNZPARM Module                         DSNZPARM                              
+ Assembly Date                           04/14/16                              
+ Initial Module                          DSNZPARM                              
+ Assembly Date                           04/14/16                              
+ Previous Module                         DSNZPARM                              
+ Assembly Date                           04/14/16                              
+                                                                               
+ DSNTIPK-Data Sharing Parm                                                     
+------------------------------------                                           
+ Group Name (GRPNAME)                        DBC1                              
+ Member Name (MEMBNAME)                      SC11                              
+ Coordinator (COORDNTR)                       N/A                              
+ Assistant (ASSIST)                           N/A                              
+ Data Sharing Enabled (DSHARE)                YES                              
+ Random Attach (RANDOMATT)                      Y                              
+ (DEL_CFSTRUCTS_ON_RESTART)                    NO                              
+ (PEER_RECOVERY)                             NONE                              
===============================================================================

Navigation

For additional information about:

Related topics, select one of the options on the top of the panel.
Other topics, use the PF keys.

Fields

The DSNZ command displays the following lines to reflect the usage of the Db2 SET SYSPARM command. To each of these lines, the corresponding date on which this particular module is assembled is displayed.

DSNZPARM Module: The name of the DSNZPARM module that is specified for Db2 startup.
Initial Module: The name of the initial DSNZPARM load module.
Previous Module: The name of the previous DSNZPARM load module.
Assembly Date: The date on which this module was assembled.

DSNTIPK-Data Sharing Parm

Group Name (GRPNAME) (QWPAGRPN)

The name of a new or of an existing Db2 data sharing group.

Member name (MEMBNAME) (QWPAMBRN)

The name of a new or of an existing Db2 data sharing member. This field displays N/A if data sharing is not enabled.

Coordinator (COORDNTR) (QWPACOOR)

Determines whether this Db2 can send parallel tasks to eligible Db2 members.

Valid values: Y (Yes) or N (No).

Default: Yes

Db2 10 only.

Assistant (ASSIST) (QWPAASST)

Determines whether this Db2 can assist parallel processing at BIND time and at RUN time.

To be used as an assistant at RUN time, the threshold of the VPPSEQT and the VPXPSEQT buffer pool must be greater than 0.

Valid values: Y (Yes) or N (No)If YES, this member can assist in parallel processing.

Db2 10 only.

Data Sharing (DSHARE) (QWPADSHR)

Determines whether Db2 data sharing is enabled.

Valid values: YES or NO.

Random Attach (RANDOMATT) (QWPARAND)

The flag whether this Db2 is eligible for the random group attach.

Valid values: Y (Yes) or N (No).

(DEL_CFSTRUCTS_ON_RESTART) (QWP1DCFS)

During restart, it is attempted to delete CF structures including the SCA, IRLM LOCK structures and allocated group buffer pools.

PEER_RECOVERY (QWPAPEERREC)

Specifies whether the data sharing member participates in data sharing peer recovery. Valid values

NONE (default): Does not participate in peer recovery. Use this option if you have configured the z/OS Automatic Restart Manager (ARM) to restart failed Db2 members.
RECOVER: Member is recovered by a peer member if it fails.
ASSIST: Member attempts to initiate peer recovery for other failed members. When this member detects a failure it attempts to initiate a LIGHT(YES) restart for the failed member. if it has not already been initiated to recover the retained locks.
BOTH: Both RECOVER and ASSIST options are activated for this member

Db2 12 and later.