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

Contents

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

11. Managing Database Applications (continued)

Producing Locally Placed Modules or Globally Placed Modules 11-15

Securing User Modules 11-16

Checking Module Dependencies With DISPLAY USE OF 11-19

Grouping Applications and Modules to Run Multiple DISPLAY USE OF

Operations 11-21

Removing Modules 11-24

Converting Globally Placed Modules to Locally Placed Modules 11-25

Managing Module Files and Their Applications During Fallback From SQL/MX

Release 2.x 11-27

Backing Up and Restoring Programs 11-27

12. Performing Recovery Operations

Recovering Databases After Disk or Node Failures 12-1

Recovering Disk Volumes 12-2

Recovering Files 12-2

Recovering Files With the TIME Option 12-3

Recovering Files to New Locations 12-4

Recovering Metadata 12-6

Recovering Database Objects 12-7

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 Indexes 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-36

Recovering From SCF Commands 12-37

ABORT DISK 12-37

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