SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-45
Examples of migrate
System Requirements
•
TMF must be available and running on the system.
•
SQL/MP must be installed and available on the system.
•
SQL/MX Release 2.x must be installed and available on the system.
Location of the migrate Utility
Run the migrate utility from the /usr/tandem/sqlmx/bin directory.
Recommendations
•
Run migrate after installing SQL/MX Release 2.x and after creating the
necessary catalogs and schemas.
•
To ensure successful migration, run the PRELIMINARY_REPORT command to
identify problems that need to be fixed before migration.
•
Run migrate before running NonStop SQL/MX applications from an earlier
release that uses MPALIAS, DEFAULTS, MXCS (ODBC), and/or PROCS
metadata. If you do not migrate this metadata to SQL/MX Release 2.x, the
applications do not work.
Examples of migrate
•
Using the defaults of the migrate utility, this command executes migration without
checking for discrepancies. Entries that cannot be migrated are logged in an
ERROR_LOG file, along with the reasons for failure. You can then correct the
problems indicated in the ERROR_LOG file and retry the migration:
/usr/tandem/sqlmx/bin: migrate EXECUTE ALL
•
This example uses the PRELIMINARY REPORT and SHOW SCRIPT commands
to find and correct discrepancies before migration. The SHOW SCRIPT command
produces a script file that you can edit to correct the discrepancies reported by the
PRELIMINARY REPORT command. This example shows the contents of the script
file before and after editing. Comment lines are indicated with the “#” character:
/usr/tandem/sqlmx/bin: migrate PRELIMINARY_REPORT >prelim.out
/usr/tandem/sqlmx/bin: #Review prelim.out for information.
/usr/tandem/sqlmx/bin: migrate SHOW SCRIPT script.out
/usr/tandem/sqlmx/bin: cat script.out
== SQLMP ALIAS
CREATE SQLMP ALIAS cat.sch.t1 \TEXMEX.$DATA01.SQLDATA.T1;
CREATE SQLMP ALIAS cat.sch.t2 \TEXMEX.$DATA01.SQLDATA.T2;
== ----------------------------------------------------------
== Summary of MPALIAS Entries: 2 entries available for
migration
== ----------------------------------------------------------
/usr/tandem/sqlmx/bin: #Edit script.out and change catalogs,
schemas, and filenames as needed.
/usr/tandem/sqlmx/bin: cat script.out