SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

HP NonStop SQL/MX Installation and Management Guide—640325-001
2
3. Installing NonStop SQL/MX
Software Requirements 2-2
Verifying Correct Versions of Independent Software Products 2-3
Installing the DDL Licensing Product (T0394) 2-3
Starting TMF 2-3
3. Installing NonStop SQL/MX
Summary of Installation Tasks 3-1
Preinstallation Tasks 3-2
Installing NonStop SQL/MX 3-2
Verifying the SQL/MX Installation 3-4
Overview of Automatic File Installations 3-5
Verify That Files Are Licensed 3-7
Summary of Installed SQL/MX Files 3-8
Verifying Executable File Versions 3-14
Post-Installation Tasks 3-15
Reviewing and Setting System Defaults 3-16
Starting MXCI 3-16
Installing Visual Query Planner 3-16
Installing the SQL/MX Online Help 3-17
Installing the Windows-Hosted SQL/MX C and C++ Preprocessor 3-17
Installing the Windows-Hosted SQL/MX COBOL Preprocessor 3-17
Relinking the SQL/MX UDR Server 3-18
Using Import Catalog Tools 3-18
Using Module Management Tools 3-18
Using the InstallSqlmx Script 3-18
The Phases of InstallSqlmx 3-19
InstallSqlmx Syntax 3-21
InstallSqlmx Options 3-21
InstallSqlmx Error Messages 3-22
4. Understanding and Planning SQL/MX Tables
Planning Object Naming 4-1
Avoid Renaming Nodes 4-2
Avoid Changing Object Names or Moving Database Objects 4-2
Understand the Schema Ownership Rule 4-2
Avoid Putting Same-Named Catalogs on Multiple Distributed Nodes 4-3
Understanding SQL/MX Table and File Structures 4-3
Types of Keys Used in SQL/MX Tables and Indexes 4-4
Primary Key 4-4
Clustering Key 4-4