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-6
Steps for Migrating MPALIAS Metadata to SQL/MX
Release 2.x
3. To determine which entries in the MPALIAS table to migrate, use the SHOW
MPALIAS command of the migrate utility and direct this information to a file:
/usr/tandem/sqlmx/bin: migrate SHOW MPALIAS >
mpalias_info.out
The command displays this result:
4. Check for and report discrepancies in the SQL/MP aliases to be migrated by using
the
PRELIMINARY_REPORT command of the migrate utility and direct this
information to a file:
/usr/tandem/sqlmx/bin: migrate PRELIMINARY_REPORT >
reprt_mpalias.out
The command displays this result:
Hewlett-Packard Nonstop (TM) SQL/MX Metadata Migration Utility 2.0
(c) Copyright 2003 Hewlett-Packard Development Company, LP.
SHOW: The following SQLMP ALIASes exist in the MP catalog...
CAT.SCH.ATABLE is mapped to \POOH.$SPJ01.SPJQA.ATABLE
CAT.SCH.ATESTTAB is mapped to \POOH.$SPJ01.SPJQA.ATESTTAB
CAT.SCH.BTESTTAB is mapped to \POOH.$SPJ01.SPJQA.BTESTTAB
CAT.SCH.CTESTTAB is mapped to \POOH.$SPJ01.SPJQA.CTESTTAB
CAT.SCH.DTESTTAB is mapped to \POOH.$SPJ01.SPJQA.DTESTTAB
.
.
.
CAT.SCH.TESTIME is mapped to \POOH.$SPJ01.SPJQA.TESTIME
----------------------------------------------------------------------
SHOW: Summary of Show Scan
SQLMP ALIAS entries: 19 entries available for migration
----------------------------------------------------------------------
Hewlett-Packard Nonstop (TM) SQL/MX Metadata Migration Utility 2.0
(c) Copyright 2003 Hewlett-Packard Development Company, LP.
PRELIMINARY_REPORT:
Checking for missing catalogs and schemas for MPALIAS Migration...
All necessary catalogs and schemas exist.
PRELIMINARY REPORT:
Checking for missing Guardian files for MPALIAS Migration...
\POOH.$MXQA01.C3CSTT01.ICX does not exist and is referenced.
\POOH.$NSSO.SQL.DATETAB does not exist and is referenced.
\POOH.$NSSO.SQL.FTAB does not exist and is referenced.
.
.
\POOH.susanErrorTesting does not exist and is referenced.
/usr/tandem/sqlmx/udr/mxlangman.jarcom.tandem.sqlmx.test does not exist
and is referenced.
-----------------------------------------------------------------------
PRELIMINARY REPORT: Summary of Preliminary Scan
Unique Catalogs and Schemas: 0 out of 142 need to be resolved.
SQLMP ALIAS Migration-Guardian Name Space Files: 470 out of 5839 files
missing
ODBC Catalog Tables are available: 0 out of 5 tables missing.
PROCS Migration-OSS Name Space Files: 443 out of 443 files missing.
-----------------------------------------------------------------------