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-8
Steps for Migrating DEFAULTS Metadata to SQL/MX
Release 2.x
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.
8. Examine and resolve any 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 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 to
SQL/MX Release 2.x
To use system defaults from SQL/MX Release 1.8 in SQL/MX Release 2.x, you must
migrate the metadata of the system defaults. Use the
migrate utility to copy metadata
from the DEFAULTS table in the SQL/MP environment to the SYSTEM_DEFAULTS
table in the SQL/MX environment.
These steps assume that you installed SQL/MX Release 2.x and that the DEFAULTS
table resides on the same node as SQL/MX Release 2.x:
1. In an SQLCI session, enter the GET CATALOG OF SYSTEM command to display
the volume and subvolume of the SQL/MP system catalog where the DEFAULTS
table resides:
GET CATALOG OF SYSTEM;
Note the names of the volume and subvolume.
2. 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.
==*******************************************************************
== 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.