SQL/MX 2.x Installation and Management Guide (H06.04+)

Contents

HP NonStop SQL/MX Installation and Management Guide—540436-001

xii

12. Performing Recovery Operations (continued)

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

15. Enhancing SQLMX Database Performance

Using Queries in an SQL/MX Database 15-2

Understanding the Implications of Concurrency 15-2

Minimizing Contention 15-4

Avoiding Contention Between DDL or Utility Operations 15-6

Other Operational Considerations 15-6

Keeping Statistics Current 15-7