SQL/MX 3.2.1 Installation and Upgrade Guide (H06.26+, J06.15+)

in the appropriate case as the OSS environment is case-sensitive. You must be logged on as
SUPER.SUPER user to execute the InstallSqlmx script.
CAUTION: InstallSqlmx creates the anchor file and assigns it a security of NCNC. Do
not attempt to change this setting. If you change the security setting, and the anchor file is
modified, SQL/MX ceases to operate on the system.
8. Check if this is the first installation of SQL/MX on your system. For example, check if SQL/MX
anchor file exists in /G/system/zsqlmx/mxanchor. Running InstallSqlmx more than
once with different values of the -l parameter results in a corrupt SQL/MX environment. If
no anchor file exists, run the InstallSqlmx script by entering:
InstallSqlmx -l \$volume
[ -n national_charset_name ]
[ -charset charset_name ]
[ -nofcheck ]
[ -initmxcs ]
[ -b ]
You must always enter the -l option first. The other options are optional and can be entered
in any order. In this next example, the volume $dat215 is specified as the location to which
InstallSqlmx installs the SQL/MX system metadata tables.
InstallSqlmx -l \$dat215
CAUTION: The volume you specify in the InstallSqlmx command-line identifies the system
catalog location for the system metadata tables. The specified volume must be audited. This
should not go on the $SYSTEM disk volume. If you replace any disk containing the metadata
information, you lose the system metadata information.
9. To develop and execute Java programs that perform SQL operations or SPJs, install NonStop
Server for Java and JDBC/MX on your NonStop system. For details about installing these
products, see the NSJ 7.0 Programmer's Manual and JDBC Type 2 Programmer's Reference
or JDBC Type 4 Programmer's Reference.
NOTE: Installation of NSJ7 does not automatically create the softlink /usr/tandem/java.
If you have migrated all applications to NSJ7, then HP recommends you to create a softlink
manually to point to the NSJ7 JDK/JRE installation (/usr/tandem/nssjava/jdk170_h70).
Create the softlink /usr/tandem/java to point to the NSJ7 home directory as follows:
$ ln -s /usr/tandem/nssjava/jdk170_h70 /usr/tandem/java
After creating this softlink, applications may fail if they are not migrated to NSJ7.
10. You are now ready to start using SQL/MX.
Verifying the SQL/MX installation
After you have installed SQL/MX, perform the following verification tasks:
SeeFor more information about
“Automatic file installations” (page 19)The SQL/MX files that are automatically installed
during SUT installation
“Verifying the files licenses” (page 21)The files that need to be licensed and how to verify
that they have been properly licensed
18 Installing SQL/MX