DSNZPARM Utility Parameters

This panel displays information about the parameters that affect Db2 utility default settings. 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.

 
>       Help PF1      Back PF3      Left PF10      Right PF11                  
> R.H.L                                                                        
>       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      J-DATA SHARING  K-STORED PROC    *-UTIL 
>  M-APPL      N-DATA      O-PERF      P-BUFFERPOOL    Q-OTHERS                
===============================================================================
>                        DSNZPARM UTILITY PARAMETERS                           
 ZUTL                                                                          
+ Collection Interval:  REALTIME                SNAPTIME: 07/08/16 11:48:37.88 
+                                                                              
+ DSNZPARM Module                                                DSNZPARM      
+ Assembly Date                                                  04/14/16      
+ Initial Module                                                 DSNZPARM      
+ Assembly Date                                                  04/14/16      
+ Previous Module                                                DSNZPARM      
+ Assembly Date                                                  04/14/16      
+                                                                              
+ DSNTIP6-Utility Parms 1                                                      
+------------------------------------                                          
+ Temp DS Unit Name (VOLTDEVT)                                      SYSDA      
+ (UTIL_TEMP_STORCLAS)                                                         
+ Statistics History (STATHIST)                                      NONE      
+ Statistics Rollup (STATROLL)                                        YES      
+ Utility Timeout (UTIMOUT)                                             6      
+ UT Sort DS Allocation (UTSORTAL)                                    N/A      
+ Ignore Sortnum Stmt (IGNSORTN)                                       NO      
+ Set Check Pending (CHECK_SETCHKP)                                   N/A      
+ UT DB2 Sort Use (DB2SORT)                                           N/A      
+ Template Time (TEMPLATE_TIME)                                       UTC      
+ Max Utils Parallel (PARAMDEG_UTIL)                                   99   
+ (STATCLGSRT)
+ (STATPGSAMP)  
+ (LOAD_RO_OBJECTS)
+ (UTILS_BLOCK_FOR_CDC) 
+                                                                              
+ DSNTIP61-Utility Parms 2                                                     
+------------------------------------                                          
+ (COPY_FASTREPLICATION)                                        PREFERRED      
+ Fast Restore (REC_FASTREPLICATION)                            PREFERRED      
+ (FLASHCOPY_PPRC)                                               REQUIRED  
+ (FLASHCOPY_XRCP)    
+ Default Template (FCCOPYDDN)               DBC1.&DB..&SN..N&DSNUM..&UQ.      
+ Copy (FLASHCOPY_COPY)                                                NO      
+ Load (FLASHCOPY_LOAD)                                                NO      
+ (FLASHCOPY_REORG_TS)                                                 NO      
+ (FLASHCOPY_REBUILD_INDEX)                                            NO      
+ (FLASHCOPY_REORG_INDEX)                                              NO      
+                                                                              
+ DSNTIP62-Utility Parms 3                                                     
+------------------------------------                                          
+ (SYSTEM_LEVEL_BACKUPS)                                               NO      
+ (RESTORE_RECOVER_FROMDUMP)                                           NO      
+ (UTILS_DUMP_CLASS_NAME)                                                      
+ Max Tape Units (RESTORE_TAPEUNITS)                                    0      
+ (REORG_IGNORE_FREE_SPACE)                                           N/A      
+ Alternate Copy Pool (ALTERNATE_CP)                                           
+ DB Backup STG Group (UTIL_DBBSG)                                             
+ LOG Backup STG Group (UTIL_LGBSG)                                            
+ (UTILS_HSM_MSGDS_HLQ)                                               N/P      
+                                                                              
+ DSNTIP63-Utility Parms 4                                                     
+------------------------------------                                          
+ (REORG_PART_SORT_NPSI)                                             AUTO      
+ (REORG_LIST_PROCESSING)                                        PARALLEL      
+ (REORG_MAPPING_DATABASE)                                                     
+ (REORG_DROP_PBG_PARTS)                                          DISABLE      
+ (REORG_TS_NOPAD_DEFAULT)                                              Y
+ (REORG_INDEX_NOSYSUT1)                                                N
+ (REORG_IC_LIMIT_DASD)                                                 0
+ (REORG_IC_LIMIT_TAPE)                                                 0
+ (UTILS_USE_ZSORT)                                                     N
+ (LOAD_DEL_IMPLICIT_SCALE)                                             N
+ (UTILITY_HISTORY)                                                     N
===============================================================================

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.
DSNTIP6 - Utility Parms 1
Temp DS Unit Name (VOLTDEVT) (QWP4VDTY)
This parameter determines the device type for temporary data sets.
(UTIL_TEMP_STORCLAS) (QWP4CHEC)
This parameter determines the name of the SMS storage class that is used by Db2 to define temporary shadow data sets. A blank value indicates that the temporary shadow data sets are defined in the same storage class as the production page set.
Statistics History (STATHIST) (QWP4STHT)
This parameter determines the default for the statistics history. Depending on the specified value, catalog changes that are made by DB2 are recorded in the catalog history tables.
Valid values:
ALL
All changes are recorded.
NONE
Changes are not recorded.
SPACE
All changes that are related to space are recorded.
ACCESSPATH
All changes that are related to accesspath are recorded.
Default: NONE
Statistics Rollup (STATROLL) (QWP4STRL)
This parameter determines the default for the statistics rollup. It controls whether the RUNSTATS utility aggregates partition-level statistics.
Valid values:
NO
YES
Utility Timeout (UTIMOUT) (QWP4UTO )
This parameter determines the utility timeout factor.
UT Sort Data Allocation (UTSORTAL) (QWP3SRAL)
Indicates that the utility will use sortnum elimination logic for sort tasks.
Valid values:
NO
YES
YES is the default. Db2 10 and Db2 11 only.
Ignore Sortnum Stmt (IGNSORTN) (QWP4IGSN)
This parameter determines whether the SORTNUM keyword specification in a UT JOB STMT is ignored.
Valid values:
NO
YES
Set Check Pending (CHECK_SETCHKP) (QWP4CSCP)
Specifies whether the check data and the check LOB utilities should place inconsistent objects in a check pending status. When these utilities detect an inconsistency in an object, they write a diagnostic message and end with return code 4.
Valid values:
YES
The object is placed in check pending status
NO (default)
The object is not placed in check pending status. Objects that are already in check pending status remain so.
NO
YES
Db2 10 and Db2 11 only.
UT DB2 Sort Use (DB2SORT)
Enables the use of the DB2 sort product from utilities when it is installed. DFSORT is used otherwise. Valid values are ENABLE (default) and DISABLE. Db2 10 and Db2 11 only.
Template Time (TEMPLATE_TIME) (QWP4TPTM)
This parameter determines the default setting for the TIME option of the Db2 UTILITIES TEMPLATE statement.
Valid values:
LOCAL
UTC (Coordinated universal time)
Default: UTC.
Db2 11 and later.
Max Utils Parallel (PARAMDEG_UTIL) (QWP4UMD )
This parameter determines the maximum degree of parallelism that is allowed when a Db2 utility is driving parallelism.
Valid values:
0 (Unlimited)
1 To 32767
Default: 99
Db2 11 and later.
(STATCLGSRT) - (QWP4STACS)
The STATCLGSRT subsystem parameter specifies how the sort program is to be used by the RUNSTATS utility or by an inline statistics job when collecting statistics on a single column that is defined with the COLGROUP option.

