SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
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-3
Removes damaged objects and orphaned Guardian
files from an SQL/MX database.
FIXRCB Operation on
page 5-7
Performs RCB fixup for all required database objects
in catalogs that have an automatic reference on the
local system.
FIXUP Operation on
page 5-8
Fixes problems in the database and file labels
associated with an SQL/MX object.
GOAWAY Operation on
page 5-13
Removes Guardian files associated with SQL/MX
objects.
import Utility on page 5-18 Imports data from a file into an SQL/MX table.
INFO Operation on
page 5-53
Displays file information for Guardian files associated
with SQL/MX objects.
mxexportddl Utility on
page 5-55
Exports DDL and statistics information to an XML file.
MXGNAMES Utility
on
page 5-59
Converts ANSI table names into a list of
corresponding Guardian file names formatted for TMF
or BACKUP/RESTORE 2.
mximportddl Utility on
page 5-67
Imports DDL and statistics information from an XML
file.
MXRPM tool
on page 5-75 Reprocesses module files.
mxtool Utility on page 5-78 Performs FIXUP, GOAWAY, CLEANUP, INFO or
VERIFY operations.
VERIFY Operation
on
page 5-79
Reports whether SQL/MX objects and programs are
consistently described in file labels, resource forks,
and metadata.