SQL/MP Version Management Guide

Mixed Version Networks
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
6-10
SQL Utilities and Fallback Nodes
•
You attempt to use RESTORE to register new objects in older version catalogs. For
example, SQL returns a version error if you attempt to use RESTORE to restore a
version 300 collation and register it in a version 2 catalog.
•
You attempt to use RESTORE to register a program in a catalog whose version is
older than the catalog version of the program. For example, a version error occurs if
you attempt to use RESTORE to restore an SQL program whose catalog version is
300 or newer and register it in a version 2 catalog.
BACKUP/RESTORE Utilities and Fallback Nodes
When you use the BACKUP or RESTORE utility, its version must be the same as or
newer than the version of the SQL objects or catalogs it accesses and must be the same
as or newer than the catalog version of SQL programs that it accesses. However,
BACKUP and RESTORE do not consider the program format version (PFV) when
testing for version errors.
A version 300 or newer BACKUP or RESTORE utility can be used in a network
containing nodes whose SQL software has reverted to an older version. However, the
following restrictions apply:
•
BACKUP and RESTORE cannot access an object whose version is newer than the
version of the SQL software on the node where it resides or is to reside. For
example, version errors occur when:
°
You attempt to back up a version 300 shorthand view that resides on a node
running version 2 SQL software.
°
You attempt to restore a version 300 table or index to a node running version 2
SQL software.
•
BACKUP and RESTORE cannot access a catalog whose version is newer than the
version of the SQL software on the node where the catalog resides or is to reside.
For example, version errors occur when:
°
You attempt to back up a version 2 table registered in a version 310 catalog on a
node with version 2 SQL software.
°
You attempt to restore a version 2 protection view and register it in a version
310 catalog on a node running version 2 SQL software, or you attempt to use
RESTORE to restore a program with a catalog version of 310 and register it in a
version 310 catalog on a node running version 2 SQL software.
°
You attempt to restore a program that has a version 300 or newer catalog to a
node running version 2 SQL software.
To learn how the AUTOCREATECATALOG ON option of RESTORE affects catalog
versions, see Section 3, Database Versions
. To learn how to display the format version
and catalog version of an SQL program by using the RESTORE DETAIL option, see
Section 5, Program Versions
.
For the syntax of the BACKUP and RESTORE commands, see the Guardian Disk and
Tape Utilities Reference Manual; for general information on using these utilities, see the
NonStop SQL/MP Installation and Management Guide.