SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Migrating an SQL/MP Database to NonStop SQL/MX
Release 2.1 or Release 2.0
HP NonStop SQL/MX Installation and Management Guide—523723-004
14-11
Steps for Migrating DEFAULTS Metadata From
Release 1.8 to Release 2.1 or Release 2.0
The migrate EXECUTE command captures information about the metadata
entries that fail to migrate to Release 2.1 or Release 2.0 and logs this 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 Step 5, 6, and 7.
Steps for Migrating DEFAULTS Metadata From Release 1.8 to
Release 2.1 or Release 2.0
These steps assume that you have upgraded a Release 1.8 environment to Release
2.1 or Release 2.0 and that the DEFAULTS table resides on the same node as
Release 2.1 or Release 2.0:
1. In the OSS environment, set these environment variables for the volume and
subvolume of the SQL/MP system catalog:
export SQLMX_NAMETYPE=NSK
export NSK_VOL=\$vol
export NSK_SUBVOL=subvol
vol and subvol are the names of the volume and subvolume where the
DEFAULTS table resides.
2. 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:
==*******************************************************************
== Error occurred: 2
CREATE SQLMP ALIAS ACC_SAMDBCAT.INVENT.PARTSUPP \POOH.$ODBC97.ACC.PARTSUPP
==*******************************************************************
== Error occurred: 2
CREATE SQLMP ALIAS ACC_SAMDBCAT.INVENT.VIEW207 \POOH.$ODBC97.ACC.VIEW207
Note. The migrate utility runs only on the OSS command line and is case-sensitive.
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.
--------------------------------------------------------------------------