ODBC Server Installation and Management Manual

Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-15
Backups for Clients
2. Restore the software for the old NonStop ODBC Server, including any saved
configuration information.
3. Restore the system catalog tables and views.
4. Restore the user catalog tables and views (if you want, you can restore only a
subset of the user catalogs that were backed up).
5. If the system you are restoring supported stored procedures and you had stored
procedures installed at backup time, you must ensure that the information is
correct in the NonStop ODBC Server catalogs regarding what Pathway system and
server classes to use (see the discussion in Step 5 of the backup procedure on
page 2-14).
6. Run the old NonStop ODBC Server VALIDATE utility on the system catalog and on
the restored user catalogs. It reports discrepancies such as missing user SQL/MP
tables or user catalogs that are not customized. Inspect the report and adjust the
SQL/MP tables and SQL/MP catalogs as necessary (do not alter any of the old
NonStop ODBC Server catalog objects).
7. Run the old NonStop ODBC Server REFRESH utility on the system catalog and on
user catalogs to make necessary changes. This completes the restoration.
Backups for Clients
The NonStop ODBC Server includes a NonStop ODBC installation tool that can install
the new NonStop ODBC driver and configure it. If there is an existing NonStop ODBC
driver of an earlier version, the Install tool erases it without prompting the user. If you
want to save the old version of the NonStop ODBC driver, you should do so before
running the Install tool.
NonStop System Installation
Installation on the NonStop system involves
•
installing the software
•
configuring the NonStop ODBC Server system
•
starting the system
•
verifying the installation
Configuration is done at several places in the process. Verification of each step is very
important, as each step builds on the previous steps.
This subsection lists the steps for installing with a minimum of configuration; at points
in the procedure where additional, optional configuration can be done, notes are given
to that effect.
There are four important subvolumes with which you will be working: