SQL/MP Installation and Management Guide

Contents

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

12. Managing a Distributed Database

Managing a Locally Distributed Database 12-1

Using DEFINEs for Logical Name Mapping 12-1

Maintaining Local Autonomy 12-2

Managing a Network-Distributed Database 12-2

Naming Nodes 12-3

Using DEFINEs for Network Object Names 12-3

Using Catalogs in a Network 12-4

Managing Network Security 12-4

Maintaining Local Autonomy in a Network 12-5

Creating a Distributed Database 12-7

Altering Distributed Objects 12-8

Dropping Distributed Objects 12-9

Enhancing Performance for a Distributed Database 12-9

Using Local Partitions and Indexes 12-9

Supporting Replicated Data Through Indexes 12-10

Using Remote Servers 12-11

Managing Processor Usage in a Distributed Environment 12-11

Design Examples 12-12

SQL Compilation and the CPU Usage DEFINE 12-13

Using the Processor Usage DEFINE 12-13

Changing Network Environments 12-15

Managing Mixed Versions of SQL/MP 12-17

13. Measuring Performance

SQL/MP Tools for Gathering Statistics 13-1

FILEINFO Utility 13-2

SET SESSION STATISTICS and DISPLAY STATISTICS Commands 13-3

SQL Statistics Area (SQLSA) 13-4

Measure Performance Measurement Tool 13-5

Statistics and Reports for SQL/MP 13-6

SQL/MP Measurement Models 13-8

14. Enhancing Performance

Understanding the Implications of Concurrency 14-1

Minimizing Contention 14-2

Avoiding Contention Between DDL Operations 14-5

Other Operational Considerations 14-5

Keeping Statistics Current 14-7