DB2 Utilities Parameters (DSNTIP6, DSNTIP61, DSNTIP62)

This topic shows detailed information about "System Parameters - DB2 Utilities Parameters (DSNTIP6, DSNTIP61, DSNTIP62)".

This block shows the default behavior of enhancements to the BACKUP SYSTEM and other utilities.

System Parameters - DB2 Utilities Parameters (DSNTIP6, DSNTIP61, DSNTIP62)

The field labels shown in the following sample layout of "System Parameters - DB2 Utilities Parameters (DSNTIP6, DSNTIP61, DSNTIP62)" are described in the following section.

DB2 UTILITIES PARAMETERS (DSNTIP6,DSNTIP61,DSNTIP62)           
----------------------------------------------------           
TEMPORARY UNIT NAME (VOLTDEVT)............................SYSDA
UTIL TEMP STORCLAS (UTIL_TEMP_STORCLAS).....................N/P
STATISTICS HISTORY (STATHIST)..............................NONE
STATISTICS ROLLUP (STATROLL)................................YES
UTILITY TIMEOUT FACTOR (UTIMOUT)..............................6
UT SORT DATA SET ALLOCATION (UTSORTAL)......................YES
IGNORE SORTNUM STMT (IGNSORTN)...............................NO
SET CHECK PENDING (CHECK_SETCHKP)............................NO
UT DB2 SORT USE (DB2SORT)...................................YES
TEMPLATE TIME (TEMPLATE_TIME)...............................UTC
MAXIMUM DEGREE OF UTILITY PARALLELISM (PARAMDEG_UTIL)........99
FAST REPLICATION (CHECK_FASTREPLICATION)..............PREFERRED
FAST RESTORE (REC_FASTREPLICATION)....................PREFERRED
COPY FAST REPLICATION (COPY_FASTREPLICATION)..........PREFERRED
FLASHCOPY PPRC (FLASHCOPY_PPRC)........................REQUIRED
DEFAULT TEMPLATE (FCCOPYDDN)...................................
DSNC11.&DB..&SN..N&DSNUM..&UQ.                                 
FLASHCOPY COPY (FLASHCOPY_COPY)..............................NO
FLASHCOPY LOAD (FLASHCOPY_LOAD)..............................NO
FLASHCOPY REORG TABLESPACE (FLASHCOPY_REORG_TS)..............NO
FLASHCOPY REBUILD INDEX (FLASHCOPY_REBUILD_INDEX)............NO
FLASHCOPY REORG INDEX (FLASHCOPY_REORG_INDEX)................NO
SYSTEM-LEVEL BACKUPS (SYSTEM_LEVEL_BACKUPS)..................NO
RESTORE/RECOVER (RESTORE_RECOVER_FROMDUMP)...................NO
DUMP CLASS NAME (UTILS_DUMP_CLASS_NAME).................'BLANK'
MAXIMUM TAPE UNITS (RESTORE_TAPEUNITS)........................0
REORG PART SORT NPSI (REORG_PART_SORT_NPSI)................AUTO
REORG LIST PROCESSING (REORG_LIST_PROCESSING)..........PARALLEL
REORG MAPPING DATABASE (REORG_MAPPING_DATABASE).............N/P
REORG DROP PBG PARTS (REORG_DROP_PBG_PARTS)..................NO
UTILITY CACHE OPTION (SEQPRES)..............................YES (DB2 10 only)
STATISTICS CLUSTERING (STATCLUS).......................ENHANCED (DB2 10 only) 
ALTERNATE COPYPOOL (ALTERNATE_CP)...........................N/P
DB BACKUP STG GROUP (UTIL_DBBSG)............................N/P
LOG BACKUP STG GROUP (UTIL_LGBSG)...........................N/P
HSM MESSAGE DS HLQ (UTILS_HSM_MSGDS_HLQ).................HSMHLQ

TEMPORARY UNIT NAME (VOLTDEVT)

Shows the device type or unit name for allocating temporary data sets. It is the direct access or disk unit name used for the precompiler, compiler, assembler, sort, linkage editor, and utility work-files in the tailored jobs and CLISTs.

It can be any device type acceptable to the DYNALLOC parameter of the SORT or OPTION options for DFSORT.

The default is SYSDA.

Install parameter TEMPORARY UNIT NAME on DSNTIPA2, or ZPARM VOLTDEVT in DSN6SPRM.

