ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-21
Installation Steps
3. Run NOSINST.
a. For Installation Option, specify UPGRADE (U) to perform the compile, install
and load steps.
b. Change the location of the SQL/MP system catalog if other than
$SYSTEM.SQL.
c. Change the location of the NonStop ODBC system catalog to the SQL/MP
system catalog.
d. Load the default Administrator Configuration.
4. Install the configuration from NonStop ODBC Release 1 by running NOSCOM with
the file / files generated from the previous step.
RUN NOSCOM /in addcmd/
5. Install client software. If you will use the Release 2 NonStop ODBC Windows driver
with a Release 1 system, create view ZNUDT in the Release 1 system catalog:
CREATE VIEW $SYSTEM.SQL.ZNUDT AS SELECT * FROM
$SYSTEM.SQL.ZNUDT
6. If you will use the Release 1 NonStop ODBC driver with a Release 1 system,
create view ZNSDT in the Release 2 system catalog:
CREATE VIEW $R2.SQL.ZNSDT AS SELECT * FROM $R2.SQL.ZNUDT
Verification of Installation
NOSINST prints messages reporting its progress as it executes its various steps. If it
encounters an error, it prints an error message and terminates. NOSINST will also
advise you if it finishes without errors.
You can use the TACL command FILEINFO file-name to see the timestamp of a file
and whether it is licensed. You can use the FUP command INFO file-name, DETAIL
to see if a file has been SQL-compiled, if it is a SQL/MP table and, if it is, in what
SQL/MP catalog it is registered.
If NOSINST does not report errors, make the following checks on the indicated
subvolumes.
•
Check that the following files now exist on NOS-Target-Disk.ZNOS:
NOSCOM A type 100 file
NOSUTIL A type 100 file, SQL-compiled, and registered in the SQL/MP
system catalog
NOS A type 100 file, SQL-compiled, registered in the SQL/MP system
catalog
SCSOBJ A type 100 file