SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-59
Considerations—DOWNGRADE CATALOG
with a PCV newer than version. (Delete any such objects or programs before
you execute DOWNGRADE CATALOG.)
In addition, no catalog specified can include objects with a version newer than the
version of the SQL/MP software executing the DOWNGRADE CATALOG
command.
Catalogs cannot be a system catalog. (Use DOWNGRADE SYSTEM CATALOG to
convert a system catalog.)
If SMF is installed on your node, catalogs cannot specify any catalog or system
catalog on a $*.ZYS*. subvolume.
The default is the current default catalog.
TO version
specifies the catalog format version for the downgraded 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 version of each catalog you specify with
catalogs.
You cannot downgrade a catalog to version 1, but version 2 catalogs are
compatible with version 1 software.
Considerations—DOWNGRADE CATALOG

To downgrade a catalog, you must be a generalized owner of the catalog and you
must have authority to read, write, and purge each table in the catalog. You also
must have authority to write to the CATALOGS table in the system catalog.
DOWNGRADE CATALOG requires exclusive access to the catalogs being
downgraded. Other processes cannot access the catalogs during the downgrade.
The downgrade fails if another process has one of the catalogs open when you
execute DOWNGRADE CATALOG.
If you downgrade a 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.)

DOWNGRADE CATALOG invalidates any program that refers to a catalog table in
the downgraded catalogs, but does not invalidate a program merely because the
program is registered in a downgraded catalog or because it accesses an object
(such as a user table) described in a downgraded catalog.
DOWNGRADE CATALOG does not invalidate a program registered in a
downgraded catalog merely because the program has a PFV newer than version
because such a program can execute regardless of the catalog downgrade unless