SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-88
mxexportddl Utility
mxexportddl Utility
Considerations for mxexportddl
Examples of mxexportddl
mxexportddl is an OSS command-line utility that captures the metadata and
statistics of SQL/MX objects and saves them in the XML format. This utility supports
OSS large files (files greater than 2 GB) as output files.
It is used to export the:
•
SQL/MX object metadata to an XML file for DDL replication
•
SQL/MX table statistics to an XML file for statistics replication
Exporting Metadata and Statistics of SQL/MX Objects
A catalog is a logical object; it is a collection of schemas. A schema is a logical objects
that has a collection of database objects such as tables, indexes, views, and stored
procedures.
•
Exporting a catalog includes exporting all the subordinate objects in its hierarchy
such as schemas, tables, and the subordinate objects of the tables.
•
To export objects on a remote node, the catalog must be registered using the
REGISTER CATALOG command. A catalog is not visible to a remote node until it
is registered.
•
Exporting a schema includes exporting all its subordinate tables, views, and stored
procedures.
•
Exporting a table includes:
°
Non-droppable constraints
°
Droppable constraints unless the CONSTRAINTS OFF option is enabled
°
All table partitions excluding data
°
All indexes and index partitions excluding data
°
All triggers and referential integrity constraints
°
Statistics of the table unless the STATS OFF option is enabled
•
Indexes cannot be explicitly specified in the mxexportddl utility. They are
subordinate to the table object and can only be exported with the parent table.
Note. The mxexportddl utility is enhanced and is available only on systems running
J06.07 and later J-series RVUs and H06.18 and later H-series RVUs.
The XML files generated by the older version of the mxexportddl utility cannot be imported
with the newer version of the mximportddl utility and vice versa.