DSNZPARM Archiving Parameters

This panel shows information about the parameters that affect Db2 archiving.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.

 
________________ ZPARC    VTM     O2       V540.#P SC11 S 07/07/16 15:52:28 2 
>       Help PF1      Back PF3      Left PF10      Right PF11                  
> R.H.D                                                                        
>       DSNZPARM INFORMATION:  Enter a selection letter on the top line.       

>  A-THREAD    B-TRACE     C-LOGGING   *-ARCHIVING     E-AUTH/RLF/DDF   F-IRLM 
>  G-STORAGE   H-DATASET   I-DDCS      J-DATA SHARING  K-STORED PROC    L-UTIL 
>  M-APPL      N-DATA      O-PERF      P-BUFFERPOOL    Q-OTHERS                
===============================================================================
>                        DSNZPARM ARCHIVING PARAMETERS                         
 ZARC                                                                          
+ Collection Interval:  REALTIME                SNAPTIME: 07/07/16 15:52:29.00 
+                                                                              
+ DSNZPARM Module                                                DSNZPARM      
+ Assembly Date                                                  04/14/16      
+ Initial Module                                                 DSNZPARM      
+ Assembly Date                                                  04/14/16      
+ Previous Module                                                DSNZPARM      
+ Assembly Date                                                  04/14/16      
+                                                                              
+ DSNTIPA-Archive Log Parameters                                               
+------------------------------------                                          
+ Allocation Unit (ALCUNIT)                                           CYL      
+ Primary Quantity (PRIQTY)                                           125      
+ Secondary Quantity (SECQTY)                                          15      
+ Catalog Archive Data Set (CATALOG)                                  N/A      
+ Device Type 1 (UNIT)                                               DASD      
+ Device Type 2 (UNIT2)                                              NONE      
+ Block Size (BLKSIZE)                                              24576      
+ Read Tape Units (MAXRTU)                                              2      
+ Tape Unit Dealloc Period (DEALLCT)                                 0: 0      
+ Recording Max (MAXARCH)                                           10000      
+ Write to Oper (ARCWTOR)                                             YES      
+ Retention Period (ARCRETN)                                         9999      
+ Quiesce Period (QUIESCE)                                              5      
+ Compact Data (COMPACT)                                               NO      
+ Single Volume (SVOLARC)                                              NO      
+ (ZHYPERLINK)
+                                                                              
+ DSNTIPH-System Resource                                                      
+------------------------------------                                          
+ Number of Active Logs (TWOACTV)                                       1      
+ Number of Archive Logs (TWOARCH)                                      1      
+ ARC1 Prefix (ARCPFX1)                                DBC1.SC11.ARCHLOG1      
+ ARC2 Prefix (ARCPFX2)                                DBC1.SC11.ARCHLOG2      
+ Timestamp Archives (TSTAMP)                                         YES      
+                                                                              
+ Others-System Resource                                                       
+------------------------------------                                          
+ Dual BSDS Mode (TWOBSDS)                                            YES      
===============================================================================

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.
DSNTIPA-Archive Log Parameters
Allocation Unit (QWP3CYL/QWP3TRCK)
The ALCUNIT subsystem parameter determines the unit type that is used by Db2 to allocate space for archive data sets.
Valid values:
BLK(BLOCK)
CYL(CYLINDER)
TRK(TRACK)
Default: 
BLK
Primary Quantity (QWP3RISP)
The PRIQTY subsystem parameter determines the amount of primary space that is allocated for a disk data set. The units for this parameter are specified in the ALLOCATION UNITS field.
Valid values: 
Blank
1 to 999999
Default: 
Blank
Secondary Quantity (QWP3SECS)
The SECQTY subsystem parameter determines the amount of secondary space that is allocated for a disk data set. The units for this parameter are specified in the ALLOCATION UNITS field.
Valid values: 
Blank
1 to 999999
Default: 
Blank
Catalog Archive Data Set (CATALOG) (QWP3CTLG)
The value of the CATALOG DATA field specifies whether archive log data sets on tape are to be cataloged.
Valid values:
YES, NO
Default:
NO
DB2 10 and DB2 11 only.
Device Type 1 (QWP3UNT1)
The UNIT subsystem parameter determines the device type or the unit name that is used for storing the first copy of archive log data sets.
Valid values:
Device type
Unit name
Default: 
TAPE
Device Type 2 (QWP3UNT2)
The UNIT2 subsystem parameter determines the device type or the unit name that is used for storing the second copy of archive log data sets.
Valid values: 
Device type
Unit name
Default: 
None
Block Size (QWP3BKSZ)
The BLKSIZE subsystem parameter determines the block size that is used for the archive log data set.
Valid values:
 8192 to 28672
