MX Release 3.2 (H06.25+, J06.14+)

Data source YOUR_DS, translate '14,15' -> '3'

...

The previous examples highlight the difference in output when you use the -d flag.

Creating the default catalog and schema for MXCS

After upgrading to SQL/MX Release 3.2, you must create the default catalog and schema for

MXCS. The default catalog is NONSTOP_SYSTEM_NSK. The default schema is

PUBLIC_ACCESS_SCHEMA.

To create the default catalog and schema, run the following script located at /usr/tandem/

sqlmx/bin:

.\InstallMXCS -loc \$volume

Where,

$volume is the name of an audited, non-SMF DAM volume.

For example,

.\InstallMXCS -loc \$data01

NOTE: When you create a fresh installation of SQL/MX Release 3.2, the InstallMXCS script

is executed automatically, and the default catalog and schema are created. You do not have to

run the script.

The NonStop SQL/MX Database Manager (MXDM) requires the default catalog and schema to

display table statistics.

For more information on why the default catalog and schema are required, see Viewing table

statistics and their properties in the HP NonStop MXDM User Guide for SQL/MX Release 3.2.

Uninstalling MXCS from the Server

To uninstall MXCS components from the server, you must:

1. Stop the MXCS service.

2. Remove the object files from the installation subvolume.

Creating the default catalog and schema for MXCS 25