SQL/MP to SQL/MX Database and Application Migration Guide

Contents
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
iv
5. Converting a SQL/MP Database to SQL/MX
Tables
Updating Table Statistics 4-59
Displaying and Analyzing Query Execution Plans 4-59
Forcing Query Execution Plans 4-59
Using Row-Value Constructors 4-60
Moving the Application From Development to Production 4-60
Ensuring Optimal Performance in Production 4-60
Steps for Moving an Application to Production 4-61
5. Converting a SQL/MP Database to SQL/MX Tables
Converting SQL/MP Tables to SQL/MX Tables 5-1
ANSI Compliance
5-2
New Functionality in NonStop SQL/MX
5-2
Enabling SQL/MX Applications to Access Specific Tables 5-2
Size of the Database Object 5-3
Reasons for Keeping SQL/MP Tables 5-3
Differences Between SQL/MP and SQL/MX Databases 5-4
System Catalogs and Metadata 5-5
User Catalogs and Schemas 5-5
Database Object Names 5-6
Distributed Database Objects 5-7
Database Object Security 5-7
Tables 5-8
Partitions 5-11
Indexes 5-11
Views 5-13
Collations
5-13
SQL/MX DDL Statements and Utilities 5-14
SQL/MX DDL Statements
5-14
SQL/MX Utilities
5-16
Steps for Converting a SQL/MP Database to SQL/MX Tables
5-20
Migrating Data From a SQL/MP Database to a SQL/MX Database 5-21
Verifying Compatible Data Types
5-21
Selecting a Data Movement Tool
5-21
Using INSERT-SELECT to Copy Data 5-22
Using DataLoader/MX to Copy Data 5-22
Using Third-Party Data Replication Tools
5-25
Updating Table Statistics
5-25
6. Falling Back to NonStop SQL/MP
Steps for Falling Back to NonStop SQL/MP 6-1