ZPARM NAME: DSN6SPRM.STATCLGSRT

Range: 0 - 4096 MB

Default: 10

0
An indication that a data sort is always performed.
1 - 4096
The amount of memory space for the utility to use to avoid the data sort. Values are specified in megabytes (for example, 4096, which is the maximum allowable value). Increasing the value might be necessary when utility jobs specify a large number of single-column COLGROUPs, and message DSNU1388I is issued. Although histogram statistics can be collected in the same RUNSTATS or inline statistics job, any COLGROUPs for which histogram statistics are being collected are not eligible for the sort-avoidance performance improvement. You can override the STATCLGSRT value for a particular utility job by specifying the STATCLGMEMSRT option on the utility statement.
Db2 11 and later.
(STATPGSAMP) - (QWP4STACS)
The STATPGSAMP subsystem parameter specifies whether the RUNSTATS utility uses page-level sampling by default for universal table spaces.

Default: S (SYSTEM)

ZPARM NAME: DSN6SPRM.STATPGSAMP

Valid values are:
S
(Default) Db2 determines the default sampling method. (FL 505) SYSTEM has the same meaning as YES.
Y
RUNSTATS always executes as if the TABLESAMPLE SYSTEM AUTO utility option is specified. (TABLESAMPLE SYSTEM AUTO specifies that RUNSTATS uses page sampling, and the utility determines the sampling rate.) The only exception is if the RUNSTATS statement contains TABLESAMPLE SYSTEM and a value other than AUTO. In that case, RUNSTATS uses that value instead of AUTO. If the SAMPLE utility option is specified to request row sampling, RUNSTATS ignores that option and uses page sampling instead.
N
RUNSTATS does not use page sampling by default. Any sampling is determined by the options that are specified in the RUNSTATS statement.
Db2 12 and later.
(LOAD_RO_OBJECTS) (QWP4LIRO)
Specifies whether Db2 utilities allow LOAD on all SHRLEVELs including the data loading and inserting cases to load into read-only (RO) objects.
Valid options are:
NO
(Default) Db2 utilities disallow LOAD with any SHRLEVELs to load into read-only (RO) objects.
YES
Db2 utilities allow LOAD with any SHRLEVELs to load into read-only (RO) objects.
(UTILS_BLOCK_FOR_CDC) (QWP4UBCDC)
Specifies whether to block the utilities below for tables with replication enabled (i.e. a table DATA CAPTURE CHANGES attribute) or table spaces which contain such tables:
  • CHECK DATA with DELETE YES LOG NO
  • LOAD with SHRLEVEL NONE or REFERENCE
  • RECOVER with TOLOGPOINT, TORBA, TOCOPY, TOLASTCOPY, or TOLASTFULLCOPY
  • REORG TABLESPACE with DISCARD
  • REPAIR with LOCATE DELETE
