SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

HP NonStop SQL/MX Reference Manual—640322-001
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:
DOWNGRADE Utility on
page 5-4
Transforms all metadata that is visible on the local
node from its existing version to a specified lower
schema version.
DUP Utility on page 5-7 Duplicates SQL/MX files.
FASTCOPY Utility on
page 5-14
Copies rows from one table or index into an existing
compatible table or index.
FIXRCB Operation on
page 5-20
Performs RCB fixup for all required database objects
in catalogs that have an automatic reference on the
local system.
FIXUP Operation on
page 5-21
Fixes problems in the database and file labels
associated with an SQL/MX object.
GOAWAY Operation on
page 5-26
Removes Guardian files associated with an SQL/MX
object.
import Utility on page 5-31 Imports data from a file into an SQL/MX table.
INFO Operation on
page 5-65
Displays file information.
migrate Utility on page 5-67 Migrates metadata from previous versions to SQL/MX
Release 2.x.
MODIFY Utility on
page 5-72
Performs partition management operations on tables
and indexes.
mxexportddl Utility on
page 5-92
Exports the DDL and statistics into the XML file.
MXGNAMES Utility on
page 5-96
Converts ANSI table names into a list of
corresponding Guardian file names formatted for TMF
or BACKUP/RESTORE 2.
mximportddl Utility on
page 5-103
Imports the DDL and statistics from the XML file.