ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-5
Features Affecting Installation
Features Affecting Installation
Release 2 of the NonStop ODBC Server lets you install the NonStop ODBC system
catalog in a location other than the subvolume of the SQL/MP system catalog. This
feature allows multiple, concurrent, independent installations of the NonStop ODBC
system on a single NonStop system.
This feature is controlled using a DEFINE to indicate the location of the NonStop
ODBC Server system catalog. You set this DEFINE in your TACL session before
starting a primary configuration.
This feature allows NonStop ODBC software to support the ODBC style definition of
DATASOURCE independent of the SQL/MP data structure optimized for OLTP. The
distinguishing attribute of the ODBC DATASOURCE model is that the list of objects
made available to a client connecting to a named datasource is chosen to reflect the
application the user is performing. The software lists only those objects needed by the
application.
In an environment where both decision support and OLTP applications run
concurrently, optimization of user and application access competes with optimization of
data store operations for insert and update. By allowing DATASOURCEs to be defined
as either coincident with the underlying data, as in the NonStop ODBC Release 1
product, or as a selective projection across all data groupings, as introduced in
NonStop ODBC Release 2, the NonStop ODBC Product supports the widest possible
range of access connectivity. This feature is provided without requiring change or
replication to the underlying SQL/MP data.
Installation Versus Migration
Installation means bringing up a version of the NonStop ODBC Server on a system
from the beginning (as with a brand new system) or in a location different from any
other existing installation of the software. Migration means bringing up a version of the
NonStop ODBC Server when a different version of the NonStop ODBC Server has
been previously installed and the new version is to be installed into the same software
and system catalog locations as the previous version.
If you remove your old version entirely, then you can do a new installation. If you are
an existing customer, however, you will probably perform a concurrent installation.
Then, after completing your own certification, you can remove the NonStop ODBC
Release 1 software and associated metadata. This ensures availability by allowing the
existing installation to persist during the installation of NonStop ODBC Release 2.
Configuration data for usernames, alias names, profiles, and trace definitions can be
extracted from NonStop ODBC Release 1 catalogs and used to populate the NonStop
ODBC Release 2 configuration data, whether performing concurrent installation or an
upgrade migration. For more information, see the description for the utility NOSU200 in
Step 8—Run NOSINST on page 2-18.
The following considerations apply to migration: