The automatic upgrade feature provides version identifiers for Adaptive Server, databases, and log record formats:
Configuration upgrade version ID – shows the current version of Adaptive Server; it is stored in the sysconfigures table. sp_configure displays the current version of Adaptive Server as “upgrade version.”
Upgrade version indicator – shows the current version of a database and is stored in the database and dump headers. The Adaptive Server recovery mechanism uses this value to determine whether the database should be upgraded before being made available for general use.
Log compatibility version specifier – differentiates version 10.x logs from version 11.x logs by showing the format of log records in a database, database dump, or transaction log dump. This constant is stored in the database and dump headers and is used by Adaptive Server to detect the format of log records during recovery.
