Changed functionality in Db2 12.1.3

Changed functionality typically involves changes in default values or an outcome different from what would have occurred in previous releases. For example, an SQL statement used in a previous release might produce different results in Db2 12.1.3.

Maintaining application compatibility across releases is a key priority. However, some behavior has to change to take advantage of new functionality in the current release.

The following tables lists changed functionality in Db2 12.1.3:

Changed Db2 utilities

Table 1. Changed Db2 utilities in Db2 12.1.3

Change	Details
VECTOR data type support for LOAD operations.	The LOAD command supports the insertion of data into VECTOR columns.
VECTOR data type support for routines that invoke the LOAD command.	Some modes of operation of the ADMIN_COPY_SCHEMA procedure, the ADMIN_MOVE_TABLE procedure and the db2move command rely on the LOAD utility internally. Those modes of operations now support tables with VECTOR columns.
MODEL_JOIN_CARD as a value for the DB2_SELECTIVITY query compiler variable.	DB2_SELECTIVITY can now be set to MODEL_JOIN_CARD, which enables or disables the use of cardinality models for join predicate selectivity estimation.