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

Contents

HP NonStop SQL/MX Installation and Management Guide—544536-007

xii

12. Performing Recovery Operations (continued)

Using FIXUP to Correct Problem Data and Objects 12-32

Examples of Using FIXUP 12-35

Using GOAWAY to Delete Damaged Objects 12-36

Recovering From SCF Commands 12-37

ABORT DISK 12-37

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

ALTER DISK, LABEL 12-39

INITIALIZE DISK 12-39

START DISK and STOP DISK 12-39

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 for SQL/MX Release 2.x 13-12

Creating a Distributed SQL/MX Database 13-19

Creating, Registering, and Unregistering Catalog References 13-20

Distributing SQL/MX Database Objects 13-20

Altering Distributed Objects 13-22

Dropping Distributed Objects 13-23

Enhancing the Performance of a Distributed Database 13-23

Using Co-located Indexes in a Distributed Database 13-23

Using Remote Application Processes 13-23

Changing Network Environments 13-24

Managing Mixed Versions of NonStop SQL/MX 13-25

14. Measuring Performance

SQL/MX Tools for Gathering Statistics 14-1

SHOWLABEL Command 14-2

SET STATISTICS and DISPLAY STATISTICS Commands 14-3

Measure Performance Measurement Tool 14-4

Statistics and Reports for NonStop SQL/MX 14-6

SQL/MX Measurement Models 14-8