SQL/MP Installation and Management Guide

Contents

HP NonStop SQL/MP Installation and Management Guide—523353-004

2. Installing SQL/MP (continued)

Starting the Transaction Management Facility (TMF) 2-2

Initializing SQL/MP 2-4

Setting Up Event Logging 2-9

Setting Up Alternate SQL Components 2-9

Additional Installation Considerations 2-10

Reinstalling SQL/MP Software 2-10

Migrating to a Newer Software Version 2-10

C-Series to D-Series Migration Considerations 2-12

Mixed-Version Network Considerations 2-13

Upgrading Catalogs 2-14

Reverting to an Older Software Version 2-15

Dropping Newer-Version Objects 2-15

Downgrading Catalogs 2-16

Recompiling Programs 2-17

Reverting to SQL/MP Version 2 2-17

Reverting to an Older Version of TMF 2-18

3. Understanding and Planning Database Tables

Understanding SQL File Structures 3-1

Primary Keys 3-2

Key-Sequenced File Structure 3-6

Entry-Sequenced File Structure 3-9

Relative File Structure 3-10

Determining a Database Layout 3-13

Using Base Tables 3-13

Using Views 3-13

Determining When to Use Indexes 3-16

4. Planning Database Security and Recovery

Security Guidelines 4-2

Sample Authorization Schemes 4-2

Guidelines for Security Schemes 4-4

Authorization Requirements for Database Operations 4-5

Safeguard Security Product 4-8

The TMF Subsystem 4-10

TMF Concepts 4-10

Levels of Database Recovery 4-11

SQL Requirements for TMF 4-12