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

Contents

HP NonStop SQL/MX Installation and Management Guide—544536-007

11. Managing Database Applications (continued)

Maintaining Query Execution Plan Validity 11-13

Factors Affecting the Query Execution Plan 11-13

Recompiling a Module 11-14

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

Displaying and Analyzing Query Execution Plans 11-14

Managing Modules 11-15

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

Removing Modules 11-27

Converting Globally Placed Modules to Locally Placed Modules 11-28

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

Release 2.x 11-29

Backing Up and Restoring Programs 11-30

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