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

Contents
HP NonStop SQL/MX Installation and Management Guide—523723-004
xiii
14. Migrating an SQL/MP Database to NonStop
SQL/MX Release 2.1 or Release 2.0 (continued)
14. Migrating an SQL/MP Database to NonStop SQL/MX Release
2.1 or Release 2.0 (continued)
Using the migrate Utility to Migrate SQL/MP Metadata From Release 1.8 14-5
System Requirements for Migrating SQL/MP Metadata 14-6
Before Migrating SQL/MP Metadata 14-6
Considerations for Falling Back From Release 2.1 or Release 2.0 14-7
Overview of Metadata Migration Using the migrate Utility 14-7
Steps for Migrating MPALIAS Metadata From Release 1.8 to Release 2.1 or
Release 2.0 14-8
Steps for Migrating DEFAULTS Metadata From Release 1.8 to Release 2.1 or
Release 2.0 14-11
Steps for Migrating ODBC Metadata From Release 1.8 to Release 2.1 or Release
2.0 14-12
Steps for Migrating SPJs From Release 1.8 to Release 2.1 or Release 2.0 14-14
Migrating an Enscribe Database to Release 2.1 or Release 2.0 Using SQL/MX
Tables 14-14
Tools for Migrating Data 14-15
Using INSERT...SELECT to Copy Data 14-15
Using DataLoader/MX to Copy Data 14-15
15. Measuring Performance
SQL/MX Tools for Gathering Statistics 15-1
SHOWLABEL Command 15-2
SET STATISTICS and DISPLAY STATISTICS Commands 15-3
Measure Performance Measurement Tool 15-4
Statistics and Reports for NonStop SQL/MX 15-6
SQL/MX Measurement Models
15-7
16. Enhancing SQLMX Database Performance
Using Queries in an SQL/MX Database 16-1
Understanding the Implications of Concurrency 16-2
Minimizing Contention 16-3
Avoiding Contention Between DDL or Utility Operations 16-5
Other Operational Considerations 16-6
Keeping Statistics Current 16-7
Impact of Optimizer and UPDATE STATISTICS Enhancements 16-7
Using SQLMXBUFFER to Improve Database Performance 16-8
SQL/MX Session Data Space and Data Cache Guidelines 16-8
Setting the SCF SQLMXBUFFER Attribute 16-9
Optimizing SQL/MX Memory Management 16-9