Field Name: QWP4VDTY

UTIL TEMP STORCLAS (UTIL_TEMP_STORCLAS)

Specifies the name of the SMS storage class that DB2 uses for defining temporary shadow data sets. A blank value indicates that the temporary shadow data sets a defined in the same storage class as the production page set. This field corresponds to field "UTIL TEMP STORCLAS" on installation panel DSNTIP6. The ZPARM name is UTIL_TEMP_STORCLAS in DSN6SPRM.

Field Name: QWP4CHEC

STATISTICS HISTORY (STATHIST)

Shows which inserts and updates are recorded in catalog history tables.

The report can show the following values:

N / NONE: Changes in the catalog are not recorded. This is the default.
A / ALL: All inserts and updates in the catalog are recorded.
P / ACCESSPATH: All inserts and updates to access path related catalog statistics are recorded.
S / SPACE: All inserts and updates to space related catalog statistics are recorded.

Install parameter STATISTICS HISTORY on panel DSNTIPO, or ZPARM STATHIST in DSN6SPRM.

Field Name: QWP4STHT

STATISTICS ROLLUP (STATROLL)

Shows whether RUNSTATS utility aggregates the partition level statistics, even though some parts may not contain data.

This should be YES for DB2 systems that have large partitioned table spaces, index spaces, or both. This enables the aggregation of part level statistics and helps the optimizer to choose a better access path.

Install parameter STATISTICS ROLLUP on panel DSNTIPO, or ZPARM STATROLL in DSN6SPRM.

Field Name: QWP4STRL

UTILITY TIMEOUT FACTOR (UTIMOUT)

Shows how much longer utilities can wait for a resource than SQL applications can.

This is the number of RESOURCE TIMEOUT units that a utility or utility command can wait for a lock or for all claims on a resource of a particular claim class to be released. The default value is 6, meaning a utility can wait 6 times longer than an SQL application for a resource.

Install parameter UTILITY TIMEOUT on panel DSNTIPI, or ZPARM UTIMOUT in DSN6SPRM.

Field Name: QWP4UTO

UT SORT DATA SET ALLOCATION (UTSORTAL)

Start of change In DB2 12 this field is a serviceability field. End of change

YES indicates that utilities invoke a SORT use and a space prediction algorithm for dynamically allocated SORT work data sets. The ZPARM name is UTSORTAL in DSN6SPRM.

Field Name: QWP4SRAL

IGNORE SORTNUM STMT (IGNSORTN)

Ignores SORTNUM clause in utility control statements. The ZPARM name is IGNSORTN in DSN6SPRM.

Field Name: QWP4IGSN

SET CHECK PENDING (CHECK_SETCHKP)

Start of change In DB2 12 this field is a serviceability field. End of change

YES sets the object in check-pending status when the check utility detects an inconsistency. This field corresponds to field "Set check pending" on installation panel DSNTIP61. The ZPARM name is CHECK_SETCHKP in DSN6SPRM.

Field Name: QWP4CSCP

UT DB2 SORT USE (DB2SORT)

Start of change In DB2 12 this field is a serviceability field. End of change

Enables the use of DB2 SORT.

Field Name: QWP4DB2SRT

TEMPLATE TIME (TEMPLATE_TIME)

Specifies the default setting for the TIME option of the template utility control statement. Possible values are:

UTC (utility control)
Local

This field corresponds to field TEMPLATE TIME on installation panel DSNTIP6. The ZPARM name is TEMPLATE_TIME in DSN6SPRM.

Field Name: QWP4TPTM

MAXIMUM DEGREE OF UTILITY PARALLELISM (PARAMDEG_UTIL)

The maximum degree of utility parallelism.

Field Name: QWP4UMD

FAST REPLICATION (CHECK_FASTREPLICATION)

The FASTREPLICATION type for check utilities:

N=NONE
P=PREFERRED
R=REQUIRED

This field corresponds to field "Fast replication" in installation panel DSNTIP6. The ZPARM name is CHECK_FASTREPLICATION in DSN6SPRM.

Field Name: QWP4CFRP

FAST RESTORE (REC_FASTREPLICATION)

Specifies how the Recover utility directs DFSMSdss copy to restore an image copy that was created with FLASHCOPY. This field corresponds to field "Fast restore" on installation panel DSNTIP6. The ZPARM name is REC_FASTREPLICATION.

Field Name: QWP4RFRP

