SQL/MP Version Management Guide

Database Versions
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
3-12
Where Object Versions Are Stored
Where Object Versions Are Stored
The object versions of SQL tables, indexes, views, and collations are stored in catalog
tables and in file labels. The version of a constraint is not stored in catalog tables or
stored in a file label.
Object Versions in Catalog Tables
The object versions of tables, views, and collations are recorded in the
OBJECTVERSION column of the TABLES table, and the object versions of indexes are
stored in the OBJECTVERSION column of the INDEXES table.
This table summarizes the user catalog columns in which object versions are recorded in
Version 300 or newer catalog tables.
If you downgrade a catalog from version 300 or newer to version 2, SQL changes any
object versions stored in the version 300 or newer OBJECTVERSION columns to zero
in the file labels for the objects, indicating that the object version is unknown. This
approach ensures compatibility with version 2 catalogs.
Object Versions in File Labels
Versions of SQL tables, indexes, views, and collations are stored in their file labels. The
version information stored in file labels is consistent with the version information stored
Figure 3-3. Object and Catalog Versions for Testing New Software
Note. The version of the collation source file from which a collation is compiled is stored in the
CPRULESVERSION column of the CPRULES table.
Catalog Table Columns
Object Version
TABLES.OBJECTVERSION Table version
View version
Collection version
INDEXES.OBJECTVERSION
Index version
Version 2 Catalog
(Production)
Version 315 Catalog
(Testing)
Node Running
Version 315 NonStop(TM) SQL
VST007.vsd
V1 Objects
V2 Objects
V300 Objects
V310 Objects
V1 Objects
V2 Objects