SQL/MP Version Management Guide

Software Versions and Releases
Compaq NonStop™ SQL/MP Version Management Guide—429833-001
2-4
Software Versions in a Network
newer version number than the version of the SQL/MP software running on the same
node.
The version of the SQL/MP software running on any one node must always be the same
as or newer than the versions of the SQL catalogs and objects running on that node. The
version must also be the same as or newer than the versions of any SQL objects or
programs registered in the catalogs. The version of an SQL executor must be the same
as or newer than an SQL program it executes, and the version of an SQL compiler must
be the same as or newer than any host object SQL program it compiles.
The version of an SQL message file does not have to be the same as the version of the
SQL/MP software that accesses the message file. Thus, you can modify message files
without modifying the SQL/MP software. However, using a message file with a version
older than the software version being used can result in version errors. Using a message
file with a version newer than the version of SQL/MP being used can result in warnings,
but not in errors.
If you execute an SQL statement or a utility command that attempts to access a newer-
version object or catalog or if you issue an SQL statement or a utility command to
compile or execute a newer-version SQL program, SQL/MP returns a version error.
For information on catalog and object versions, see Section 3, Database Versions
; for
information on SQL message file versions, see Section 4, Message File Versions; and
for information on SQL program versions, see Section 5, Program Versions.
Software Versions in a Network
All the SQL/MP software components installed on a single node must have the same
version number; however, different versions of SQL/MP software can be installed on
different nodes of a network as shown in Figure 2-2.
Because different versions of the software can be installed on different nodes, database
administrators can upgrade to new versions of the software one node at a time.
For more information about the implications of running different versions of SQL/MP
software on different nodes, see Section 6, Mixed Version Networks
.
Retrieving the Software Version
You can retrieve the version number of the SQL/MP software running on a system
either programmatically or interactively. Both these techniques are easy ways for
Figure 2-2. SQL/MP Software Versions on Different Nodes
\SYS1 \SYS2 \SYS3
VST004.vsd
NonStop SQL
Version 1
Software
NonStop SQL
Version 2
Software
NonStop SQL/MP
Version 315
Software