SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Installing NonStop SQL/MX
HP NonStop SQL/MX Installation and Management Guide—544536-007
3-19
The Phases of InstallSqlmx
•
Verifies that SQL/MX objects have been laid down correctly from the SUT
installation.
•
Creates an anchor file that specifies the volume location of system metadata
tables.
•
After creating the anchor file, InstallSqlmx assigns a security of “N---” to the
anchor file.
•
Initializes NonStop SQL/MX after successfully creating the anchor file.
•
Implements the national character set specified with the -n option.
•
Initializes the NonStop SQL/MX Connectivity Service (MXCS) after successfully
initializing NonStop SQL/MX.
•
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.
Caution. The person who runs InstallSqlmx must have super ID (SUPER.SUPER)
privileges on the affected node. InstallSqlmx does not support user aliases of SUPER.SUPER.
Caution. After InstallSqlmx assigns a security of “N---” to the anchor file, do not change
this setting. If you attempt to change this setting and the anchor file is modified, SQL/MX will
cease to operate on the system.