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-10

Steps for Migrating ODBC/MX Metadata to SQL/MX

Release 2.x

Steps for Migrating ODBC/MX Metadata to

SQL/MX Release 2.x

To use ODBC/MX metadata from SQL/MX Release 1.8 in SQL/MX Release 2.x, you

must migrate the metadata of the ODBC/MX tables. Use the

migrate utility to copy

metadata from the ODBC/MX tables (ZONAM2ID, ZOAS2DS, ZODS, ZOENV, and

ZORES) in the SQL/MP environment to the MXCS tables (NAME2ID, ASSOC2DS,

DATASOURCES, ENVIRONMENTVALUES, and RESOURCEPOLICIES, respectively)

in the SQL/MX environment.

These steps assume that you installed SQL/MX Release 2.x and that the ODBC/MX

tables reside 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 ODBC/MX

tables reside:

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

ODBC/MX tables reside.

3. To determine which system-level default settings exist in the ODBC/MX metadata

tables in the SQL/MP system catalog, use the

SHOW ODBC command of the

migrate utility and direct this information to a file:

/usr/tandem/sqlmx/bin: migrate SHOW ODBC > odbc_info.out

The command displays this result:

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

SHOW: The following ODBC tables exist in the MP catalog...

ZONAM2ID

ZOAS2DS

ZODS

ZOENV

ZORES

--------------------------------------------------------------------

SHOW: Summary of Show Scan.

ODBC entries available for migration.

--------------------------------------------------------------------------