SQL/MX 2.x Installation and Management Guide (H06.04+)

Installing NonStop SQL/MX
HP NonStop SQL/MX Installation and Management Guide—540436-001
3-21
The Phases of InstallSqlmx
•
Verifies that the system metadata tables have been created in the specified
volume.
•
Performs FCHECK on all volumes on the local node to locate and possibly correct
the labels of SQL/MP tables with added columns.
The Phases of InstallSqlmx
Table 3-2 describes the six phases of activity performed by InstallSqlmx. If
InstallSqlmx cannot successfully initialize NonStop SQL/MX, it aborts.
Table 3-2. The Phases of InstallSqlmx (page 1 of 2)
Phase Phase Activities
1 InstallSqlmx verifies that the SQL/MX objects were laid down correctly from
the SUT installation. If any required SQL/MX objects are missing from their
default locations, InstallSqlmx notifies the user about the missing objects and
aborts the installation. See Overview of Automatic File Installations
on page 3-5
for file name and default location information. Also see Locating System Schema
Tables on page 8-15.
2 InstallSqlmx creates an anchor file that contains the location of the SQL/MX
system metadata tables. The anchor file is a simple text file with ASCII tokens
that identifies the volume where system metadata will reside. The file resides in
the Guardian space $SYSTEM.ZSQLMX.MXANCHOR and is assigned a security of
“N---.”
3 InstallSqlmx issues an INITIALIZE SQL statement to initialize NonStop
SQL/MX. If NonStop SQL/MX cannot be successfully initialized, the installation is
aborted and the anchor file is removed. Whether initialization is successful or not,
InstallSqlmx creates the log /usr/tandem/sqlmx/bin/initlog. The
viewable log file initlog contains status information about the initialization of
NonStop SQL/MX.
The INITIALIZE SQL operation also creates metadata tables for the schema
MXCS_SCHEMA in the system catalog.
InstallSqlmx also implements the national character set specified with the -n
option. The national character set is associated with NCHAR and NATIONAL
CHARACTER types and with N string literals, host variables, and SQL functions
and predicates.