Valid values are:
NO
(Default) Allows Db2 utilities to update replicated tables or table spaces with replication enabled.
YES
Blocks Db2 utilities from updating replicated tables or table spaces with replication enabled.
DSNTIP6 - Utility Parms 2
(COPY_FASTREPLICATION) (QWP4CYFR)
This parameter specifies for the COPY utility whether FlashCopy fast replication is preferred, required, or not used for the creation of the FlashCopy image copy.
Valid values:
Preferred
The COPY utility directs DSS COPY to use fast replication if available.
Required
The COPY utility directs DSS COPY to only use fast replication, ensuring that object copies occur as fast as possible. Resource contention and unavailability are reduced.
None
The COPY utility directs DSS COPY not to use fast replication.
Db2 12 and later.
Fast Restore (REC_FASTREPLICATION) (QWP4RFRP)
This parameter determines whether FlashCopy® is used by the RECOVER utility to recover from a FlashCopy image copy.
If you use BACKUP SYSTEM to create system-level backup copies, using FlashCopy for restoring might cause BACKUP SYSTEM to fail because cascading FlashCopy is not supported.
Valid values:
NONE
PREFERRED
REQUIRED
Default: PREFERRED
NONE
Standard input and output is used to restore the FlashCopy image copy.
PREFERRED
FlashCopy is only used if FlashCopy support is available.
REQUIRED
FlashCopy is used to recover from a FlashCopy image copy to ensure that copies are recovered as fast as possible. However, recovery fails if FlashCopy support is not available.
(FLASHCOPY_PPRC) (QWP4FCPPRC)
This parameter determines the behavior for DFSMSDSS FlashCopy requests by Db2 utilities when the target disk storage volume is the primary device in a peer-to-peer remote copy (PPRC) relationship. A PPRC relationship exists when a Db2 utility is using DFSMSDSS FlashCopy technology to create a FlashCopy image copy or shadow data sets (for the online check utility) and the target disk storage volume is mirrored by another disk device on a different system.
The FlashCopy PPRC option pertains to COPY, REORG TABLESPACE, REORG INDEX, REBUILD INDEX, LOAD, RECOVER, and the CHECK utilities.
Valid values:
Blank
Mirroring is not preserved by DFSMSDSS.
NONE
Mirroring is not preserved by DFSMSDSS when it is processing a Db2 utilities request, even if all configuration requirements for preserving the mirror operation are met.
PREFERRED
DFSMSDSS allows the volume pair to go into duplex pending state when processing a Db2 utilities request only if it is required.
REQUIRED
DFSMSDSS does not permit the PPRC volume pair to go into duplex pending state when processing a Db2 utilities request.
Default: REQUIRED
(FLASHCOPY_XRCP) - (QWP4FCXC)
The FLASHCOPY_XRCP subsystem parameter specifies whether a data set level FlashCopy operation is allowed to a primary volume in an XRC relationship when the z/OS DFSMSdss support for RPFC for XRC is installed and enabled.

ZPARM NAME: DSN6SPRM.FLASHCOPY_XRCP

Valid values are:

Y
(Default) If z/OS DFSMSdss support for RPFC in XRC is installed and enabled, supported utilities specify the FCTOXRCPrimary option when they issue DFSMSdss COPY commands. YES is ignored in the following situations:
  • For CHECK utilities, if the CHECK_FASTREPLICATION subsystem parameter value is NONE.
  • For the RECOVER utility, if the REC_FASTREPLICATION subsystem parameter value is NONE.
N
The utilities do not specify the FCTOXRCPrimary option when they issue DFSMSdss COPY commands.
Db2 12 and later.
Default Template (FCCOPYDDN) (QWP4FCCD)
Offset from the beginning of QWP4 to QWP4FCCD.
Fields for the FCOPYDDN subsystem parameter: Length of QWP4FCCD_VAR.
This parameter determines the default settings of the FCCOPYDDN subsystem parameter for the COPY, LOAD, REBUILD INDEX, REORG INDEX, and REORG TABLESPACE UTILITY CONTROL statements when the FlashCopy parameter is set to YES or CONSISTENT.
FCCOPYDDN determines a Db2 utilities template data set name expression that is used to derive the COPY DATA SET NAME that is allocated by the utility during operation.
Copy (FLASHCOPY_COPY) (QWP4FCCP)
This parameter determines whether the COPY utility is using FLASHCOPY=YES and the system parameter settings for FCCOPYDDN when these keywords are not included in the utility control statement.
Valid values:
NO
YES
DEFAULT: NO
Load (FLASHCOPY_LOAD) (QWP4FCLD)
This parameter defines whether the LOAD utility is using FLASHCOPY=YES and the system parameter setting for FCCOPYDDN when these keywords are not included in the utility control statement.
Valid values:
NO
YES
DEFAULT: NO
(FLASHCOPY_REORG_TS) (QWP4FROT)
This parameter determines whether the REORG TABLESPACE utility is using FLASHCOPY=YES and the system parameter setting for CCOPYDDN when these keywords are not included in the utility control statement.
Valid values:
NO
YES
DEFAULT: NO
(FLASHCOPY_REBUILD_INDEX) (QWP4FRBI)
This parameter determines whether the REBUILD INDEX utility is using FLASHCOPY=YES and the system parameter setting for FCCOPYDDN when these keywords are not included in the UTILITY CONTROL statement.
Valid values:
NO
YES
DEFAULT: NO
(FLASHCOPY_REORG_INDEX) (QWP4FROI)
This parameter determines whether the REORG INDEX utility is using FLASHCOPY=YES and the system parameter setting for FCCOPYDDN when these keywords are not included in the UTILITY CONTROL statement.
Valid values:
NO
YES
DEFAULT: NO
DSNTIP6 - Utility Parms 3
(SYSTEM_LEVEL_BACKUPS) (QWP4SLBU)
This parameter determines whether the RECOVER utility is using system-level backup copies as a recovery base additional to image copies and concurrent copies for object-level recoveries. If you do not want system-level backup copies with the BACKUP SYSTEM utility, specify NO.
For more information, see the chapter Recover in the Db2 10 for z/OS, Utility Guide and Reference, SC19-2984-08.
Valid values:
NO
YES
Default: NO
(RESTORE_RECOVER_FROMDUMP) (QWP4RRFD)
This parameter determines for the restore system and the RECOVER utilities whether the system-level backup that is selected as the recovery base is used from the disk copy of the system-level backup (NO) or from the dump on tape (YES).
Valid values:
NO
YES
Default:
NO
(UTILS_DUMP_CLASS_NAME) (QWP4RSDC)
This parameter determines the name of the DFSMSHSM dump clas that is used by the Restore System Utility to restore from a system-level backup that is dumped to tape.
Max Tape Units (RESTORE_TAPEUNITS) (QWP4RSMT)
This parameter determines the maximum number of tape units or tape drives that the Restore System Utility can use to restore from a system-level backup that is dumped to tape.
Valid values:
0 (No limit)
1-255
(REORG_IGNORE_FREE_SPACE) (QWP4RIFS)
This parameter specifies whether the Reorg Tablespace Utility should ignore the PCTFREE and FREEPAGE values while reloading data rows into a a PBG table space in the following circumstances:
  • When a subset of the PBG partitions are reorganized
  • When the table in the PBG table space as LOB columns
