SQL/MP Version Management Guide

Database Versions
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
3-4
Initializing and Changing User Catalog Versions
Initializing a User Catalog Version
There are two ways to initialize the version of a user catalog:
•
Execute the CREATE CATALOG statement.
•
Run the RESTORE utility with the AUTOCREATECATALOG option set to ON.
Executing the CREATE CATALOG Command
The CREATE CATALOG statement initializes the version of the user catalog being
created. In version 300 and newer, when you create a catalog by executing CREATE
CATALOG, the initial version of the catalog matches the version of the software
running on the local node: the node where the CREATE CATALOG was issued from.
However, in versions 1 and 2, the CREATE CATALOG statement always creates a
catalog with a version number that matches the version number of the software creating
the catalog.
When you execute the CREATE CATALOG statement from version 300 or newer, if the
software running on the target node is a newer version than the software from which the
CREATE CATALOG statement is executed, the catalog created has a version number
lower than the version of the software running on the target node.
This result occurs because CREATE CATALOG cannot create catalogs of a higher
version than its own. Therefore, when you create a user catalog by executing a CREATE
CATALOG statement, the newest catalog version you can create is one that matches the
version of the software from which you issue the CREATE CATALOG command.
For example, suppose you issue a CREATE CATALOG statement to create a catalog on
a node running version 2 software. If you issue the command from a node running
version 310 software, the catalog you create is a version 2 catalog. However, if you
issue the command from a node running version 310 software, and the command creates
a catalog on a node running version 310 software, the version number of the catalog
created is 310.
Running RESTORE With AUTOCREATECATALOG ON
You can create a catalog automatically by running the RESTORE utility with the
AUTOCREATECATALOG option set to ON. In this case, the catalog that is
automatically created has the same version as the SQL/MP software on the node where
the catalog resides.
Changing User Catalog Versions
The UPGRADE CATALOG and DOWNGRADE CATALOG statements change the
versions of user catalogs as follows:
•
The UPGRADE CATALOG statement converts an existing user catalog to a newer
version so the catalog can register objects associated with the newer version of
SQL/MP software. When a catalog is upgraded, UPGRADE CATALOG records the
new catalog version in the user and system catalogs. If the structure of the catalog is
changed, UPGRADE CATALOG also records the version of the catalog format.