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

Contents

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

Index

Figures

Figure 4-1. Key-Sequenced B-Tree Structure 4-7

Figure 8-1. SQL/MX Metadata Table Structure 8-5

Figure 15-1. Measure Entities and Program Structures 15-5

Tables

Table 1-1. SQL/MX Metadata Schemas 1-9

Table 1-2. SQL/MX Object Types 1-10

Table 1-3. Version Identifiers for Release 2.1 and Release 2.0 1-13

Table 1-4. NonStop Tools for SQL/MX Database Management 1-18

Table 3-1. SQL/MX Releases and Their SPR Equivalents 3-3

Table 3-2. The Phases of InstallSqlmx 3-24

Table 3-3. InstallSqlmx Command Options 3-25

Table 5-1. SQL/MX Operations That Impact TMF Online Dumps 5-16

Table 5-2. Backup and Restore of SQL/MX and OSS Objects 5-28

Table 6-1. New System Defaults for Release 2.0 6-3

Table 6-2. New System Defaults for Release 2.2 6-6

Table 6-3. Alternative Settings for Selected System Defaults 6-7

Table 6-4. System Default Settings to Achieve ANSI Compliance 6-12

Table 8-1. SQL/MX Metadata Tables 8-6

Table 9-1. Adding Objects to an SQL/MX Database 9-2

Table 9-2. Authorization Requirements for Adding Database Objects 9-3

Table 9-3. Altering Objects in an SQL/MX Database 9-18

Table 9-4. Authorization Requirements for Altering Database Objects 9-19

Table 9-5.

Dropping Objects From an SQL/MX Database 9-27

Table 9-6.

Authorization Requirements for Dropping Database Objects 9-28

Table 10-1. import Command Options 10-23

Table 12-1. Label Data Associated With SQL/MX Objects 12-26

Table 12-2. Run-time metadata Stored in the Resource Fork 12-28

Table 13-1. System Schema Tables 13-8

Table 13-2. Statements and Commands for Managing Catalog References 13-11

Table 13-3. Consequences of Network Node Loss, Original Configuration 13-14

Table 13-4. Consequences of Network Node Loss, Reconfiguration 1 13-16

Table 13-5. Consequences of Network Node Loss, Reconfiguration 2 13-17

Table 13-6. Consequences of Network Node Loss, Reconfiguration 3 13-18

Table 14-1. Source and Destination Metadata Tables for Metadata Migration 14-5

Table A-1. Additional Sources of Information About Falling Back A-9