Upgrade impact from Db2 command changes
The changes in version 11.1 to Db2 command line processor (CLP) and system commands can impact your existing applications and scripts after you upgrade to version 11.1.
The changes to commands include new parameters, modifications to existing parameters, deprecated
or discontinued parameters, and modifications to command output. The following table lists the
changes that impact applications and scripts:
Command | Summary of changes with upgrade impact |
---|---|
db2cat | The output for the db2cat, db2exfmt
db2expln commands now display information for random ordering of index
keys. For more information, see Db2 command and SQL statement changes summary for details. |
db2pd | The -apinfo parameter now displays additional information
about current and past activities of the UOW. For more information, see Db2 command and SQL statement changes summary for details. |
db2look | The db2look command now generates DDL statements to create
column-organized
tables in addition to row-organized tables. For more information, see Db2 command and SQL statement changes summary for details. |
db2support | The -d parameter now supports collection of information
from multiple databases. To specify multiple databases, separate the database names with a
comma. For more information, see Db2 command and SQL statement changes summary for details. |
db2IdentifyType1 | The db2IdentifyType1 command is discontinued. For more information, see Db2 command and SQL statement changes summary for details. |
STATISTICS YES parameter of the LOAD command | The STATISTICS YES parameter of the
LOAD command is discontinued. For more information, see Db2 command and SQL statement changes summary for details. |