SQL/MX 3.2 Installation and Upgrade Guide (H06.25+, J06.14+)

Table 1 The Phases of InstallSqlmx (continued)
Phase ActivitiesPhase
NOTE: If a large number of disk drives are attached to the local node, the FCHECK portion of
InstallSqlmx can take a long time to complete. To avoid this delay, run FCHECK before you run
InstallSqlmx.
InstallSqlmx syntax
InstallSqlmx [-help | -h ] | options
options are: { -l\$volume [-n national_charset_name] [-charset charset_name] [-initmxcs]
[-b] [-nofcheck]
volume is: the DP2 volume in which to install the system metadata tables
You must always specify the -l option first. You can specify other options in any order.
InstallSqlmx command options
The following table describes the command options for InstallSqlmx.
Table 2 InstallSqlmx Command Options
DescriptionOption
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 must
-b
exist at only one location on a system. If InstallSqlmx is run multiple times with multiple
-l values then multiple ZSD0s occurs. When InstallSqlmx locates ZSD0, it drops the
current anchor file, re-creates it, and adds the correct volume.
Use this option to display help information about InstallSqlmx, including command
syntax, phase descriptions, option descriptions, syntax examples, and diagnostics
information.
-help
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.
-initmxcs
Use this option to specify the volume in which InstallSqlmx installs SQL/MX system
metadata tables. It is not recommended to specify $SYSTEM.
-l volume
InstallSqlmx determines whether system metadata tables already exist. If they already
exist, an error message appears and InstallSqlmx terminates. For more information,
see the InstallSqlmx error message information in the SQL/MX Messages Manual.
You must always specify the -l option first in the InstallSqlmx script command-line.
Use this option to specify the name of the national character set for NCHAR/NCHAR
VARYING columns. The value for the -n option can be ISO88591, UCS2, KANJI, or
KSC5601.
-n
national_charset_name
If you do not specify a value for the -n option, the national character set defaults to UCS2.
Use this option to specify the default character set [ISO88591 | SJIS | UNICODE].
If you do not specify, the character set defaults to ISO88591.
-charset
charset_name
Use this option to specify that FCHECK must not be performed on local volumes to locate
SQL/MP tables with added columns. If this option is not specified, InstallSqlmx
automatically performs FCHECK.
-nofcheck
InstallSqlmx error messages
For more information about the non-SQLCODE error messages generated by InstallSqlmx,
see the SQL/MX Messages Manual.
16 Installing SQL/MX