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-4
Overview of Metadata Migration Using the migrate
Utility
Overview of Metadata Migration Using the
migrate Utility
Use the migrate EXECUTE command to move metadata of a specified type, such as
SQL/MP aliases, system defaults, ODBC/MX metadata, or SPJs. Use the
migrate
ALL command to move all SQL/MP metadata. For a description of migrate utility
syntax, see the
SQL/MX Reference Manual.
To migrate specific metadata from SQL/MX Release 1.8 to SQL/MX Release 2.x:
1. Set up the environment variables to specify the physical location for the SQL/MP
metadata table.
2. Use the
migrate SHOW command to display the existing entries in the specified
SQL/MP metadata table.
3. Use the
migrate PRELIMINARY_REPORT command to display any discrepancies
in the metadata files and direct this information to a file.
ODBC/MX
metadata
ZONAM2ID —> NONSTOP_SQLMX_node.MXCS_SCHEMA.NAME2ID
**
ZOAS2DS —> NONSTOP_SQLMX_node.MXCS_SCHEMA.ASSOC2DS
ZODS —> NONSTOP_SQLMX_node.MXCS_SCHEMA.DATASOURCES
ZOENV —> NONSTOP_SQLMX_node.MXCS_SCHEMA.
ENVIRONMENTVALUES
ZORES —> NONSTOP_SQLMX_node.MXCS_SCHEMA.
RESOURCEPOLICIES
Stored
procedures
in Java
PROCS —> cat.DEFINITION_SCHEMA_VERSION_vernum.OBJECTS
***
and
cat.DEFINITION_SCHEMA_VERSION_vernum.ROUTINES
and cat.DEFINITION_SCHEMA_VERSION_vernum.TEXT
PARAMS —> cat.DEFINITION_SCHEMA_VERSION_vernum.COLS
Table 6-1. Source and Destination Metadata Tables for Metadata
Migration (page 2 of 2)
Metadata
SQL/MX
Release 1.8
Metadata
Table SQL/MX Release 2.x Metadata Table or Tables
*
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.