Pathmaker Programming Guide

Installing an Application in the Production System
Finishing and Installing the Application
7–14 067868 Tandem Computers Incorporated
3. Create a catalog on the production system and create the database tables:
34> SQLCI
>> CREATE CATALOG prnl;
--- SQL operation complete.
>> OBEY sqlddl;
>> EXIT
4. Use the ALTER DEFINE command from the command interpreter to set the
default SQL catalog to the production SQL catalog:
35> SET DEFMODE ON
36> ALTER DEFINE =_DEFAULTS, CATALOG product-sql-catalog
5. Edit SQLCODE so that the physical file names refer to locations on the production
subvolume.
6. Use SQLCODE to SQL compile the application’s server object files:
37> OBEY SQLCODE
7. Edit the PATHCNFG, PATHPRGS, PATHSVRS, PATHTCPS, and PATHUSER
files as needed for your production environment.
Note These files are provided as an example. Other modifications might be appropriate for your system. See
the Pathway System Management Guide for more information about configuring Pathway systems.
The following is an example of an edited PATHCNFG file that changes all
references from testing system locations to production system locations:
[ Application PATHWAY configuration for the SESSION-3
[ project
[ Generated by D20 PATHMAKER - May 20, 1993 at 15:52:45 ]
CMDVOL $data.sales <-- Change to production
location of data files.
OBEYVOL $data.sales <-- Change to production
location of command files.
SET PATHMON BACKUPCPU 1
SET PATHWAY MAXASSIGNS 10
SET PATHWAY MAXDEFINES 7
SET PATHWAY MAXLINKMONS 16
SET PATHWAY MAXPARAMS 5
SET PATHWAY MAXPATHCOMS 3
SET PATHWAY MAXPROGRAMS 3
SET PATHWAY MAXSERVERCLASSES 7
SET PATHWAY MAXSERVERPROCESSES 90
SET PATHWAY MAXSTARTUPS 5
SET PATHWAY MAXTCPS 2
SET PATHWAY MAXTERMS 60
START PATHWAY COLD !