Utility changes in Db2 11
Use this information to plan for utility changes in Db2 11.
New utilities in Db2 11
| 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.
| Utility name | Description of enhancements and notes |
|---|---|
| CHECK INDEX |
|
| LOAD |
|
| REBUILD INDEX |
|
| REORG INDEX |
|
| REORG TABLESPACE |
|
| REPAIR |
|
| RUNSTATS |
|
| TEMPLATE |
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 |
|
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.
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.