SQL/MP Installation and Management Guide

Contents

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

8. Reorganizing Tables and Maintaining

Data (continued)

8. Reorganizing Tables and Maintaining Data (continued)

Balancing Partition Sizes 8-5

Changing Extent Size Values 8-6

Adding Empty Partitions 8-7

Loading, Copying, Appending, and Purging Data 8-7

Guidelines for Loading Tables 8-8

Loading Individual Partitions 8-9

Examples of Loading Tables 8-10

Guidelines for Copying Tables 8-13

Examples of Copying Tables and Files 8-14

Appending Data to Tables or Partitions 8-15

Purging Data From SQL Tables 8-18

9. Moving a Database

Reasons for Moving a Database 9-1

Determining Move Dependencies 9-2

Choosing Utilities for the Move Operation 9-2

COPY and LOAD 9-3

DUP and BACKUP/RESTORE 9-4

Moving the System Catalog 9-9

Moving Database Objects 9-14

Dropping and Re-creating Catalogs 9-15

Moving Catalogs 9-15

Moving Tables 9-16

Moving Views 9-21

Moving Indexes 9-22

Moving Collations 9-23

Moving Partitions 9-23

Moving a Database to a Different Node or Different Volumes 9-24

Choosing a Method 9-24

Steps for Moving a Database 9-25

Example of Moving a Database 9-25

Catalog Mapping Schemes for DUP 9-30

Renaming or Renumbering a Node 9-32

Backing Up and Purging SQL Objects 9-33

Renaming or Renumbering Your System 9-37

Reinstalling SQL/MP on a Node 9-37

Restoring a SQL/MP Database on a Node 9-37