ODBC Server Installation and Management Manual
Installing the NonStop ODBC Server
HP NonStop ODBC Server Installation and Management Manual—429395-002
2-13
Backing Up SQL/MP Data
Verify that the following conditions are met on each UNIX workstation to be used for a
client application:
•
Check application and DBLIB requirements for memory and disk space. (The
NonStop ODBC Server does not supply any software for UNIX systems).
•
Make sure you have version 4.2 or later (up to 4.9.x) of DBLIB.
•
Make sure you have a file transfer capability, such as IXF or FTP, between the
NonStop system and the PC.
•
Verify LAN connectivity between the NonStop system and the UNIX workstation.
This can be done in a variety of ways:
°
Verify that file transfer works (this also verifies the previous step).
°
Use Ping to test physical IP connectivity.
°
Start a TELNET session.
Backing Up SQL/MP Data
When to Back Up
IAn initial installation of the NonStop ODBC Server can be undone, if necessary, with
the Deinstall tool. Catalogs, tables, views, and indexes that were created during the
install are dropped during the deinstall. In this case, backups of SQL/MP data are
optional.
However, if you select the UPGRADE installation option to upgrade an existing version
of the NonStop ODBC Server, the existing catalogs are changed. These changes
cannot be undone by Deinstall. Therefore, you should back up the old system catalog
before upgrading to the new software. See “Backing Up an Old NonStop ODBC Server
System”.
Backing up an Old NonStop ODBC Server System
The procedure for backing up an older system is as follows:
1. Shut down the old NonStop ODBC Server system by stopping all associated
processes. This step is recommended for prevention of locks and their delays, but
is not mandatory.
2. Use the BACKUP utility to back up the old NonStop ODBC Server catalog tables
and views in the system catalog. (This step backs up their indexes too.) Their
names all begin with the uppercase letter Z, so you can use a command such as
this example:
BACKUP $TAPE, (*.*.ZN*,*.*.ZV*) FROM CATALOG $SYSTEM.SQL