COPY FAST REPLICATION (COPY_FASTREPLICATION)

Start of change Specifies whether FlashCopy fast replication is preferred, required, or should not be used. End of change

Start of change This field corresponds to field COPY FAST REPLICATION on INSTALLATION panel DSNTIP61. The ZPARM name is COPY_FASTREPLICATION in DSN6SPRM. End of change

Field Name: QWP4CYFR

FLASHCOPY PPRC (FLASHCOPY_PPRC)

Specifies the behavior for DFSMSdss FLASHCOPY requests when the target disk storage volume is the primary device in a peer-to-peer remote copy (metro mirror) relationship (DB2 field: QWP4FCPPRC). This field corresponds to field "FLASHCOPY PPRC" on installation panel DSNTIP6. The ZPARM name is FLASHCOPY_PPRC.

Field Name: QWP4FCPPRC

DEFAULT TEMPLATE (FCCOPYDDN)

Specifies the default setting of the FCCOPYDDN subsystem parameter for the COPY, LOAD, REBUILD INDEX, REORG INDEX, and REORG TABLESPACE utility control statements when the FLASHCOPY parameter is YES or CONSISTENT. FCCOPYDDN specifies a DB2 utility template data-set name expression that is used to derive the copy data-set name that is allocated by the utility during operation.

This field corresponds to field DEFAULT TEMPLATE on installation panel DSNTIP6. The ZPARM name is FCOPYDDN in DSN6SPRM.

Field Name: QWP4FCCD

FLASHCOPY COPY (FLASHCOPY_COPY)

YES indicates that the Copy utility uses the subsystem parameter settings for FLASHCOPY and FCCOPYDDN when those keywords are not present in the utility control statement. The ZPARM name is FLASHCOPY_COPY in DSN6SPRM.

Field Name: QWP4FCCP

FLASHCOPY LOAD (FLASHCOPY_LOAD)

YES indicates that the load utility uses the subsystem parameter settings for FLASHCOPY, FCCOPYDD, and FCAUXOBJS when those keywords are not present in the utility control statement. ZPARM NAME: FLASHCOPY_LOAD IN DSN6SPRM.

Field Name: QWP4FCLD

FLASHCOPY REORG TABLESPACE (FLASHCOPY_REORG_TS)

YES indicates that the Reorg Tablespace utility uses the subsystem parameter settings for FLASHCOPY, FCCOPYDDN, and FCAUXOBJS when these keywords are not present in the utility control statement. The ZPARM name is FLASHCOPY_REORG_TS in DSN6SPRM.

Field Name: QWP4FCROT

FLASHCOPY REBUILD INDEX (FLASHCOPY_REBUILD_INDEX)

YES indicates that the Rebuild Index utility uses the subsystem parameter settings for FLASHCOPY and FCCOPYDDN when those keywords are not present in the utility control statement (DB2 field: QWP4FCRBI). The ZPARM name is FLASHCOPY_REBUILD_INDEX in DSN6SPRM.

Field Name: QWP4FCRBI

FLASHCOPY REORG INDEX (FLASHCOPY_REORG_INDEX)

YES indicates that the Reorg Index utility uses the subsystem parameter settings for FLASHCOPY and FCCOPYDDN when these keywords are not present in the utility control statement (DB2 field: QWP4FCROI). The ZPARM name is FLASHCOPY_REORG_INDEX in DSN6SPRM.

Field Name: QWP4FCROI

SYSTEM-LEVEL BACKUPS (SYSTEM_LEVEL_BACKUPS)

Shows if RECOVER uses system level backups as the recovery base.

Install parameter SYSTEM-LEVEL BACKUPS on installation panel DSNTIP6, or ZPARM SYSTEM_LEVEL_BACKUPS in DSN6SPRM.

Field Name: QWP4SLBU

RESTORE/RECOVER (RESTORE_RECOVER_FROMDUMP)

If YES, the system-level backup that is the recovery base, is from a dump on tape. Otherwise NO is shown.

Install parameter RESTORE/RECOVER on installation panel DSNTIP6, or ZPARM RESTORE_RECOVER_FROMDUMP in DSN6SPRM.

Field Name: QWP4RRFD

DUMP CLASS NAME (UTILS_DUMP_CLASS_NAME)

The name of the DFSMSHSM dump class used by the restore system utility to restore from a system-level backup that has been dumped to tape.

