SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-62
Example—DOWNGRADE SYSTEM CATALOG
DOWNGRADE SYSTEM CATALOG does not invalidate a program registered in
the downgraded system catalog that has a PFV newer than version because
such a program can execute regardless of the catalog downgrade unless the
SQL/MP software that executes the program is replaced with an older version.
However, if the purpose of the DOWNGRADE SYSTEM CATALOG is to prepare
for installation of an older version of SQL/MP software, you will need to
re-SQL-compile programs with a newer PFV after the older software is in place. (A
runtime error occurs if you attempt to execute a program with a PFV newer than
the installed SQL/MP software.)

DOWNGRADE SYSTEM CATALOG creates a new temporary catalog on the same
volume as the catalog being downgraded. Such volumes must have enough disk
space available to store files twice as large as the original system catalog.

You cannot use DOWNGRADE SYSTEM CATALOG in a user-defined transaction.

In unusual failure situations (such as a system failure during the downgrade
operation), temporary files with names that begin with the letters “ZZDN” might be
left on the same subvolume as the catalog. You can delete these with CLEANUP.
Example—DOWNGRADE SYSTEM CATALOG
This command downgrades the local system catalog to version 2:
>> DOWNGRADE SYSTEM CATALOG TO 2;