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

Contents

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

xiv

Tables

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

Tables

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

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

Table 1-3. NonStop Tools for SQL/MX Database Management 1-14

Table 2-1. Minimum Software Products Required for Java Applications 2-3

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

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

Table 3-3. InstallSqlmx Command Options 3-21

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. New System Defaults for SQL/MX Release 2.3.3 6-6

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

Table 6-5. System Default Settings to Achieve ANSI Compliance 6-13

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 10-2. Difference Between DUP and FASTCOPY Commands 10-44

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