NonStop NS-Series Database Migration Guide

Contents
HP Integrity NonStop NS-Series Database Migration Guide—540469-001
iii
3. Migrating an Enscribe Database (continued)
3. Migrating an Enscribe Database (continued)
Moving Enscribe Files to the New System 3-4
Steps for Moving an Enscribe Database Using RDF 3-4
Steps for Moving an Enscribe Database Using the BACKUP/RESTORE
Utilities 3-6
Steps for Moving an Enscribe Database Using SQLCI DUP 3-6
Steps for Moving an Enscribe Database Using FUP DUP 3-7
4. Migrating SQL/MP, SQL/MX, and Enscribe Applications
ODBC Applications 4-1
Enscribe Applications 4-2
TNS/R Native Object Files of Enscribe Applications 4-2
TNS Object Files of Enscribe Applications 4-3
Preparing TNS and TNS/R Object Files of Enscribe Applications To Access
SQL/MP Tables 4-3
TAL and pTAL Programs That Use Embedded SQL/MP 4-5
TAL Programs That Contain Embedded SQL/MP Statements 4-6
pTAL Programs That Call Embedded SQL/MP Routines 4-6
Object Name References and Resolution 4-6
SQL Compilation 4-7
Embedded SQL/MP and SQL/MX Programs in C, C++, and COBOL 4-7
TNS/R Native Object Files of Embedded SQL Programs 4-7
TNS Object Files of Embedded SQL Programs 4-8
Object Name References and Resolution 4-8
SQL Compilation 4-9
Java Applications That Use JDBC/MX or JDBC/MP 4-9
Object Name References 4-10
Java Native Interface (JNI) Changes 4-10
Default Heap and Stack Sizes 4-11
CLASSPATH and _RLD_LIB_PATH Environment Variables 4-11
SQLJ Applications 4-11
Stored Procedures in Java (SPJs) 4-11
5. Post-Migration Activities
Ensuring Object Name Resolution 5-1
Updating Table Statistics 5-1
Evaluating SQL Plans on the New System 5-2
Monitoring Performance on the New System 5-2