SQL/MP Installation and Management Guide

HP NonStop SQL/MP Installation and Management Guide—523353-004
2-1
2 Installing SQL/MP
After ensuring that your node meets the hardware and software requirements for
SQL/MP, you can install the SQL/MP relational database management system
(RDBMS).
After installing SQL/MP, you can install the sample application distributed with the
SQL/MP software, as explained in the SQL/MP Reference Manual. Use this application
to demonstrate embedding SQL statements in host language programs, querying the
catalogs, and querying and updating sample database tables. The sample database
provided with this application is the same database used in examples in the SQL/MP
manuals and education courses.
This section describes system requirements for SQL/MP, installation procedures,
migration to a newer version, and the use of D-series features (for users migrating from
a C-series node).
Hardware and Software Requirements
The hardware and software requirements for an SQL/MP RDBMS are:
•
The hardware on which SQL/MP runs must be an SQL/MP system.
•
Each system that includes SQL/MP requires a node (system) name, regardless of
whether the node stands alone or is part of a network.
•
The version of the operating system must be D30 or later to support versions 315
and newer of the SQL/MP software.
•
As a general rule, TMF must be available when users are running SQL/MP
application programs or using the conversational interface, SQLCI. The TMF
subsystem is required for SQL compilation and for execution of all DDL
statements, all SQL utilities, and DML statements that require TMF transactions for
audited tables or views. TMF transactions are not required for previously compiled
SQL statements that refer to nonaudited tables or views or for SELECT statements
that use BROWSE ACCESS.
•
The product version of the TMF subsystem must be D30 or later to support
versions 315 and newer of SQL/MP software.
•
All SQL objects must reside on volumes audited by the TMF subsystem. SQL
programs need not reside on audited volumes.
•
If you plan to use a national character (NCHAR) data type from SQL/MP, the
system default multibyte character set must be a character set supported by
SQL/MP. To check the default character set, use the Guardian
MBCS_DEFAULTCHARSET_ procedure. To specify a different character set,
Note. If you are upgrading your SQL/MP environment from an older version of SQL/MP,
consider the issues discussed in the SQL/MP Version Management Guide in addition to those
discussed in this section before running your existing SQL/MP applications.