Default: 
24576
Read Tape Units (QWP2MRTU)
The MAXRTU subsystem parameter determines the maximum number of dedicated tape units that can be allocated to concurrently read archive log tape volumes.
Valid values: 
1 to 99
Default: 
2
Tape Unit Dealloc Period (QWP2DMIN:QWP2DSEC)
The DEALLCT subsystem parameter determines the length of time that an archive read tape unit can remain unused before it is deallocated.
The time is displayed like this: Minutes : Seconds
Valid values: 
Minutes
Seconds
1440
NOLIMIT
Default: 
0
Recording Max (QWP2ARCL)
The MAXARCH subsystem parameter determines the maximum number of archive log volumes that are recorded in the BSDS.
If you have a dual archive, this number is for each log data set. For example, if 500 is specified as the maximum number, allow 500 COPY-1 and 500 COPY-2 data sets in the BSDS.
Valid values:
10 to 10000
Default: 
10000
Write to Oper (QWP3WTOR)
The ARCWTOR subsystem parameter determines whether DB2 sends a message to the operator and waits for a reply before attempting to mount an archive log data set.
Valid values: 
NO
YES
Default: 
YES
Retention Period (QWP3RETN)
The ARCRETN subsystem parameter determines the retention period. This is the number of days that Db2 retains archive log data sets.
The retention period is added to the current date to calculate the expiration date of the archive log data sets.
Valid values:
0 to 9999
Default: 
9999
Quiesce Period (QWP3MQP)
The QUIESCE subsystem parameter determines the maximum amount of time in seconds that Db2 is allowed to attempt a full system quiesce.
Valid values: 
1 to 999
Default: 
5
Compact Data (QWP3COMP)
The COMPACT subsystem parameter determines whether data that is written to archive logs is compacted.
Valid values: 
NO
YES
Default: 
NO
Single Volume (QWP3SVOL)
The SVOLARC subsystem parameter determines whether a single volume is used by Db2 for disk archives.
When archiving to disk, the number of online storage volumes for the specified UNIT name is used to determine a count of candidate volumes up to 15.
Valid values: 
NO
YES
Default: 
NO
(ZHYPERLINK) - (QWP4ZHYPL)
The ZHYPERLINK subsystem parameter specifies the default scope of the zHyperLink protocol for I/O requests.

ZPARM NAME: ZHYPERLINK

Valid values are:

DISABLE
(Default) Db2 does not use zHyperLink for any I/O requests.
ENABLE
All eligible I/O requests that Db2 makes request the zHyperLink protocol.
DATABASE
Db2 requests the zHyperLink protocol only for database synchronous read I/Os.
ACTIVELOG
Db2 requests the zHyperLink protocol only for active log write I/Os.
Db2 11 and later.
DSNTIPH-System Resource
Number of Active Logs (QWP2DUAL)
The TWOACTV subsystem parameter determines the number of copies of the active log that is maintained by Db2.
Valid values: 
1 (single locking)
2 (dual locking)
Default: 
2
Number of Archive Logs (QWP2ADL)
The TWOARCH subsystem parameter determines the number of copies of the archive log that is produced by Db2 during offloading.
Valid values: 
1
2
Default: 
2
ARC1 Prefix (QWP3RE1N)
The ARCPFX1 subsystem parameter determines the prefix that is used for the first copy of the archive log data set.
Valid values: 
Valid data set name prefix
1 to 35 characters
Default: 
DSNCAT.ARCHLOG1 or DSNCAT.DSN1.ARCLG1
ARC2 Prefix (QWP3RE2N)
The ARCPFX2 subsystem parameter specifies the prefix that is used for the second copy of the archive log data set. If you use single logging, accept the default value.
Valid values: 
Valid data set name prefix
1 to 35 characters
Default: 
DSNCAT.ARCHLOG2 or DSNCAT.DSN1.ARCLG2
Timestamp Archives (QWP3DTIM)
The TSTAMP subsystem parameter determines whether the DB2 archive log data set name contains the date and time that the archive log data set is created.
Valid values: 
NO
YES
EXT
Default: 
NO
Dual BSDS Mode (QWP2DBSD)
The dual BSDS mode.
Valid values:
NO
YES