SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Contents

HP NonStop SQL/MX Installation and Management Guide—523723-004

11. Managing Database Applications (continued)

Recompiling a Module 11-15

Migrating SQL/MX Nodes to Obtain Improved Query Plan Performance 11-15

Displaying and Analyzing Query Execution Plans 11-15

Managing Modules 11-15

Producing Locally Placed Modules or Globally Placed Modules 11-16

Securing User Modules 11-17

Checking Module Dependencies With DISPLAY USE OF 11-20

Removing Modules 11-22

Converting Globally Placed Modules to Locally Placed Modules 11-23

Managing Module Files and Their Applications During Fallback From Release 2.1

or Release 2.0 11-25

Backing Up and Restoring Programs 11-28

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-21

Restoring Objects With BRCOM RESTORE

12-21

Restoring Catalogs

12-22

Restoring Schemas 12-22

Restoring Tables and Partitions 12-22

Restoring Indexes 12-23

Using SHOWDDL 12-23

Repairing Damaged SQL/MX Metadata and Objects 12-24

Strategies for Repairing Damaged Metadata and Objects 12-24

Identifying Problem Data and Objects 12-26

Using FIXUP to Correct Problem Data and Objects 12-31

Examples of Using FIXUP 12-34

Using GOAWAY to Delete Damaged Objects 12-35

Recovering From SCF Commands 12-35