SQL/MP Installation and Management Guide

Installing SQL/MP
HP NonStop SQL/MP Installation and Management Guide—523353-004
2-9
Setting Up Event Logging
4. If you use COBOL with SQL/MP, replace the COBOLEXT file on your
$SYSTEM.SYSTEM subvolume with the correct COBOL extension file. The
$SYSTEM.SYSTEM.COBOLEXT extension file installed by the INSTALL program
does not contain the complete COBOL extension libraries for SQL/MP, which are
stored under the name $SYSTEM.SYSTEM.COBOLEX0.
To replace the existing $SYSTEM.SYSTEM.COBOLEXT file with the appropriate
COBOL extension file, enter this command:
27> FUP DUP $SYSTEM.SYSTEM.COBOLEX0, $SYSTEM.SYSTEM.COBOLEXT,
PURGE, SOURCEDATE
If an incorrect extension file is used for programs containing SQL statements,
those programs might encounter a compilation error (UNIT OF PROPER
LANGUAGE NOT FOUND) or a run-time trap error.
Setting Up Event Logging
SQLCI provides logging capability to:
•
Log certain events to a terminal or file automatically
•
Log command strings entered interactively through SQLCI, and, optionally, output
from those commands, to an EDIT file
Both methods are effective for maintaining a record of events and commands. You
should routinely have the log file duplicated, printed, and cleared. For more information
about event logging, see the discussion of the =_SQL_CMP_EVENT DEFINE in the
SQL/MP Reference Manual.
Setting Up Alternate SQL Components
Users with the super group ID can specify alternate SQL components through the
=_SQL_component DEFINEs. These DEFINEs redirect the RDBMS to use the
specified programs or message files instead of the default programs or files residing on
$SYSTEM.SYSTEM. The use of these components is limited to members of the super
group only.
If you want an SQL/MP system available only for the super group, issue the
=_SQL_component DEFINEs before performing the initialization or reinstallation
steps. You might do this, for instance, when you want to allow a limited group of users
to access a customized SQL/MP system or to run SQL components not residing on
$SYSTEM.SYSTEM. For more information on the =_SQL_component DEFINEs, see
the SQL/MP Reference Manual.