SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Migrating SQL/MP Metadata From SQL/MX Release
1.8 to SQL/MX Release 2.x
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
6-3
Considerations for Falling Back From SQL/MX
Release 2.x
Considerations for Falling Back From SQL/MX
Release 2.x
You perform SQL/MP metadata migration as part of the migration from SQL/MX
Release 1.8 to SQL/MX Release 2.x. If it becomes necessary to fall back from SQL/MX
Release 2.x and reinstall SQL/MX Release 1.8, note these important considerations:
•
Check that SQL/MP metadata copied by migrate remains in its original locations
on the node. Among other things, this approach guarantees that, if you need to
reinstall SQL/MX Release 1.8, your original SQL/MP metadata is preserved intact.
•
If you modify or create new SQL/MP aliases, system defaults, MXCS (ODBC/MX)
metadata, or SPJs in the SQL/MX Release 2.x environment, there are no
automated tools for moving this new SQL/MX metadata to the SQL/MP metadata
tables. To move the new metadata, you must use manual methods like CREATE
SQLMP ALIAS, CREATE PROCEDURE, and INSERT INTO DEFAULTS
statements. For more information, see Section 8, Falling Back to SQL/MX Release
1.8.
The migrate Utility
The migrate utility is an OSS command that copies metadata from SQL/MP user
metadata tables to SQL/MX system metadata tables. Tabl e 6-1
identifies these
metadata tables.
Table 6-1. Source and Destination Metadata Tables for Metadata
Migration (page 1 of 2)
Metadata
SQL/MX
Release 1.8
Metadata
Table SQL/MX Release 2.x Metadata Table or Tables
SQL/MP
aliases
MPALIAS —> cat.DEFINITION_SCHEMA_VERSION_vernum.MP_
PARTITIONS and
cat.DEFINITION_SCHEMA_VERSION_vernum.OBJECTS
*
System
defaults
DEFAULTS —> NONSTOP_SYSTEM_NSK.SYSTEM_DEFAULTS_
SCHEMA.SYSTEM_DEFAULTS
*
The catalog name (cat) that prefixes a DEFINITION_SCHEMA table identifies the catalog in which the
DEFINITION_SCHEMA table resides. cat is the catalog name of the migrated SQL/MP alias or SPJ. An SQL/MP
alias of CAT.SCH.TI has its metadata migrated to CAT.DEFINITION_SCHEMA_VERSION_vernum.OBJECTS,
while an SQL/MP alias of CAT1.SCH.TI has its metadata migrated to
CAT1.DEFINITION_SCHEMA_VERSION_vernum.OBJECTS.
**
The node is the name of the node on which the SQL/MX system metadata table resides.
***
The vernum is the current schema version of NonStop SQL/MX. For more information, see Table 2-5 on
page 2-10.