SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-64
Considerations for mxexportddl
-O export-metadata-file-name [-C]
is the name of a OSS text file that will contain the export metadata output created
by mxexportddl. The file name is an OSS file that can include an optional path
specification. This file’s file type should be .xml.
If the output file exists and you do not specify the -C option, output is appended
to the existing file. The existing output file must have the proper XML export
metadata header tags.
If the output file does not exist, mxexportddl creates it.
If you do not specify export-metadata-file-name, output is written to the
standard output device.
Considerations for mxexportddl
You must be the super ID to run mxexportddl.
mxexportddl enables support staff to reproduce a customer’s metadata on Microsoft
Windows 2000 and the NonStop operating system so that developers can compile
queries and generate the same plans that a customer is using, to diagnose problems.
mxexportddl can import both SQL/MX Release 2.0 or greater metadata and
metadata related to SQL/MP tables that can be accessed from NonStop SQL/MX.
mxexportddl cannot obtain SQL/MP DDL for SQL/MP tables.
After you have captured this information, you can export the mxexportddl output file to
another system using BACKUP/RESTORE, by copying it to a CD or disk, or with other
methods.
Metadata Supported by mxexportddl
•
System defaults
•
Single catalog and schema
•
Tables and associated objects such as access paths, partitions, and indexes
•
Constraints: check, not null, primary key and unique
•
Table histogram data that includes histograms and histogram intervals
•
Stored procedures and parameters
•
SQL/MP alias tables
Metadata Not Supported by mxexportddl
•
Regular views and triggers
•
Multiple schemas
•
Referential constraints
mxexportddl creates an output XML file that provides a snapshot of a customer
schema. You can use this snapshot to monitor changes in DDL.