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

Contents

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

xii

12. Performing Recovery Operations (continued)

ABORT DISK 12-36

ALTER DISK, ALTNAME and ALTER DISK, VOLNAME 12-36

ALTER DISK, LABEL 12-37

INITIALIZE DISK 12-38

START DISK and STOP DISK 12-38

13. Managing an SQL/MX Distributed Database

Managing a Locally Distributed SQL/MX Database 13-1

Managing a Network-Distributed SQL/MX Database 13-2

SQL/MX Distributed Database Features 13-3

Naming Network Nodes 13-6

Naming SQL/MX Database Objects 13-6

Using Catalog References in an SQL/MX Distributed Database 13-8

Managing Network Security 13-11

Maintaining Local Autonomy in a Network 13-12

Creating a Distributed SQL/MX Database 13-19

Creating, Registering, and Unregistering Catalog References 13-19

Distributing the SQL/MX Database Objects 13-19

Altering Distributed Objects 13-21

Dropping Distributed Objects 13-22

Enhancing Performance for a Distributed Database 13-22

Using Local Partitions and Indexes 13-22

Supporting Replicated Data Through Indexes 13-23

Using Remote Servers 13-23

Changing Network Environments 13-23

Managing Mixed Releases of NonStop SQL/MX 13-25

14. Migrating an SQL/MP Database to NonStop SQL/MX Release

2.1 or Release 2.0

Migration Basics 14-1

Planning for Migration 14-2

Planning to Migrate Applications 14-3

Planning for Capacity and Performance 14-3

Planning for Installation 14-3

Planning for Fallback 14-4

Migrating an SQL/MP Database to Release 2.1 or Release 2.0 Using MP Tables 14-4

Migrating an SQL/MP Database to Release 2.1 or Release 2.0 Using SQL/MX

Tables 14-4