SQL/MX 2.x Reference Manual (H06.04+)

HP NonStop SQL/MX Reference Manual—540440-003
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
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-16
Removes Guardian files associated with an SQL/MX
object.
import Utility on page 5-21 Imports data from a file into an SQL/MX table.
INFO Operation on
page 5-40
Displays file information.
migrate Utility on page 5-42 Migrates metadata from previous versions to SQL/MX
Release 2.x.
MODIFY Utility on
page 5-47
Performs partition management operations on tables
and indexes.
mxexportddl Utility on
page 5-63
Captures DDL output for analysis
MXGNAMES Utility on
page 5-65
Converts ANSI table names into a list of
corresponding Guardian file names formatted for TMF
or BACKUP/RESTORE 2.
mxtool Utility on page 5-72 Performs FIXUP, GOAWAY, comment: INFO, or
VERIFY operations
POPULATE INDEX Utility
on page 5-73
Loads indexes.