SQL/MP Version Management Guide

Database Versions
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
3-5
Where Catalog Versions Are Stored
•
The DOWNGRADE CATALOG statement converts an existing user catalog to an
older version so the catalog can be accessed by an older version of SQL/MP
software. When a catalog is downgraded, DOWNGRADE CATALOG records the
change in the user and system catalogs. You cannot use DOWNGRADE CATALOG
to downgrade a catalog to version 1.
See Section 6, Mixed Version Networks
, for information about managing catalogs in a
network that supports more than one version of SQL/MP software.
Initializing or Changing System Catalog Versions
These statements initialize or change the version of a system catalog:
•
The CREATE SYSTEM CATALOG statement creates a system catalog as part of
the installation process when you install SQL/MP on a node.
•
The UPGRADE SYSTEM CATALOG statement converts an existing system
catalog to a newer version to support a new version of SQL/MP. When a system
catalog is upgraded, UPGRADE SYSTEM CATALOG records the change in the
system catalog.
•
The DOWNGRADE SYSTEM CATALOG statement converts an existing system
catalog to an older version so the system catalog can be accessed by an older version
of the software. When a system catalog is downgraded, DOWNGRADE SYSTEM
CATALOG records the change in the system catalog. You cannot use
DOWNGRADE SYSTEM CATALOG to downgrade a system catalog to version 1.
When you upgrade or downgrade a catalog, the time of the change is recorded in the
VERSIONUPGRADETIME column of the VERSIONS and CATALOGS tables. You
cannot downgrade a catalog by using version 2 SQL software. Therefore, version 2
software records only the catalog upgrade time.
For the syntax and rules governing the CREATE, UPGRADE, and DOWNGRADE
statements, see the NonStop SQL/MP Reference Manual. For the syntax and rules
governing the RESTORE utility, see the Guardian Disk and Tape Utilities Reference
Manual.
Where Catalog Versions Are Stored
Version information for all SQL user catalogs on a node is recorded in the VERSIONS
table of each user catalog and in the CATALOGS table of the system catalog. The
version information in the VERSIONS table of a user catalog is consistent with the
version information in the CATALOGS table of the system catalog.
VERSIONS Table in User Catalogs
A version 1 or version 2 VERSIONS table contains catalog version information in only
the VERSION column. A version 300 or newer VERSIONS table contains catalog
version information in three columns: VERSION, CATALOGVERSION, and
Note. The UPGRADE CATALOG statement is no longer used to upgrade the system catalog;
use UPGRADE SYSTEM CATALOG instead.