DB2 10.5 for Linux, UNIX, and Windows

Upgrade impact from DB2 command changes

The changes in Version 10.5 to DB2® command line processor (CLP) and system commands can impact your existing applications and scripts after you upgrade to Version 10.5.

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:

Table 1. Changes to DB2 CLP and system commands
Command	Summary of changes with upgrade impact
db2cat db2exfmt db2expln	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.
LOAD	For column-organized tables, automatic statistics collection occurs by default during the LOAD REPLACE command. To explicitly disable automatic statistics collection, specify the STATISTICS NO parameter. 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.