Pathmaker Programming Guide

Installing an Application in the Production System
Finishing and Installing the Application
067868 Tandem Computers Incorporated 7–13
4. Create an SQL catalog on the production system if one does not already exist.
5. Use the ALTER DEFINE =_DEFAULTS command from the command interpreter
to set the default SQL catalog to the production SQL catalog.
6. Edit SQLCODE so that the physical file names refer to locations on the production
subvolume. Use SQLCODE to SQL compile the application’s server object files.
7. Change the PATHCNFG, PATHPRGS, PATHSVRS, PATHTCPS, and PATHUSER
files to refer to the production locations.
Example of Installing a
Production Application
The following pages contain an example that illustrates the steps for moving an
application that accesses a NonStop SQL database to a production system. For the
purposes of this example, assume:
The production system location for the database, command files, and object files is
\PROD.$DATA.SALES.
The testing system location for the database, command files, and object files is
\DEV.$D20.NCS3.
You are installing a new application and must create a new SQL catalog and
database files on the production system.
You used one custom SQL server (SERVOBJ) and one standard SQL server
(SQLGS) in your application.
The steps for installing this application on a production system are:
1. Change your current volume and subvolume to the production system. Use FUP
and the DUPCODE file to copy the object files and help database files to the
production system:
23> VOLUME \prod.$data.sales
24> FUP /IN \dev.$d20.ncs3.dupcode /
2. Copy the Pathway configuration files, the SQL DDL source file, and SQLCODE to
the production system:
25> FUP DUP \dev.$d20.ncs3.pathcnfg, *
26> FUP DUP \dev.$d20.ncs3.pathprgs, *
27> FUP DUP \dev.$d20.ncs3.pathsvrs, *
28> FUP DUP \dev.$d20.ncs3.pathtcps, *
29> FUP DUP \dev.$d20.ncs3.pathuser, *
30> FUP DUP \dev.$d20.ncs3.pathcool, *
31> FUP DUP \dev.$d20.ncs3.pathcold, *
32> FUP DUP \dev.$d20.ncs3.sqlddl, *
33> FUP DUP \dev.$d20.ncs3.sqlcode, *