SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Contents
HP NonStop SQL/MX Installation and Management Guide—640325-001
xiii
A. Using Guardian Names with TMF, RDF, and
Measure
Performing FUP RELOADs to Generate More Accurate Query Plans 15-17
Checking Data Integrity 15-18
Creating Logical Views of Data 15-19
Adding and Dropping Partitions 15-19
Avoiding Automatic Recompilations 15-20
Matching Block Split Operation to Table Usage 15-20
A. Using Guardian Names with TMF, RDF, and Measure
Using the MXGNAMES Utility A-1
MXGNAMES Input Files A-2
MXGNAMES Output Files A-2
MXGNAMES Examples A-4
Index
Examples
Figures
Figure 4-1. Key-Sequenced B-Tree Structure 4-7
Figure 8-1. SQL/MX Metadata Table Structure 8-5
Figure 8-2. SQL/MX Metadata Tables 8-7
Figure 14-1. Measure Entities and Program Structures 14-6
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. Settings for Selected System Defaults 6-3
Table 6-2. System Default Settings to Achieve ANSI Compliance 6-8
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