The default is NO (PCTFREE and FREEPAGE values are honored).
Db2 10 and Db2 11 only.
Alternate Copy Pool (ALTERNATE_CP) (QWP4BSACP)
Specifies an optional alternate SMS copy pool for the DB2 BACKUP SYSTEM utility.
Valid values:
blank (default)
DB2 BACKUP SYSTEM uses the standard copy pool only.
1- 16 alphanumeric characters
DB2 BACKUP SYSTEM uses the specified copy pool as the alternate copy pool for the system-level backups. DB2 BACKUP SYSTEM alternates between using the standard copy pool and the alternate copy pool for system-level backups.
Db2 12 and later.
DB Backup STG Group (UTIL_DBBSG) (QWP4UDBSG)

Specifies an optional backup SMS storage group to be used by the DB2 BACKUP SYSTEM utility for the DB copy pool.

Valid values:
blank (default)
DB2 BACKUP SYSTEM requests that DFSMShsm uses the copy pool backup storage group that is associated with each storage group in the copy pool.
Valid SMS storage group name
DB2 BACKUP SYSTEM requests that DFSMShsm uses the specified copy pool backup storage group. The specified storage group must defined with the COPY POOL BACKUP attribute.
Db2 12 and later.
LOG Backup STG Group (UTIL_LGBSG) (QWP4ULBSG)

Specifies an optional backup SMS storage group to be used by the DB2 BACKUP SYSTEM utility for the LOG copy pool.

Valid values:
blank (default)
DB2 BACKUP SYSTEM requests that DFSMShsm uses the copy pool backup storage group that is associated with each storage group in the copy pool.
Valid SMS storage group name
DB2 BACKUP SYSTEM requests that DFSMShsm uses the specified copy pool backup storage group. The specified storage group must defined with the COPY POOL BACKUP attribute.
Db2 12 and later.
(UTILS_HSM_MSGDS_HLQ) (QWP4UHMD)
Shows the high level qualifier (HLQ) for data sets (DS) to be allocated by the DB2 BACKUP SYSTEM and RESTORE SYSTEM utilities to receive messages from the Data Facility Hierarchical Storage Manager (DFHSM) and the IBM Data Facility Data Set Services (DFDSS).
Valid values:
  • blank (default)
  • Valid data set qualifier of 1 to 6 characters
Db2 12 and later.
DSNTIP63 - Utility Parms 4
(REORG_PART_SORT_NPSI) (QWP4RPSN)
This parameter determines the default method of building a non-partitioned secondary index (NPSI) during REORG TABLESPACE PART. This setting is used when the SORTNPSI keyword is not provided in the utility control statement.
The SORTNPSI keyword determines whether REORG TABLESPACE PART is sorting all keys of a NPSI. This setting is ignored for a REORG that is not part-level or a REORG with no NPSIS.
Valid values:
AUTO
If sorting all keys of the NPSI(s) improves the elapsed time and the CPU performance, all keys are sorted.
NO
If sorting all keys of the NPSI(s) improves the elapsed time and the CPU performance, all keys are sorted.
YES
Only the keys of the NPSI(s) that are in the scope of the REORG are sorted.
Default:
AUTO
(REORG_LIST_PROCESSING) (QWP4RLPR)
This parameter determines the default setting for the parallel option of the Db2 REORG TABLESPACE utility if the REORG TABLESPACE control statement does not include the parallel keyword. Depending on the value, the type of processing for partitioned table spaces is selected.
The Db2 REORG TABLESPACE utility can process partitions that are specified in the INPUT LISTDEF STATEMENT like this:
Valid values:
PARALLEL YES
All partitions are processed in a single utility execution
PARALLEL NO
Each partition is processed in a separate utility execution
Default:
PARALLEL YES
Db2 11 and later.
(REORG_MAPPING_DATABASE) (QWP4RMDB)
This parameter determines the default database that is used by REORG TABLESPACE SHRLEVEL CHANGE to create the mapping table. When a REORG TABLESPACE SHRLEVEL CHANGE REQUEST is processed, the REORG UTILITY can create its own mapping table and mapping index or it can process user input.
If this parameter is set to a valid database, REORG allocates the mapping table in the specified database.
If this parameter is set to NULL, REORG allocates the mapping table in an implicitely defined database.
(REORG_DROP_PBG_PARTS) (QWP4RPBG)
This parameter determines whether REORG removes trailing empty partitions when operating on an entire partitioned by growth (PBG) table space. An empty trailing partition occurs when REORG moves all data records from a partition into lower numbered partitions.
This parameter is only used if REORG runs against an entire PBG table space. It is ignored by REORGS of non-PBG table spaces and for partition-level REORGS of PBG table spaces.
Valid values:
ENABLE
If there is any trailing empty partition after REORG is completed, it is removed.
DISABLE
The number of PBG partitions that is present after REORG is completed is equal or greater than the number of partitions that was present before REORG was run. Even if REORG can relocate all data records into the lowest numbered partitions, trailing empty PBG partitions are retained.
Default:
DISABLE
Db2 11 and later.
(REORG_TS_NOPAD_DEFAULT) - (QWP4RTNP)
When the REORG TABLESPACE utility is run with DISCARD or UNLOAD EXTERNAL, the NOPAD option specifies whether variable-length columns in unloaded or discarded records occupy the actual data length without additional padding. The unloaded records can have varying lengths. The REORG_TS_NOPAD_DEFAULT subsystem parameter indicates whether the NOPAD option is NO or YES by default when it is omitted from the utility control statement.

