SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-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.
For descriptions of the BACKUP and RESTORE commands, see the Guardian Disk
and Tape Utilities Reference Manual.
This section describes these SQL/MX utilities:
CLEANUP Operation on
page 5-5
Removes damaged objects and orphaned Guardian
files from an SQL/MX database.
DOWNGRADE Utility on
page 5-9
Transforms metadata from the existing version to a
specified, lower version.
DUP Utility on page 5-14 Duplicates SQL/MX tables.
FASTCOPY Utility on
page 5-21
Copies rows from one table or index into an existing
compatible table or index.
FIXRCB Operation on
page 5-29
Performs RCB fixup for all required database objects
in catalogs that have an automatic reference on the
local system.
FIXUP Operation on
page 5-30
Fixes problems in the database and file labels
associated with an SQL/MX object.
GIVE SCHEMA Operation
Transfers the ownership of a schema, and optionally
the ownership of objects within the schema owned by
the schema owner from one user to another.
GOAWAY Operation on
page 5-37
Removes Guardian files associated with SQL/MX
objects.
import Utility
on page 5-42 Imports data from a file into an SQL/MX table.
INFO Operation on
page 5-77
Displays file information for Guardian files associated
with SQL/MX objects.
MODIFY Utility
on
page 5-79
Performs partition management operations and
Guardian rename operations on tables or indexes.
mxexportddl Utility
on
page 5-103
Exports DDL and statistics information to an XML file.