SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-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-6
Figure 8-1. SQL/MX Metadata Table Structure 8-5
Figure 8-2. SQL/MX Metadata Tables 8-7
Figure 8-3. SQL/MX Metadata Tables 8-10
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