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-12
Steps for Migrating PROCS and PARAMS Metadata
to 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 PROCS and
PARAMS 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 names of the volume and subvolume where the PROCS and
PARAMS tables reside.
3. To determine which SPJs to migrate, display the existing entries for SPJs in the
PROCS table by using the
SHOW PROCS command of the migrate utility, and
direct this information to a file:
/usr/tandem/sqlmx/bin: migrate SHOW PROCS > spj_info.out
The command displays this result:
4. Check for and report discrepancies in the SPJs to be migrated by using the
PRELIMINARY_REPORT command of the migrate utility, and direct this
information to a file:
/usr/tandem/sqlmx/bin: migrate PRELIMINARY_REPORT > reprt.out
SHOW: The following PROCS exist in the MP catalog...
...
Procedure PUBS.SUSAN.PRNTMETH
Procedure PUBS.SUSAN.STARS1
Procedure PUBS.SUSAN.STARS2
Procedure PUBS.SUSAN.STARS3
Procedure PUBS.SUSAN.STARS4
--------------------------------------------------------------------------
SHOW: Summary of Show Scan.
PROCS entries: 443 entries available for migration.
--------------------------------------------------------------------------