Install parameter DUMP CLASS NAME on installation panel DSNTIP6, or ZPARM UTILS_DUMP_CLASS_NAME in DSN6SPRM.

Field Name: QWP4RSDC

MAXIMUM TAPE UNITS (RESTORE_TAPEUNITS)

The maximum number of tape units or tape drives that the restore system utility can use to restore from a system-level backup that has been dumped to tape.

Start of change A value of 0 is displayed for NOLIMIT. End of change

Install parameter MAXIMUM TAPE UNITS on installation panel DSNTIP6, or ZPARM RESTORE_TAPEUNITS in DSN6SPRM.

Field Name: QWP4RSMT

REORG PART SORT NPSI (REORG_PART_SORT_NPSI)

Specifies the default method of building a non-partitioned secondary index during the REORG tablespace part. This setting is used when the SORTNPSI keyword is not specified in a utility control statement.

Possible values are:

Auto
Disable
Enable

This field corresponds to field REORG PART SORT NPSI in installation panel DSNTIP61. The ZPARM name is REORG_PART_SORT_NPSI in DSN6SPRM.

Field Name: QWP4RPSN

REORG LIST PROCESSING (REORG_LIST_PROCESSING)

Specifies the default value for the REORG TABLESPACE PARALLEL option.

Parallel
Serial

The ZPARM name is REORG_LIST_PROCESSING in DSN6SPRM.

Field Name: QWP4RLPR

REORG MAPPING DATABASE (REORG_MAPPING_DATABASE)

The default database in which REORG TABLESPACE SHRLEVEL change implicitly creates the mapping table. This field corresponds to field RECORD MAPPING DB on installation panel DSNTIP61. The ZPARM name RECORD_MAPPING_TABLE in DSN6SPRM.

Field Name: QWP4RMDB

REORG DROP PBG PARTS (REORG_DROP_PBG_PARTS)

If YES, REORG completes, REORG drops empty, and trailing partitions are set in a PARTITION-BY-GROWTH table space.

This field corresponds to field REORG DROP PBG PARTS on INSTALLATION panel DSNTIP61. The ZPARM name is REORG_DROP_PBG_PARTS in DSN6SPRM.

Field Name: QWP4RPBG

UTILITY CACHE OPTION (SEQPRES) (DB2 10 only)

Shows whether utilities that scan a nonpartitioned index followed by an update of a subset of the pages in the index allow data to remain in 3990 cache longer when reading data.

Install parameter UTILITY CACHE OPTION on panel DSNTIPE, or ZPARM SEQPRES in DSN6PRM.

Field Name: QWP4PST

STATISTICS CLUSTERING (STATCLUS) (DB2 10 only)

Shows if the RUNSTATS utility uses enhanced or standard clustering statistics: ENHANCED is used if it is on, otherwise STANDARD is shown.

Install parameter STATISTICS CLUSTERING on panel DSNTIP6, or ZPARM STATCLUS in DSN6SPRM.

Field Name: QWP4STCL

ALTERNATE COPYPOOL (ALTERNATE_CP)

Start of change Specifies an optional alternate SMS copy pool for the DB2 BACKUP SYSTEM utility. End of change

Start of change This field corresponds to field ALTERNATE COPYPOOL on INSTALLATION panel DSNTIP62. The ZPARM name is ALTERNATE_CP in DSN6SPRM. End of change

Field Name: QWP4BSACP

DB BACKUP STG GROUP (UTIL_DBBSG)

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

Start of change This field corresponds to field DB BACKUP STG GROUP on INSTALLATION panel DSNTIP62. The ZPARM name is UTIL_DBBSG in DSN6SPRM. End of change

Field Name: QWP4UDBSG

LOG BACKUP STG GROUP (UTIL_LGBSG)

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

Start of change This field corresponds to field LOG BACKUP STG GRP on INSTALLATION panel DSNTIP62. The ZPARM name is UTIL_LGBSG in DSN6SPRM. End of change

Field Name: QWP4ULBSG

HSM MESSAGE DS HLQ (UTILS_HSM_MSGDS_HLQ)

Start of change 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) (DB2 field: QWP4UHMDH). End of change

Start of change This value corresponds to field HSM MESSAGE DS HLQ on installation panel DSNTIP62. ZPARM name: UTILS_HSM_MSGDS_HLQ in DSN6SPRM. End of change

Field Name: QWP4UHMDH

Feedback