SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Tables to SQL/MX Tables
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
5-19
SQL/MX Utilities
For more information about SQL/MX utilities, see the SQL/MX Reference Manual. For
more information about managing a SQL/MX database, see the
SQL/MX Installation
and Management Guide.
Table 5-7. New SQL/MX Utilities
SQL/MX Utility
Execution
Environment Function
import OSS or MXCI Imports data from an input file in ASCII or
UCS2 format into a SQL/MX table.
migrate OSS Copies metadata from SQL/MX Release 2.x
into SQL/MX Release 3.0 system metadata
tables.
MODIFY MXCI Performs partition operations on range and
hash partitions of SQL/MX tables and
indexes. The SQL/MX MODIFY utility does
not have the DDL extensions as the SQL/MP
MODIFY utility does.
mxexportddl OSS Captures SQL/MX metadata and saves it in
XML format for diagnosing problems.
MXGNAMES Guardian Converts one or more ANSI table names into
a list of corresponding Guardian file names,
appropriately formatted for TMF or Backup
and Restore 2.
mxtool: OSS Performs various utility operations.
FIXUP operation OSS Repairs problems in the SQL/MX database
that cannot be repaired by normal operations.
GOAWAY operation OSS Removes Guardian files associated with a
SQL/MX database object.
INFO operation OSS Displays information about SQL/MX files,
such as the Guardian file name, ANSI name,
ANSI namespace, and object schema
version.
VERIFY operation OSS Reports whether SQL/MX database objects
and applications are consistently described in
file labels, resource forks, and metadata.
POPULATE INDEX MXCI Loads SQL/MX indexes with data from the
associated table.
RECOVER MXCI Determines the state of a failed utility
operation and executes its recovery
procedure.