DB2 Version 9.7 for Linux, UNIX, and Windows

Database configuration parameters

New database configuration parameters indicate the status of several compatibility features.

The new parameters include:
  • date_compat, which indicates whether the DATE compatibility semantics associated with the TIMESTAMP(0) data type are applied to the connected database
  • number_compat, which indicates whether the compatibility semantics associated with the NUMBER data type are applied to the connected database
  • varchar2_compat, which indicates whether the compatibility semantics associated with the VARCHAR2 data type are applied to the connected database
The value of each of these parameters is determined at database creation time, and is based on the setting of the DB2_COMPATIBILITY_VECTOR registry variable. The value cannot be changed.