ZPARM NAME: DSN6SPRM.REORG_TS_NOPAD_DEFAULT

Y
(Default) Specifies that, by default, the variable-length columns in the unloaded or discarded records occupy the actual data length without additional padding.
N
Specifies that, by default, REORG processing pads variable-length columns in the unloaded or discarded records to their maximum length; the unloaded or discarded records to their maximum length; the unloaded or discarded records have equal lengths for each table.
Db2 12 and later.
(REORG_INDEX_NOSYSUT1) (QWP4RINSU)
Specifies whether the REORG INDEX SHRLEVEL REFERENCE or CHANGE utility should avoid using the SYSUT1 or work data set to hold the unloaded index keys. The utility passes the unloaded keys in memory as input to the index build for this process. Enablement of this option also allows REORG INDEX to utilize parallel sub-tasking to unload and to build the index keys in its internal processing.
Valid values are:
NO
(Default) REORG INDEX uses the SYSUT1 or specified work data set to hold the unloaded index keys.
YES
REORG INDEX avoids using the SYSUT1 or specified work data set to hold the unloaded index keys, which also enables the utility to utilize parallel sub-tasking to unload and to build the index keys.
(REORG_IC_LIMIT_DASD) (QWP4RICLD)
Specifies the maximum number of sequential DASD image copies that the REORG TABLESPACE utility can allocated. Valid settings are integers from 0 to 32767. Default setting of 0 means that the number of DASD image copies that the REORG TABLESPACE utility allocates is based on the number of objects being reorganized without a user imposed limit.
(REORG_IC_LIMIT_TAPE) (QWP4RICLT)
Specifies the maximum number of sequential TAPE image copies that the REORG TABLESPACWE utility can allocate. Valid settings are integers from 0 to 32767. Default setting of 0 means that the number of TAPE image copies that the REORG TABLESPACE utility allocates is based on the number of objects being reorganized without a user imposed limit.
(UTILS_USE_ZSORT) (QWP4UZS)
Specifies whether Db2 utilities will use the IBM Integrated Accelerator for Z Sort interface when invoking DFSORT for utility processing. However, the use of the integrated sort acceleration depends on other run-time variables and hardware.
Valid values are:
NO
(Default) Db2 utilities do not use integrated sort acceleration when invoking DFSORT.
YES
Db2 utilities attempt to use the integrated sort acceleration if possible when invoking DFSORT.
(LOAD_DEL_IMPLICIT_SCALE) (QWP4LDISCALE)
Specifies how the load utility with the format delimit option processes decimal data that does not contain a explicit decimal point.
Valid options are:
NO
(Default) The decimal point is placed to the right of the rightmost digit of the number.
YES
The decimal point is determined from the scale that is specified in the field specification in the load utility control statement.
Db2 12 and later.
(UTILITY_HISTORY) (QWP4UTHIST)
Specifies whether information about utility history is collected and stored in the SYSIBM.SYSUTILITIES catalog table.
Valid options are:
NONE
(Default) Utility information is not collected.
UTILITY
Utility information is collected. Every time a utility is executed, a new row is added to the SYSIBM.SYSUTILITIES catalog table. Information in the row is continuously updated until the utility operation has completed.
OBJECT
Utility and object information is collected. In addition to returning information about utilities, the information for objects processed by a utility is also collected. For every new object that is processed by a utility, a new row is added to the ASYSOBJEVENTS row is added to the SYSIBM.SYSUTILITIES catalog table. Information in the row is continuously updated until the utility operation has completed.
Db2 13 and later.