SQL/MP Installation and Management Guide

Installing SQL/MP
HP NonStop SQL/MP Installation and Management Guide—523353-004
2-2
SQL/MP Software Components
rename the appropriate LIBOBJnn library object file to LIBOBJ before using
SYSGEN to generate the node. SYSGEN accepts only one LIBOBJ file.
•
For a list of supported character sets, see Defining Columns on page 5-19.
Recommendations for a node running SQL/MP are:
•
Mirrored volumes are recommended, but not required, for volumes containing SQL
objects.
•
A minimum of 16 megabytes of memory is suggested for each processor in a node
running SQL/MP. Additional memory can improve performance.
SQL/MP Software Components
The SQL/MP relational database management system consists of:
•
BACKUP and RESTORE utilities
•
Disk process
•
FastSort software
•
SQL catalog manager (SQLCAT)
•
SQL compiler (SQLCOMP)
•
SQL compiler interface
•
SQL conversational interface (SQLCI)
•
SQL executor
•
SQL file system
•
SQL utilities (SQLUTIL)
•
Collation compiler
•
Audit server (AUDSERV)
Installing SQL/MP
You should follow any instructions given in the associated software release document
and any installation instructions that come with your site update tape (SUT). Install the
software from the SUT by using the INSTALL program provided with the tape. The
INSTALL program handles the installation of the SQL/MP system software on your
$SYSTEM disk or alternate boot disk.
Starting the Transaction Management Facility (TMF)
Typically, you develop TMF startup and configuration files as OBEY command files.
These files contain the TMF configuration options and parameters that describe the