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

Contents

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

xiv

Tables (continued)

Table 3-1. SQL/MX Release and SPR Information for H-Series RVUs 3-3

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

Table 3-3. InstallSqlmx Command Options 3-23

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 SQL/MX Release 2.0 6-3

Table 6-2. New System Defaults for SQL/MX Release 2.1 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-26

Table 9-6. Authorization Requirements for Dropping Database Objects 9-27

Table 10-1. import Command Options 10-23

Table 11-1. SQLCODES and the Constraints That Prevent Retry Operations 11-2

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

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

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

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