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-20
Using Import Catalog Tools
Using Import Catalog Tools
mxexportddl is the only Import Catalog tool available for SQL/MX Release 2.x. Its
primary purpose is to provide a file describing the SQL/MX compilation environment for
a table or a single schema. This file is used by service providers to evaluate reported
problems with the SQL/MX compiler. It can also be used to capture the DDL for tables,
stored procedures, and SQL/MP aliases into a single file that records the DDL for one
instance in time (for example, just before a major change), making mxexportddl
useful as part of a change management process.
Using Module Management Tools
For information about managing user modules, see Section 11, Managing Database
Applications and the SQL/MX Programming Manual for C and COBOL.
Using the InstallSqlmx Script
The InstallSqlmx script:
•
Verifies that all processors on the system are valid processor types for SQL/MX
Release 2.x. If InstallSqlmx detects a problem, it generates a non-SQLCODE
error message that identifies the processor or processors that do not meet
hardware requirements. For information about this and other InstallSqlmx
error messages, see the SQL/MX Messages Manual. For information about
hardware requirements for SQL/MX Release 2.x, see Hardware Requirements on
page 2-1.
•
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.
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.