SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

HP NonStop SQL/MX Reference Manual—544517-008
5-1
5 SQL/MX Utilities
A utility is a tool that runs within NonStop SQL/MX or from the OSS shell and performs
such tasks as importing data, duplicating files, fixing database discrepancies, and
migrating metadata. SQL/MX utilities can be run from MXCI or from the OSS command
line.
For a description of MXCI, see MXCI SQL/MX Conversational Interface on page 1-2.
For more information about OSS, see the Open System Services User’s Guide.
You must be the owner of a schema to use BACKUP or RESTORE against SQL/MX
tables. For descriptions of the BACKUP and RESTORE commands, see the Guardian
Disk and Tape Utilities Reference Manual.
This section describes these SQL/MX utilities:
DUP Utility on page 5-4 Duplicates SQL/MX files.
FASTCOPY Utility on
page 5-11
Copies rows from one table or index into an existing
compatible table or index.
FIXUP Operation on
page 5-17
Fixes problems in the database and file labels
associated with an SQL/MX object.
GOAWAY Operation on
page 5-22
Removes Guardian files associated with an SQL/MX
object.
import Utility on page 5-27 Imports data from a file into an SQL/MX table.
INFO Operation on
page 5-61
Displays file information.
migrate Utility on page 5-63 Migrates metadata from previous versions to SQL/MX
Release 2.x.
MODIFY Utility on
page 5-68
Performs partition management operations on tables
and indexes.
mxexportddl Utility on
page 5-88
Exports the DDL and statistics into the XML file.
MXGNAMES Utility on
page 5-92
Converts ANSI table names into a list of
corresponding Guardian file names formatted for TMF
or BACKUP/RESTORE 2.
mximportddl Utility on
page 5-99
Imports the DDL and statistics from the XML file.
mxtool Utility on page 5-107 Performs FIXUP, GOAWAY, and comment: INFO or
VERIFY operations.
POPULATE INDEX Utility
on page 5-108
Loads indexes.