SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

HP NonStop SQL/MX Installation and Management Guide—640325-001
11
13. Managing an SQL/MX Distributed Database
Recovering Range Partitions 12-7
Recovering SPJs 12-8
Recovering Tables 12-8
Recovering Views and Indexes 12-22
Restoring Objects With BRCOM RESTORE 12-22
Restoring Catalogs 12-23
Restoring Schemas 12-23
Restoring Tables and Partitions 12-23
Restoring Indices and Index Partitions 12-24
Using SHOWDDL 12-24
Repairing Damaged SQL/MX Metadata and Objects 12-25
Strategies for Repairing Damaged Metadata and Objects 12-25
Identifying Problem Data and Objects 12-27
Using FIXUP to Correct Problem Data and Objects 12-32
Examples of Using FIXUP 12-35
Using GOAWAY to Delete Damaged Objects 12-37
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-40
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 3.0 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