SQL/MP Version Management Guide

Mixed Version Networks
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
6-11
Version 300 or Newer Utilities and Newer Version
Software
Version 300 or Newer Utilities and Newer Version Software
You can use the version 300 or newer SQL utilities and the BACKUP and RESTORE
utilities to perform an operation on an object or a program residing on a node running
SQL/MP software newer than version 300. However, the object or program and the
catalogs in which it is registered must not have a version newer than 300.
For example, you can use a version 300 COPY utility to access a version 300 source or
target table registered in a version 300 catalog on a node whose SQL software version is
newer than 300.
Version errors occur only when you attempt to access objects, programs, or catalogs on
remote nodes whose versions are newer than 300. You have the least chance of version
errors if you run the utilities from the node with the newest version of SQL/MP
software.
SQL Utilities and Newer Version Software
Every SQL utility can operate in a network with nodes whose SQL version is newer than
the version of the utility. Version 300 SQL utilities cannot access SQL objects or
programs whose version is newer than 300 or SQL objects or programs registered in
catalogs whose version is newer than 300.
All SQL utilities except FILEINFO check for these situations which can result in
version errors (FILEINFO checks for only the first error in the next list):
•
A version 300 SQL utility cannot access an SQL object whose version is newer than
300. For example, you cannot use version 300 PURGE to purge data from a table
whose version is newer than 300.
•
A version 300 SQL utility cannot access an SQL object or program registered in a
catalog whose version is newer than 300. For example, you cannot use the version
300 COPY utility to copy a version 300 source table registered in a newer version
catalog. Also, you cannot use version 300 PURGE to delete an SQL program whose
catalog format is 300 but that is registered in a newer version catalog (the situation
illustrated in Figure 6-3
).
•
A version 300 SQL utility cannot access an SQL program whose catalog version is
newer than 300. For example, a version 300 DUP command cannot duplicate an
SQL program whose catalog version is newer than version 300.
For more information about the SQL utilities, see the NonStop SQL/MP Reference
Manual.
BACKUP/RESTORE and Newer Version Software
When you use the BACKUP or RESTORE utility, the version of the utility must be the
same as or newer than any SQL object, catalog, or program you want to back up and
restore.
These restrictions affect the use of version 300 or newer BACKUP and RESTORE in a
network with nodes using newer version SQL/MP software: