SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
U-13
UPGRADE SYSTEM CATALOG Command

This example converts all catalogs (except the system catalog) on the current
default node to the same version as the current SQL/MP software:
>> UPGRADE CATALOGS $*.*;
UPGRADE SYSTEM CATALOG Command
UPGRADE SYSTEM CATALOG is an SQLCI utility command that allows a user with
super ID authority to convert the system catalog on the local node to support a newer
version of NonStop SQL/MP.
TO version
specifies the catalog format version for the upgraded system catalog.
You can express version as an integer (2, 300, 310, 315, 320, 325, or 330) or as
a string (A011, A300, A310, A315, A320, A325, or A330), but the version you
specify must be greater than the current version of the catalogs you specify with
catalogs. In addition, version must not be the product version of the SQL/MP
software installed on the node.
The default is the version of the SQL/MP software installed on the node.
For more information about NonStop SQL/MP product versions, see Versions on
page V-6 or the SQL/MP Version Management Guide.
Considerations—UPGRADE SYSTEM CATALOG

Only the local super ID can execute UPDATE SYSTEM CATALOG.
UPGRADE SYSTEM CATALOG requires exclusive access to the system catalog
being upgraded. Other processes cannot access the system catalog during the
upgrade. The upgrade fails if other processes have the system catalog open when
you issue the UPGRADE SYSTEM CATALOG command. In addition, all indexes,
views, and programs registered in the system catalog must be available for read
access.

UPGRADE CATALOG invalidates any program that refers to a table in the system
catalog, but does not invalidate a program merely because it is registered in the
system catalog or because it accesses objects registered in the system catalog.
Example—UPGRADE SYSTEM CATALOG
This example upgrades the system catalog on the local system to version 315:
>> UPGRADE SYSTEM CATALOG TO 315;
UPGRADE SYSTEM CATALOG [ TO version ] ;