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-9
Steps for Migrating DEFAULTS Metadata to SQL/MX
Release 2.x
3. To determine which system-level default settings exist in the DEFAULTS table in
the SQL/MP system catalog, use the
SHOW DEFAULTS command of the migrate
utility and direct this information to a file:
/usr/tandem/sqlmx/bin: migrate SHOW DEFAULTS >
defaults_info.out
The command displays this result:
4. Migrate the DEFAULTS entries from the SQL/MP metadata to the SQL/MX
metadata by using the
EXECUTE command of the migrate utility:
•
To migrate all entries from the DEFAULTS table, enter:
/usr/tandem/sqlmx/bin: migrate EXECUTE DEFAULTS
ERROR_LOG defaults_errors.out CLEAR
•
To migrate only DEFAULTS entries in the script file, enter:
/usr/tandem/sqlmx/bin: migrate EXECUTE SCRIPT
defaults_script.out
ERROR_LOG defaults_errors.out CLEAR
If you do not specify the name and OSS location of the error log file, the default is
error_log.out in the current directory. If you specify an existing error log file,
use the CLEAR option to direct the
migrate utility to clear the contents of the file
before adding information about migration errors. If the error log file already exists
and you omit the CLEAR option, the
migrate utility uses error_log.out.
5. Examine and resolve errors in the error log file. The
migrate EXECUTE command
captures information about the metadata entries that fail to migrate to SQL/MX
Release 2.x and logs the information in the error log file. Fix the errors in a script
file and run the
migrate EXECUTE SCRIPT command to migrate previously failed
metadata. See Steps 3 and 4.
Hewlett-Packard Nonstop (TM) SQL/MX Metadata Migration Utility 2.0
(c) Copyright 2003 Hewlett-Packard Development Company, LP.
SHOW: The following DEFAULTS exist in the MP catalog...
--------------------------------------------------------------------
SHOW: Summary of Show Scan.
DEFAULTS entries: 0 entries avaiable for migration.
--------------------------------------------------------------------------
Note. Because there are no discrepancies to report for the DEFAULTS table, it is not
necessary to use the PRELIMINARY_REPORT command to display discrepancies. Use the
SHOW SCRIPT command to generate a script file for editing purposes.