SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
iii
5. Planning Database Security and Recovery
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
Guidelines for Configuring TMF 5-13