SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

HP NonStop SQL/MX Reference Manual—523725-004
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 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
FIXUP Operation on
page 5-11
Fixes problems in the database and file labels
associated with an SQL/MX object
GOAWAY Operation on
page 5-15
Removes Guardian files associated with an SQL/MX
object.
import Utility on page 5-20 Imports data from a file into an SQL/MX table.
INFO Operation on
page 5-36
Displays file information.
migrate Utility on page 5-38 Migrates metadata from previous versions to SQL/MX
Release 2.x.
MODIFY Utility on
page 5-43
Performs partition management operations on tables
and indexes.
mxexportddl Utility on
page 5-59
Captures DDL output for analysis
MXGNAMES Utility on
page 5-61
Converts ANSI table names into a list of
corresponding Guardian file names formatted for TMF
or BACKUP/RESTORE 2.
mxtool Utility on page 5-68 Performs FIXUP, GOAWAY, comment: INFO, or
VERIFY operations
POPULATE INDEX Utility
on page 5-69
Loads indexes.