SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-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-5
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-8 Duplicates SQL/MX files.
FASTCOPY Utility on
page 5-15
Copies rows from one table or index into an existing
compatible table or index.
FIXRCB Operation on
page 5-24
Performs RCB fixup for all required database objects
in catalogs that have an automatic reference on the
local system.
FIXUP Operation on
page 5-25
Fixes problems in the database and file labels
associated with an SQL/MX object.
GIVE SCHEMA Operation Transfers the ownership of the schema and, optionally
transfers the objects owned by the schema owner
from one user to another.
GOAWAY Operation on
page 5-31
Removes Guardian files associated with an SQL/MX
object.
import Utility on page 5-36 Imports data from a file into an SQL/MX table.
INFO Operation on
page 5-70
Displays file information.
MODIFY Utility
on
page 5-72
Performs partition management operations and
Guardian rename operations on tables and indexes.
mxexportddl Utility
on
page 5-96
Exports the DDL and statistics into the XML file.
MXGNAMES Utility
on
page 5-100
Converts ANSI table names into a list of
corresponding Guardian file names formatted for TMF
or BACKUP/RESTORE 2.