Utility changes in Db2 11

Use this information to plan for utility changes in Db2 11.

New utilities in Db2 11

Table 1. New utilities
Utility Description
DSNJU008 The DSNJU008 utility prints the contents of the compression dictionary data set (CDDS).

Utility changes in Db2 11

The following table lists and describes these new and changed options. For information about a new option, see the information for the utility. For information about an option with a changed default value, see Utility release incompatibilities.

Table 2. New and changed utility options
Utility name Description of enhancements and notes
CHECK INDEX
New option:
PARALLEL
LOAD
Changed options:
  • Support is added for new IGNORE options: PART, CONV, VALPROC, IDERROR, DUPKEY
  • Support is added for concurrent access to target tables during LOAD utility processing, with LOAD REPLACE SHRLEVEL REFERENCE.
  • Support for a wider range of external date formats is added with DATE EXTERNAL (date-format)
  • Support for a wider range of external time formats is added with TIME EXTERNAL (time-format)
New options:
  • COLGROUP
  • DRAIN_WAIT
  • FREQVAL COUNT
  • 25
  • HISTOGRAM
  • IGNORE
  • NOCHECKPEND
  • NUMQUANTILES
  • NUMCOLS
  • PARALLEL
  • RETRY
  • RETRY_DELAY
  • SWITCHTIME
REBUILD INDEX
New options:
  • HISTOGRAM
  • NUMQUANTILES
  • NUMCOLS
  • PARALLEL
REORG INDEX
New options:
  • HISTOGRAM
  • NUMQUANTILES
  • NUMCOLS
Options with changed defaults:
  • DRAIN
REORG TABLESPACE
New options:
  • INITCDDS
  • LISTPARTS
  • MAPPINGDATABASE
  • RECLUSTER
  • COLGROUP
  • PARALLEL(num-subtasks)
  • SEARCHTIME
Options with changed defaults:
  • DRAIN
REPAIR
New options:
  • CATALOG
  • INSERTVERSIONPAGES
  • SETCURRENTVERSION
RUNSTATS
New option:
RESET ACCESSPATH
Changed option:
A default profile is used when USE PROFILE is specified and no profile exists for the target table.
TEMPLATE
New options:
TIME

The TIME option specifies whether UTC or local time is used in expansion of date and time DSN variables. The default value is controlled by the value of the TEMPLATE_TIME subsystem parameter.

UNLOAD
New option:
PARALLEL

DISPLAY UTILITY output

In Db2 11, the output from the DISPLAY UTILITY command includes the job name and the date and time when the job was submitted.

Related information:

Utility RBA and LRSN handling

Online utility output
In all migration modes, RBA and LRSN values are displayed in 10-byte format. This 10-byte display is unrelated to migration of the catalog or directory, conversion of individual objects to EXTENDED format, or BSDS conversion. For recovery purposes, this 10-byte format is the preferred input format for Db2. When 10-byte RBA or LRSN values are specified as input to Db2 conversion to 6-byte format is performed internally as needed.
Stand-alone utility output
In all migration modes, formatted RBA and LRSN values are displayed in 10-byte format. The 10-byte formatted display is unrelated to migration of the catalog or directory, conversion of individual objects to EXTENDED format, or BSDS conversion. Dump format data, which might contain RBA or LRSN values, is not consistently shown in 10-byte format. The format of the display represents the actual data at the time of the utility run, and is shown without conversion.
SELECT OUTPUT FROM SYSIBM.SYSLGRNX
A SELECT from SYSIBM.SYSLGRNX displays the LGRSRBA, LGREPBA, LGRSLRSN, and LGRELRSN columns in either 6-byte or 10-byte format. Before CATENFM of SYSLGRNX the data and the display are in 6-byte format. After CATENFM of SYSLGRNX the data and the display are in 10-byte format.
SELECT OUTPUT FROM SYSIBM.SYSCOPY
A SELECT from SYSIBM.SYSCOPY displays the START_RBA and PIT_RBA columns in either 6-byte or 10-byte format. Before CATENFM of SYSCOPY, the data and the display are in 6-byte format but in all migration modes in utility-output, SYSCOPY columns are displayed in 10-byte format. After CATENFM of SYSCOPY the data and the display are in 10-byte format with non-zero digits in low order 3 bytes. Digits in the low order 3 bytes are unrelated to the conversion of the BSDS or conversion of individual objects to EXTENDED format.

Allocation of image copy data sets

In Db2 11, the COPY utility can use real-time statistics to avoid allocating empty image copy data sets when you specify the CHANGELIMIT or FULL NO options and the appropriate criteria is not met.

If you request that REORG take inline image copies, you can specify a template name for the image copy data sets. In Db2 11, if that template name uses the &PA. or &PART. variable, REORG allocates a separate copy data set for each partition that is being reorganized.