SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Contents

HP NonStop SQL/MX Installation and Management Guide—523723-004

iii

3. Installing NonStop SQL/MX (continued)

Falling Back to Release 1.8 3-22

Using the InstallSqlmx Script 3-23

The Phases of InstallSqlmx 3-23

InstallSqlmx Syntax 3-25

InstallSqlmx Options 3-25

InstallSqlmx Error Messages 3-26

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

SYSKEY 4-4

Partitioning Key 4-5

Foreign Key 4-5

The Key-Sequenced File Structure 4-5

Types of Key-Sequenced File Access 4-5

Key-Sequenced Tree Structure 4-6

Planning Table and Index Partitioning 4-8

Range Partitioning and Hash Partitioning 4-8

When to Use Range Partitioning 4-9

When to Use Hash Partitioning 4-9

Determining a Database Layout 4-10

Using SQL/MX Tables 4-10

Using Views 4-11

Determining When to Use Indexes 4-12

5. Planning Database Security and Recovery

Planning Database Security 5-1

Planning Guidelines 5-2

Database Access and Security 5-2

OSS File and Directory Security 5-2

Safeguard Security 5-4