ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-20
Installation Steps
c. Run the migration utility, NOSU200, to extract NonStop ODBC Release 1
configuration data and transform it into a NonStop ODBC Release 2
configuration ADD script. Use the ALL option and specify the name of one of
the SCS configuration files to be used:
RUN NOSU200 EXTRACT ALL $system.sql addcmd scscfgt1 &
$d.znosr2
d. Run the SCS option for each additional SCS configuration file. The process will
append to the original file created in the first step. Check the generated
NOSCOM commands and correct as needed:
RUN NOSU200 EXTRACT SCS $system.sql addcmd scscfgt2
$dianosr2
e. Install the NonStop ODBC Release 1 configuration by running NOSCOM with
the file/files generated from Step 3:
RUN NOSCOM /in addcmd/
f. Install client software. If you will use the Release 2 NonStop ODBC Windows
driver with an existing Release 1 system, create view ZNUDT in the Release 1
system catalog:
CREATE VIEW $SYSTEM.SQL.ZNUDT AS SELECT * FROM
$SYSTEM.SQL.ZNUDT
g. If you will use an existing NonStop ODBC Release 1 driver with this newly
installed NonStop ODBC Release 2 system, create view ZNSDT in the
Release 2 system catalog:
CREATE VIEW $R2.SQL.ZNSDT AS SELECT * FROM $R2.SQL.ZNUDT
Option 8c—Run NOSINST for a Upgrade Installation
These instructions are for installing NonStop ODBC Release 2 onto a system where
NonStop ODBC Release 1 is currently installed, and you want to replace Release 1
with NonStop ODBC Release 2.
1. Run SYSCAT REFRESH against the Release 1 NonStop ODBC system catalog by
using the Release 1 NOSUTIL:
RUN NOS-Release1-subvol.NOSUTIL SYSCAT REFRESH
2. Run the migration utility, NOSU200, to extract Release 1 configuration data and
transform it into a NonStop ODBC Release 2 configuration ADD script. Use the
ALL option and specify the name of one of the SCS configuration files to be used.
Run the SCS option for each additional SCS configuration file:
RUN NOSU200 EXTRACT ALL $system.sql addcmd scscfgt1 &
$d.znosr2
Check the generated NOSCOM commands and correct as needed.
Caution. An upgrade installation overwrites any existing catalog contents.