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

Contents
HP NonStop SQL/MX Installation and Management Guide—544536-007
iii
4. Understanding and Planning SQL/MX
Tables (continued)
4. Understanding and Planning SQL/MX Tables (continued)
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-5
Partitioning Key 4-5
Foreign Key 4-5
The Key-Sequenced File Structure 4-5
Types of Key-Sequenced File Access 4-6
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
Planning Database Recovery 5-6
Using Guardian Physical Names for SQL/MX Objects 5-6
Database Recovery Guidelines 5-7
Recovering Dropped Database Objects 5-8
Using TMF for Transaction Recovery, Database Consistency, and Database
Recovery 5-10
TMF Concepts 5-10
Levels of Database Recovery With TMF 5-11
NonStop SQL/MX Requirements for TMF 5-12