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-23
InstallSqlmx Error Messages
InstallSqlmx Error Messages
For information about the non-SQLCODE error messages generated by
InstallSqlmx, see the SQL/MX Messages Manual.
Table 3-3. InstallSqlmx Command Options
Option Description
-b Use this option to rebuild the anchor file if it is corrupted.
When the -b option is specified, InstallSqlmx searches
the system for the system metadata subvolume ZSD0,
which should exist at only one location on a system. When
InstallSqlmx locates ZSD0, it drops the current anchor
file, re-creates it, and adds the correct volume.
-help Use this option to display help information about
InstallSqlmx, including command syntax, phase
descriptions, option descriptions, syntax examples, and
diagnostics information.
-initmxcs Use this option to reload the MXCS metadata tables in the
MXCS_SCHEMA schema of the system catalog if the
default values were not successfully loaded during the first
run of InstallSqlmx.
-l volume Use this option to specify the volume in which
InstallSqlmx installs SQL/MX system metadata tables.
The volume, which must be audited, should not go on
$SYSTEM.
InstallSqlmx determines whether system metadata
tables already exist. If they already exist, an error message
appears and InstallSqlmx terminates. See the
InstallSqlmx error message information in the SQL/MX
Messages Manual for more information.
You must always specify the -l option first in the
InstallSqlmx script command line.
-n
national_charset_name
Use this option to specify the name of the national character
set for NCHAR/NCHAR VARYING. The value for the -n
option can be ISO88591, UCS2, KANJI, or KSC5601.
However, if you specify KANJI or KSC5601 and later
attempt to create an SQL/MX table with an NCHAR column,
you receive an error message and the operation fails
because SQL/MX tables do not support the KANJI or
KSC5601 character sets.
If you do not specify a value for the -n option, the national
character set defaults to UCS2.
-nofcheck Use this option to specify that FCHECK should not be
performed on local volumes to locate SQL/MP tables with
added columns. If this option is not specified,
InstallSqlmx automatically performs FCHECK.