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

Contents
HP NonStop SQL/MX Installation and Management Guide—523723-004
xiv
16. Enhancing SQLMX Database
Performance (continued)
16. Enhancing SQLMX Database Performance (continued)
Optimizing Index Use 16-10
Maximizing Parallel Index Maintenance 16-10
Using Co-located Indexes 16-11
Managing Cache Memory Size 16-11
Maximizing Disk Process Prefetch Capabilities 16-11
Performing FUP RELOADs to Generate More Accurate Query Plans 16-12
Checking Data Integrity 16-13
Creating Logical Views of Data 16-14
Adding and Dropping Partitions 16-14
Avoiding Automatic Recompilations 16-14
Matching Block Split Operation to Table Usage 16-15
A. Falling Back From NonStop SQL/MX Release 2.1 or Release
2.0
Fallback Considerations A-2
Falling Back From Release 2.1 to Release 2.0 A-3
Preparing to Fall Back From Release 2.1 or Release 2.0 to Release 1.8 A-3
NonStop ODBC/MX Server Configuration Issues A-4
NonStop ODBC/MX Driver Configuration Issues A-4
Falling Back From Release 2.1 or Release 2.0 to Release 1.8 A-4
Drop Release 2.1 or Release 2.0 Objects A-4
Load a Previous RVU A-6
Drop Remaining Release 2.1 or Release 2.0 Objects A-6
Install Compatible Versions of Independent Products A-7
Start TMF A-7
Fall Back SQL/MX Applications and Their User Modules From Release 2.1 or
Release 2.0 A-7
Initialize Release 1.8 (Optional) A-7
Recompile Release 1.8 Applications A-8
Falling Back to Non-SQL/MX Environments A-8
Falling Back to NonStop SQL/MP A-8
Falling Back to Enscribe A-9
Additional Sources of Information for Planning and Performing a Fallback A-9
B. Using Guardian Names With TMF, RDF, and Measure
Using the MXGNAMES Utility B-1
MXGNAMES Input Files B-2
MXGNAMES Output Files B-2
MXGNAMES Examples B-4