SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-61
DOWNGRADE SYSTEM CATALOG Command
DOWNGRADE SYSTEM CATALOG Command
DOWNGRADE SYSTEM CATALOG is an SQLCI utility command that allows a user
with super ID authority to convert a local system catalog to an older version so the
system catalog can be accessed by an older version of SQL/MP software.
version
is the catalog format version for the downgraded system catalog.
You can express version as either an integer (2, 300, 310, 315, 320, 325, or 330)
or a character string (A011, A300, A310, A315, A320, A325, or A330), but the
version you specify must be older than the current version of the system catalog.
You cannot downgrade a catalog to version 1, but version 2 catalogs are
compatible with version 1 software.
Considerations—DOWNGRADE SYSTEM CATALOG

Only the local super ID can downgrade a system catalog.
DOWNGRADE SYSTEM CATALOG requires exclusive access to the system
catalog. Other processes cannot access the system catalog during the downgrade.
The downgrade fails if another process has one of the catalog tables in the system
catalog open when you execute DOWNGRADE SYSTEM CATALOG.
The downgrade fails, If you downgrade a system catalog to version 2, file labels
must be available during the downgrade for any tables or objects registered in the
catalog that have a nonzero value for the OBJECTVERSION column of the
TABLES or INDEXES catalog table. (For backward compatibility, DOWNGRADE
CATALOG changes such file labels to specify object version 0.)

You cannot downgrade a system catalog that contains protection views, objects
with a version newer than version, or programs with a PCV newer than
version. (Drop any such objects or programs before you execute DOWNGRADE
SYSTEM CATALOG.) In addition, a system catalog cannot itself have a version
newer than the version of the SQL/MP software executing the DOWNGRADE
SYSTEM CATALOG command.
You can downgrade a system catalog that has higher-version user catalogs
registered in it. For example, you can downgrade a version 310 system catalog to
version 2, even if it has version 310 user catalogs registered in it.

DOWNGRADE SYSTEM CATALOG invalidates any program that refers to a
catalog table in the downgraded system catalog, but does not invalidate a program
merely because the program is registered in a downgraded system catalog or
accesses an object (such as a user table) described in a downgraded system
catalog.
DOWNGRADE SYSTEM CATALOG TO version ;